Data is not inserting in 'Price' and 'Unit' of Sales, purchase and invent of item master using 'Product' data entity in AX 2012 R3

(0) Share

Report

Posted on by Sangram Shinde

2,120

Hi Folks,
We are trying to import item master data using Product entity, products are importing fine in AX but values are not inserting in price and unit fields of sales, purchase and invent
There is one to one simple mapping like below.
InventTableModuleInvent_Price,InventTableModuleInvent_UnitId,InventTableModulePurch_Price,
InventTableModulePurch_UnitId,InventTableModuleSales_Price,InventTableModuleSales_UnitId

We did try debugging, data is inserting in staging table but we can't see in 'target' buffer while execution, it populates value 0 instead of what we are passing.

There are some customization done in DMFProductEntityClass but that is not related to this tables.

So where do we exactly check- why the staging data is not populating in 'target' buffer.
Any response is appreciated.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sangram Shinde 2,120 on at

Like (0)

Report
Copy link

Link copied!

Hi Techies,

The funny thing happened, there were two mappings in target entity for all these fields, that's why it is overwriting the values and importing 0 instead of what we are passing. But the filter has to be applied on 'Target field' to check these duplicates.

Thanks!

Was this reply helpful? Yes No