105
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
I have the same question (0)
Hi,
Please use the following job to get the intended data and let me know if anything is missing.
Share
Report
All responses (
Answers (
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));
}
}
