I am trying to build a BAQ that calculates how many of each top level part (finished good) can be built based on a multilevel BOM and current inventory. Attached is a BAQ that uses recursion to explode the BOM and calculate how much of each material is needed for the top level part. The excel file …

I would tell you to review @timshuwy ’s bom_explode baq which does this in reverse as in can I build X, maybe it can help you. [image] Build BOM in Query Epicor ERP 10 This CAN be done… but it takes a RECURSIVE (CTE) BAQ. I have demoed this in the past at user group meetin…

There is a standard Kinetic report that does this. It’s called Part Availability.

Hi Mark, it is available since which version? i can’t find it in my 2022.2.4

Vantage 8. It’s under Production Management | Engineering Management. Search the word Availability.

The availability report requires a part number and desired quantity to run it. It also does not roll up the quantity that can be assembled. The items that are not in stock but can still be manufactured are displayed as exceptions. I want to be able to run it for an entire product group at once and …

Running a time phased demand across multiple parts and the same time is what MRP does. The Availability report is not nearly complete as it does not look at demand for other top level parts. You may want to also look at Available To Promise for the sales team.

How to calculate how many of a top level part can be built based on current inventory

Kinetic ERP

gpayne (Greg Payne) January 13, 2024, 2:40am 2

I would tell you to review @timshuwy’s bom_explode baq which does this in reverse as in can I build X, maybe it can help you.

Topic		Replies	Views
Multi-level BOM Open Order Quantity BAQ Logic Kinetic ERP	8	2171	October 1, 2022
BAQ-DashBoard Question Kinetic ERP	12	1635	February 3, 2023
Intendet BOM total demand Kinetic ERP baq	2	465	March 31, 2022
Build BOM in Query Epicor ERP 10 baq	28	13737	August 14, 2024
BAQ that shows material part demand Epicor ERP 10 baq , dashboard , part	2	1135	October 17, 2023

How to calculate how many of a top level part can be built based on current inventory

Related topics