Best way to add Reservation Prioirity to BOM Listing

Epicor ERP 10
1

Hello,

I have been asked to add the OrderHed.ReservePriorityCode to the BOM Listing report.

I have not found a good way to do it yet and was wondering if anyone had any pointers for it?

Any help is appreciated.

2

I don’t think you’ll find a path from OrderHed to the BOM Listing report.

If instead you wanted to show OrderHed field(s) on something like a Job Traveler.
Then you could use the JobProd table for linking…AS LONG AS you’re building direct to the Order.

3

Why would they want this info on a BOM? I can understand on Orders but how would you equate the proper order per part, there is no way that i can see. User’s always ask for the world, sometimes it’s our job to bring them back to reality. Just because you "Can" doesn’t mean you "Should"

4

Couldn’t Agree More.

5

I assume you are looking at the BOM Liisting report because it is the closest to the data you want to see.
However, Orders and BOMs are not directly linked. Are you using Make Direct (Jobs) or Make to Stock?
If it is Make to stock, then the OrderDtl has the Part/Rev, but you potentially have many or no Orders for the top level part. If it is Make Direct, OrderHed > JobProd > JobMtl will get you a BOM with the ReservationPriorityCode

6

@bordway
@AlexAverbukh

Hello,

The BOM listing was close to what they need.
What they asked for is A list of parts that include all sub assemblies that have a vendor listed and have a certain Reservation Priority code.

If there is a better way to do or a report that is closer, I am open to making it work.

Any ideas?

7

Try using a BAQ/Dashboard. You will need a CTE query to get the full BOM, but there are many posts here about that. I doubt the users need to actually print anything, so a Dashboard is often preferred.
If there is a Job associated, then you can simply use the Job information (JobMtl) as opposed to the CTE query against PartMtl.

8

The problem with the CTE approach is you can only do it one Part at a time, so if you need a listing for all the parts on an order you can’t use the BAQ CTE. But you can alway just create a stored proc with a cte and nest your loops and build out your report that way too…

9

if you are on-premise you can do this thru SQL