Saturday, 12 April 2014

Release products using Data import export framework [AX 2012]

This is a question I hear quite often. When you import products how do you release the product to your multiple companies. Do you have to import it?

The answer is quite simple but well hidden. No – you don’t have to import to the other companies.

There is a field in the staging table called ReleaseProductCompany. If you pass the company name with a separator. Then on insert or update it will release it to those companies.

P2014-04-12_1656

The separator can be found on the Source data formats.

S2014-04-12_1650

Finally here is a screenshot of the code that releases the product into the companies.

C2014-04-12_1647

4 comments:

Anonymous said...

Great post. question how can you update values that are specific to each company such as purchase, sales or inventory units? I was able to release the item to each company however only one company gets my purchasing, sales and inventory units.

Munib Ahmed said...

Sorry but I dont know without spending time to have a look.
I havent done imports for a long time now. So, I am a little rusty again.

Munib Ahmed said...

Sorry but I dont know without spending time to have a look.
I havent done imports for a long time now. So, I am a little rusty again.

Anonymous said...

I think that to update legal entity specifics, you'll need to use 'Items' entity to update the InventTable and import each entity within the context of the appropriate entity