Hi Epicor Team, Can anybody guide me an idea on how to build a dashboard that shows indented BOM with Routing for all sales order line items? This is to get an idea on our order intake per week Jay

I did built that rudimentry BAQ based on the tutorial but there are couple of things that I couldn’t figured out. I am struggling a little bit with revision (getting the latest REV) and also how to connect it to the sales order line items. In addition how to make sure that I stop when the part is pu…

[image] JayKrishna: I am struggling a little bit with revision (getting the latest REV) That’s going to be an aggregate function like Max(PartRev.Effectivedate) or something like that. You’ll make a calculated field for that. [image] JayKrishna: In addition how to make sure that I stop w…

Thanks Brandon. How do I connect it to the sales line item? This is the format I am looking at OrderNum OrderLine OrderDate RequestDate PartNum MtlPartNum OpCode OpHours 116445 1 1/17/2019 1/22/2019 10898-01 10898-01 BG0070 0.12 116445 1 1/17/2019 1/22/2019 10898-01 10898-01 BG0080 0.25 …

WITH [SaleData] as ( select a.PartNum, a.OrderNum, a.OrderLine, oh.OrderDate, oh.RequestDate, a.SellingQuantity from orderdtl a join OrderHed as oh on oh.OrderNum = a.OrderNum join part h on a.partnum = h.partnum left join PartPlant f on f.partnum = a.partnum and f.plant = 'BG' left jo…

This is what I got, it runs fine in the SSMS but timesout in BAQ mode

Can you reformat your code block please? [image] Code Syntax Highlighting in Posts FAQ The test below ```cs public void test() { MessageBox.Show("testing"); } ``` will produce public void test() { MessageBox.Show("testi…

Before we get any farther on this. When you get your orders do you create your jobs right away? And are your jobs constructed so that you make everything for the order on the job (of the manufactured parts). And do you make your jobs to order? If that is the case, then it would be easier to query t…

Does it work if you limit it to one sales order? It looks like you are running it for every open sales order in your system.

No. It doesn’t work for even one sales order. I kind of think I am over complicating things here

That is the difficult none of the jobs are make to order. Everything is made to stock so only way to get the information through the method of the part on order

Help with building a BAQ that shows indented BOM for all open sales line item

Epicor ERP 10

Banderson (Brandon Anderson) January 21, 2019, 1:59pm 8

Can you reformat your code block please?

Topic		Replies	Views
Build BOM in Query Epicor ERP 10 baq	28	13805	August 14, 2024
Assign Parent/Child Heirarchy in Indented BOM BAQ Epicor ERP 10 baq	7	1213	April 26, 2023
BAQ Question for keeping results separate Epicor ERP 10 baq	44	3017	January 27, 2023
~If you want to recursively traverse the BOM you may need a CTE query?~ Kinetic ERP baq	43	13363	November 1, 2021
Indented BOM in a BAQ Epicor ERP 10 baq	3	2395	January 21, 2022

Help with building a BAQ that shows indented BOM for all open sales line item

Related topics