Export Delivery Summary (DS) Dengan Model Template (Custom)

Apabila Anda ingin melakukan export Delivery Summary atau Rekap Surat Jalan secara custom maka Anda dapat mengikuti langkah-langkah berikut ini:

Export Delivery Summary (DS) Dengan Model Template (Custom)

Step 1: Kunjungi halaman Delivery Model Template dengan mengunjungi link https://app.simplidots.co.id/condensed/deliverymodeltemplate

Menu ini tidak ditampilkan sehingga harus diakses manual dengan menggunakan: {url-simplidots}/condensed/deliverymodeltemplate}

Step 2: Klik tombol + Tambah model Template.

Step 3: Pada pilihan Model, silakan pilih DeliveryOrder.

Step 4: Pada pilihan Method, silakan pilih Export.

Step 5: Pada Model Mapper Json, silakan diisi dengan ketentuan yang diinginkan.

Contoh Model Mapper Json

{
    "CustomDeliverySummaries": [
        {
            "DeliverySummaries": {
                "CustomDeliverySummaryNo": "DeliverySummaryNo",
                "CustomDate": "Date",
                "CustomStatus": "Status",
                "CustomDONumbers": "DONumbers",
                "CustomFleetName": "FleetName",
                "CustomPlatNumber": "PlatNumber",
                "CustomLoad": "Load",
                "CustomLoadCapacity": "LoadCapacity",
                "CustomPercentageCapacity": "PercentageCapacity",
                "CustomDriverCode": "DriverCode",
                "CustomDriverName": "DriverName",
                "CustomHelperCode": "HelperCode",
                "CustomHelperName": "HelperName",
                "CustomStartMileage": "StartMileage",
                "CustomEndMileage": "EndMileage",
                "CustomDistanceTraveled": "DistanceTraveled",
                "CustomFuelConsumption": "FuelConsumption",
                "CustomTotalEstimatedDeliveryTime": "TotalEstimatedDeliveryTime",
                "CustomTotalActualDeliveryTime": "TotalActualDeliveryTime",
                "CustomNotes": "Notes"
            }
        }
    ],
    "CustomDeliverySummaryItems": [
        {
            "DeliverySummaryItems": {
                "CustomDeliverySummaryNo": "DeliverySummaryNo",
                "CustomProductCode": "ProductCode",
                "CustomProductName": "ProductName",
                "CustomUnitL": "UnitL",
                "CustomUnitM": "UnitM",
                "CustomUnitS": "UnitS",
                "CustomQuantity": "Quantity",
                "CustomQuantityL": "QuantityL",
                "CustomQuantityM": "QuantityM",
                "CustomQuantityS": "QuantityS",
                "CustomLength": "Length",
                "CustomWidth": "Width",
                "CustomHeight": "Height",
                "CustomNotes": "Notes"
            }
        }
    ],
    "CustomDeliveryOrders": [
        {
            "DeliveryOrders": {
                "CustomDeliveryOrderNo": "DeliveryOrderNo",
                "CustomDate": "Date",
                "CustomDeliveredLatitude": "DeliveredLatitude",
                "CustomDeliveredLongitude": "DeliveredLongitude",
                "CustomCheckInLatitude": "CheckInLatitude",
                "CustomCheckInLongitude": "CheckInLongitude",
                "CustomSalesOrderNo": "SalesOrderNo",
                "CustomCustomerCode": "CustomerCode",
                "CustomCustomerName": "CustomerName",
                "CustomCustomerAddress": "CustomerAddress"
            }
        }
    ],
    "CustomDeliveryOrderItems": [
        {
            "DeliveryOrderItems": {
                "CustomDeliveryOrderNo": "DeliveryOrderNo",
                "CustomProductCode": "ProductCode",
                "CustomProductName": "ProductName",
                "CustomQuantityToDeliver": "QuantityToDeliver",
                "CustomQuantityDelivered": "QuantityDelivered",
                "CustomLength": "Length",
                "CustomWidth": "Width",
                "CustomHeight": "Height"
            }
        }
    ]
}

Step 6: Klik tombol Simpan.

Step 7: Model Template berhasil tersimpan jika muncul popup notifikasi Data saved successfully.

Step 8: Model Template yang dibuat akan muncul pada halaman Model Template.

Step 9: Ulangi tahap Export Delivery Summary (DS) Tanpa Model Template (Normal) namun yang diekspor adalah DeliveryOrder karena contoh ini adalah untuk DeliveryOrder.

Export Delivery Summary (DS) Tanpa Model Template (Normal)

Kali ini, kolom yang akan dikembalikan pada Excel akan sama seperti dengan apa yang ada pada Model Mapper Json.

Selamat mencoba, Kawan Simpli :)