Hi Everyone! Just started AX a couple of months ago. Trying to get a handle where data is stored and how to get to it. First one seems simple enough, but struggling with find information.
In the Products list, an item has an associated NMFC number. This number is visible in the released products view, but it is not editable, it is a copy of the product from the product table. So where (what table) is the item (linked to product) stored that acutally has the NMFC number. First simple task: Verify that what is in AX is absolutely correct by generating list of consisting of three simple fields: ItemId, Product Name/Description, and the NMFC code assigned, so I can export to excel an have someone verify.
Thanks for any insight you can provide.
*This post is locked for comments
I have the same question (0)Hi Charlie,
Did you check the option to export the data using the Data management workspace? You can use the entity 'Products'. When there is a difference between your product numbers and item numbers (released product), then you would also need the 'Released products' entity and link data in e.g. Excel
Syed Haris Shah
9
Martin Dráb
2
Most Valuable Professional
Community Member
2