Sales Price & Purchase Price

Dear All

How I load Sales Price & Purchase Price in AX2012 through excel & which table is used.

Warm Regards

Hi MS,

Sales and Purchase prices are stored in two place… one is on item group itself and other on trade agreement.

If you need to import it on the item master, then you need to update inventtablemodule else trade agreement. If price is updated on item master, then you can do it at the time of item upload only.

Trade agreement in AX 2012 is not that simple. Once you have imported trade agreement, you need to post it also. In one of the implementation, we wrote a script to import the trade agreement. Not sure if current data migration tool supports that.