Product documentation
In This Topic
    Planned orders webservice definition
    In This Topic

    This webservice submits planned orders into Microsoft Dynamics 365 for Finance and Operations.

    The planned orders are imported in a staging table (company independent), and can be processed to MRP planned orders in batch or immediately, depending on the Slim4 integration parameter Import.

    Additional import data fields are visible in the Planned order import.

    Due to the batch process, it can take a few minutes until the planned orders are visible.

     

    Note that one warehouse ID should only be active for  Slim4 in one legal entity.

    If a planned order is received, the delivery date from the webservice request is used, and the order date is calculated as delivery date -/- lead time -/- order margin.

     

    The order margin can be specified on the coverage group.

     

    {{resource}}/api/Import

     

    Attribute

    Description

    Field type

    Microsoft Dynamics 365 for Finance and Operations field

    Remark

    Warehouse

    Warehouse

    String(20)

    Warehouse

    DisplayProductNumber

    Article code (SKU)

    String(40)

    Released product (Released product variant)

    Quantity

    Planned order quantity

    Integer

    Planned quantity (inventory units)

    VendId

    Supplier

    String(20)

    Vendor account

    Optional   

    ReqDate

    Delivery date

    YYYYMMDD

    Requested receipt date in this warehouse

     

    TransferWarehouse

    Warehouse from which the article must be transfered

    String(20)

    From warehouse

    Optional

    MyAdditionalField1..n

    Additional import field (beta) that can be mapped through customization

    String(20)

    Planned order import additional data

    Optional

     

    If optional data are not filled, the same fallback is used as when manually entering a planned order in the master planning.

     

    Example data Planned orders for Contoso USMF.

    {
        "data": [
            {
                "TransferWarehouse": "62",
                "Warehouse": "11",
                "DisplayProductNumber": "D0013 :  : M :  :",
                "Quantity": 10.00,            
                "ReqDate": "20230623"
            },
            {
                "Warehouse": "11",
                "DisplayProductNumber": "A0001",
                "VendId": "US-104",
                "Quantity": 32.00,
                "ReqDate": "20230830"
            },
            {
                "Warehouse": "62",
                "DisplayProductNumber": "D0003",
                "Quantity": 24.00,            
                "ReqDate": "20230930",
                "MyRemark": "Special"
            }
        ]
    }

     

    Minimum and maximum inventory levels 

    Slim4 Integration can calculate advised minimum and maximum inventory levels per item and warehouse, and can export these as a flat txt file or Excel/csv file.

    For the weekly or monthly import of Min/Max inventory levels, in Microsoft Dynamics 365 for Finance and Operations use DMF with data entity Item coverage V2.