Skip to main content

Notifications

Announcements

No record found.

Import product / item using data entities in Microsoft dynamics 365 finance and operations one version

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

Comments

*This post is locked for comments