Import product / item using data entities in Microsoft dynamics 365 finance and operations one version
Sequence |
Entity |
Staging table |
Target entity |
Notes for import |
1 |
Products V2 |
EcoResProductV2Staging |
EcoResProductV2Entity |
Needed irrespective of product or product master creation and is the first step |
2 |
Released products V2 |
EcoResReleasedProductV2Staging |
EcoResReleasedProductV2Entity |
For regular products without variants can directly import released products once products are available |
Sharing key and mandatory information needed for products
PRODUCTNUMBER |
PRODUCTCOLORGROUPID |
PRODUCTDESCRIPTION |
PRODUCTDIMENSIONGROUPNAME |
PRODUCTNAME |
PRODUCTSEARCHNAME |
PRODUCTSUBTYPE |
PRODUCTTYPE |
Sharing key and mandatory information needed for released products (assuming using advanced WMS)
PRODUCTNUMBER |
PRODUCTSUBTYPE |
ITEMNUMBER |
APPROVEDVENDORCHECKMETHOD |
ARETRANSPORTATIONMANAGEMENTPROCESSESENABLED |
BASESALESPRICESOURCE |
DEFAULTORDERTYPE |
INVENTORYRESERVATIONHIERARCHYNAME |
INVENTORYUNITSYMBOL |
ITEMMODELGROUPID |
PRODUCTGROUPID |
PRODUCTSEARCHNAME |
SEARCHNAME |
PRODUCTTYPE |
SALESUNITSYMBOL |
STORAGEDIMENSIONGROUPNAME |
TRACKINGDIMENSIONGROUPNAME |
UNITCONVERSIONSEQUENCEGROUPID |
*This post is locked for comments