sum up item quantity of several BOMs

(4) Share

Report

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

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Mohamed Amine Mahmoudi 26,447 Super User 2025 Season 2 on at

Like (0)

Report

Hi @JCHI,

As far as I know, standard doesnt offer this kind of functionality and requires customization.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
André Arnaud de Cal... 301,196 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Saif Ali Sabri 2,351 Super User 2025 Season 2 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
JCHI 334 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No