Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Released product report with unit of measure?

Posted on by 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

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Released product report with unit of measure?

    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));
        }
    }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans