Item with Inventory Unit, Sales Unit and Purchase Unit

(0) Share

Report

Posted on by Community Member

Need to retrieve Item with Inventory Unit, Sales Unit and Purchase Unit to Excel worksheet by OLE DB query. Need to know the Dynamics AX 2012 tables name (and relation) to write query string.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ColbyGallagher 3,666 on at

Like (0)

Report

InventTableModule is the table, ModuleType tells you if its Sales / Inventory / Purchase, and UnitID is the Unit. You can get it through the add-in in Excel, you don't need to use an OLEDB query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you. InventTableModule is the exact table I need. How can I get the unit conversion between inventory unit, sales unit and purchase unit? Which table(s) I need to retrieve conversion number? Thank you.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

You could navigate to the form (Organisation administration > Setup > Units > Unit conversions), right click the field you are interested in, select Personalise, then you would see the value in the System name field. You will never have to ask again for the table/field, you could just dig it out yourself (unless it is a view, or a display/edit method). In this case you'd get the UnitOfMeasureConversion table.

Was this reply helpful? Yes No
ColbyGallagher 3,666 on at

Like (0)

Report

UnitOfMeasure and UnitOfMeasureConversion are the tables, but I doubt you'll be able use these tables easily. AX allows you to have an inventory unit in Grams, and a selling Unit of Pounds. There is no direct relationship defined int the UnitOfMeasureConversion table between Grams and Pounds. Instead, AX relies on the UnitOfMeasureConverter class and UnitOfMeasureConverter_Product class to traverse UnitOfMeasureConversion.

Was this reply helpful? Yes No