Product documentation
Important
In 10.0.37 the logic for the fields PONumber and LineNumber had to be changed to support receipts of the same PO line on multiple pallets. In the past the PONumber field contained a combination of purchase order number, line number and a record ID. Now the PONumber field only contains the order number. The line number * 1000 is exported in the LineNumber. Multiple receipts of the same line number will now be numbered 1000, 1001, 1002 etc.
The data in the staging table Purchase order history (only that table!) must be deleted with the DYSSlim4ServicesAdmin form. The existing data set for Historical PO (only that table) in Slim4 Integration must first be deleted. Then change the parameter Days historical purchase orders to the desired value. Update export data including the Purchase order history and Run export project = yes will rebuild the historical PO. Now Slim4 Integration can rebuild the Historical PO again. Finally, set the parameter Days historical purchase orders back to the original value. In case you do not follow the procedure, there will be a unlogical situation for purchase order lines that were received partially in the old situation, and partially in the new situation. From Microsoft Dynamics 365 for Finance and Operations perspective this is not a problem, but it may lead to inconsistencies in the historical PO in Slim4 Integration.
Please contact the Slim4 Integration consultant.
This webservice returns the historic supplies transactions:
{{resource}}/api/POHistory
{{resource}}/api/POHistory?Page=2
|
Attribute |
Description |
Field type |
Microsoft Dynamics 365 for Finance and Operations field |
Remark |
|
Warehouse |
Warehouse |
String(20) |
Warehouse |
|
|
ArticleCode |
Article code (SKU) |
String(40) |
Released product (Released product variant) |
|
|
PONumber |
This is the Purchase Order number, purchase agreement, transfer receipt, production order |
String(100) |
Purchase order Transfer order Production order BOM journal |
From 10.0.37 onwards, this is only the order number |
|
LineNumber |
Line number of the order |
Integer |
Purchase order line number *1000 Transfer order line number * 1000 Production: 1000 BOM journal line number *1000 |
In case there are duplicate line numbers, the next higher number is used |
|
OrderTypeNumber |
Type of the order |
Integer |
Purchase order: 1 Transfer order receipt: 3 Production order receipt: 4 BOM journal receipt: 4
|
|
|
DeliveredDate |
Date on which stock was received |
YYYYMMDD |
Physical receipt date (InventTrans.DatePhysical)
|
|
|
DeliveredQuantity |
Actual quantity received on the order |
Integer |
Received quantity (Sum InventTrans.Qty) |
|
|
Supplier |
Vendor and name or shipping warehouse and name |
String(100) |
Vendor account and name Shipping warehouse and name |
|
|
POComment |
This is the comment associated with the purchase order number, either from the header or line PO line, or can be used for order details, such as shipping conditions, delivery address or conditions related to the order. |
String(4000) |
Purchase order: external item ID |
|
|
FreeText1 |
This is a free text field that can be used to show remarks or information related to the purchase order, e.g. shipping conditions, delivery address or conditions related to the order. |
String(255) |
Field mapping |
|
|
FreeText2 |
Idem |
String(255) |
Field mapping |
|
|
FreeNumber1 |
This is a free numeric field that can be used to show numeric information related to the purchase order, e.g. order line number, number of items on the order, other article codes on the order, number of items already received from the order. |
Num(15,4) |
Field mapping |
|
|
FreeNumber2 |
Idem |
Num(15,4) |
Field mapping |
|
|
OrderedDate |
Date on which the order was created. Used for calculating the lead time of the historical purchase order / transfer receipt / production order / BOM journal receipt |
YYYYMMDD |
CreatedDateTime |
|
|
RequestedDate |
Date on which the order was requested to be delivered from the supplier or shipping warehouse or production department. |
YYYYMMDD |
PurchLine.DeliveryDate InventTransferLine.ReceiveDate ProdTable.CreatedDateTime InventJournalTrans.CreatedDateTime |
|
|
OrderedQuantity |
Quantity that was originally ordered on the purchase order / transfer order / production order / BOM journal |
Integer |
PurchLine.QtyOrdered (inventory unit) InventTransferLine.QtyTransfer ProdTable.QtySched InventJournalTrans.Qty |
|
|
RequestedQuantity |
Quantity that was originally requested on the purchase order / transfer order / production order / BOM journal |
Integer |
PurchLine.QtyOrdered (inventory unit) InventTransferLine.QtyTransfer ProdTable.QtySched InventJournalTrans.Qty |
|
|
ConfirmedQuantity |
Quantity that was originally confirmed on the purchase order / transfer order / production order / BOM journal |
Integer |
PurchLine.QtyOrdered (inventory unit)
InventTransferLine.QtyTransfer ProdTable.QtySched InventJournalTrans.Qty |
|
|
ConfirmedDate |
The date that was confirmd by the supplier |
YYYYMMDD |
PurchLine.ConfirmedDlv InventTransferLine.ReceiveDate ProdTable.SchedEnd |
|
|
SupplierNumber |
This is the number of the supplier or shipping warehouse |
String(20) |
Purchase order: Vendor account Transfer order: From-warehouse ID |
|
|
SupplierName |
This is the name of the supplier associated with the code above. |
String(60) |
Purchase order: Vendor name Transfer order: From-warehouse name |
|
|
BuyingPrice |
This is the buying price of the item on the purchase order |
Num(15,4) |
Purchase order line price for 1 inventory unit, converted to company currency Production and Transfer order: costprice for 1 inventory unit |