web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Item Grouping
Microsoft Dynamics AX (Archived)

Item Grouping

(0) ShareShare
ReportReport
Posted on by Community Member

I want to evaluate the material used on production order BOM's for the past year. We use many different materials and it is nearly impossible to go through each transaction individually. Is there any way I can group the same materials together and see their total quantity used on BOM's in the last year? Right now when I view the Warehouse Transactions Detail Report and Sales BOM Consumption History Report, the items are arranged by date. I want to sum the quantities of each item number for the whole year and view the total quantity used for each item in AX 2009. Thank you in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Nagendra Varma K Profile Picture
    Nagendra Varma K on at

    HI Blake,

    We had similar request from the customer, What we did is we bought Item Group along with the Item Number in the Report BOM Consumption Report. So that when you generate report User can filter by Item group and sump the total quantity in Excel.  May be you need technical help for this.

    Is your Items grouped as per the same material type or in a different nature to identify the same materials?

    Thanks

    Nagendra Varma K

  • Community Member Profile Picture
    Community Member on at

    In the Sales BOM Consumption History Report the material is listed by the date it was consumed. I exported the report to Excel and organized it by item number but the report doesn't give the total amount of material used, just the number of parts the material produced on the certain production order.

    I need to see the total amount of each material used for the last year, now that I have them organized by their item number.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Blake,
    Open Transaction form from Stock Management - Inquiries - Transactions - Transactions
    Apply filter on:
    * Issue Status column Sold, Deducted 

    * Physical date column 1/1/2016..31/12/2016

    *Number column with your production work order prefix*

    Export the table into excel and insert pivot table to sum your quantities.

    You might need to add additional column of BOM part numbers that match your production work orders to get the data you need.
    Regards,
    V

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans