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.

• Prio 1: lead time as specified in the vendor specific order settings for this combination of vendor, item and warehouse
• Prio 2: lead time as specified in the default order settings

 

The order margin can be specified on the coverage group.

 

Note that if the delivery date is earlier than today + lead time + order margin, Microsoft Dynamics 365 for Finance and Operations will automatically update the delivery date to today + lead time + order margin.

 

{{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.

 

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.