This macro is part of the DirectSQL integration and imports RawmaterialTransactions according to the settings for DirectSQL in combination with the parameters selected below.
Example parameter configuration
Parameter descriptions
(* = configuration required)
deleteNonImportedTransaction
If = true transactions that are not imported will be deleted
forewardFromToday
If = true only transactions forward from today will be included
inventoryQuery
a custom SQL query for the inventory may be included here
lastChanged
Internal use only. Don’t change.
lastUpdated
Internal use only. Don’t change.
materialType
Defines the type of materials to import.
Default -1 = all types.
0 = rawmaterial
1 = resource/tool
2 = semifinished product
3 = finished product
4 = recipe
purchaseQuery
a custom SQL query for the purchases may be included here
readInventories
If = true inventories will be included
readPurchases
If = true purchases will be included
readShipments
If = true shipments will be included
shipmentQuery
a custom SQL query for the shipments may be included here
Post your comment on this topic.