Material Availability Date

Kinetic ERP
1

Anyone that can help with a BAQ that calculates when material is going to be available to complete a job

2

After running MRP, there is an addtiional process called Production Planning Process you can run. This second process will update the Production Planner Workbench, in which you can see jobs with full availability and then also jobs with shortages.

If you want a more generic dashboard, the values used in the Time Phase program come from the PartDtl table, so you could build a dashboard based on JobMtl linked to PartDtl (with whatever other tables/filters you want to see).

Good luck!

3

Thanks let me try that

4

would you happen to know anyway i can tell if a sales order is late, any way to estimate the future expected date it will be shipped when stock is available

5

LOTS of variables on that one. Are your NeedBy and ShipBy dates on your sales order releases accurate (i.e. trustworthy)? Are you using the new Promise Date field? Which date will you use to determine “late”? These are all in the OrderRel table.

Are you make-to-order or make-to-stock? If you are make-to-stock and multiple customers order the same part and have the same date, who gets precedence?

How accurate is your production schedule? If a job says it will be completed by a week from Friday, is that accurate? If your resources are not finitely scheduled, I’d be hesitant to rely on those dates.

6

use the promise date, finite scheduling not in place so you are right that would give wrong dates.

7

Pegging data is very useful for this, if you enable multi-level pegging (MLP) in MRP or run MLP separately.
Tables:
PegDmdMst <> PegLink<>PegSupMst
(join on DemandSeq and SupplySeq)

So briefly, for a job, you want DemandType = ‘J’, DemandOrdNum = jobnum.
Then the SupplyType and SupplyOrd/Line/Rel will tell you where the supply is coming from, and the SupplyDate will tell you when.
(SupplyType N is a PO sugg, M is a job sugg)

This lets MLP do most of the heavy lifting, and it helps you better understand what Epicor is “thinking”.

1 Like
8

Thank you will get back if i need more