Hello,
We are curious if there is a way to pull a report that would show us the following:
- Item Number
- Product Name
- Inventory unit of measure
We have searched through the released products section under Product Information Management and attempted to customize the report view, but could not find a definite resolution.
*This post is locked for comments
Hi,
Please use the following job to get the intended data and let me know if anything is missing.
static void AXC_UnitOfMeasure(Args _args) { InventTableModule inventTableModule; InventTable inventTable; EcoResProduct ecoResProduct; while select inventTable //where inventTable.itemid == "XYZ" // Specify your required ItemId/product join ecoResProduct where inventTable.Product == ecoResProduct.RecId join inventTableModule where inventTableModule.ItemId == InventTable.ItemId { info(strFmt("Item Number: %1, Product Name:%2, Module: %3, UnitOfMeasure:%4", inventTable.itemid, ecoResProduct.productName(), inventTableModule.ModuleType, inventTableModule.UnitId)); } }
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,912 Super User 2024 Season 2
Martin Dráb 229,355 Most Valuable Professional
nmaenpaa 101,156