Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / sum up item quantity o...
Finance | Project Operations, Human Resources, ...
Answered

sum up item quantity of several BOMs

(4) ShareShare
ReportReport
Posted on by JCHI 334
hi all 
 
We are using AX2012 CU9,
I'd like to sum up several BOMs item quantity
(EX:
2 item1 in BOM1
3 item1 in BOM2
then we get 5 item1  for all items in several BOM)
 
Are there any functions like demand predictions able doing it?
 
thanks
Categories:
Microsoft Dynamics AX
  • Ramesh Kumar Profile Picture
    Ramesh Kumar 3,501 on at
    sum up item quantity of several BOMs
    I doubt standard system offer this kind of functionality or rules.
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • JCHI Profile Picture
    JCHI 334 on at
    sum up item quantity of several BOMs
    Hi André
     
    We are trying to calculate item usage of some old production orders.
    Ex: PO1 (BOM1) + PO2 (BOM2) + PO3(BOM3) are all finished production orders.
     
    we plan to produce same product of PO1,PO2,PO3 ,  we want to calculate how many items needed to purchase or produce in advanced. something like that.
     
     
    Thank you for the replay!
     
     
     
  • Verified answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 1,932 Super User 2025 Season 1 on at
    sum up item quantity of several BOMs
    There’s no direct built-in function like demand forecasting for this specific need, so a custom query or report is the best approach.

    • Use a Query or SQL Script:

      • Join BOM, BOMVersion, and InventTable to get item quantities across BOMs.
      • Example SQL: 
        sql
        SELECT B.ItemId, SUM(B.Qty) AS TotalQty
        FROM BOM B
        JOIN BOMVersion BV ON B.BOMId = BV.BOMId
        WHERE BV.Active = 1
        GROUP BY B.ItemId;

        •  

    • Use an AX Query in AOT:

      • Create a query on the BOMConsistOfLevel table.
      • Aggregate quantities per ItemId using a calculated field.

    • Use the Explosion Framework:

      • Run BOMCalc or BOMExplode in BOM Calculation to analyze demand across multiple BOMs.

        •  

    • Custom X++ Code:

      • Iterate through BOMConsistOfLevel and sum quantities using a temporary table.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at
    sum up item quantity of several BOMs
    Hi JCHI,
     
    What is the business process you try to solve here? For what reason do you need to sum the quantities? Is this about the BOM definition or production specific BOMs?
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 22,136 Super User 2025 Season 1 on at
    sum up item quantity of several BOMs
    Hi @JCHI,
     
    As far as I know, standard doesnt offer this kind of functionality and requires customization.
     
    Best regards,
    Mohamed Amine MAHMOUDI

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,013 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans