Historical PartWIP

Epicor ERP 10
1

I am looking to create a Query that would act like a historical PartWIP table (the table that shows what operations are active in a job as well as the qty, etc.).
What I would like to know is how many items were at an OpCode by date.
Fields would include: Date (all dates), JobNum, JobOper.OpCode, JobOper.DueDate, JobOper.RunQty, QtyAtOper, CompleteQtyByDate, (probably more).

The short version is I’m looking for an On Time report by OpCode with details per day.

The problem is I don’t see a simple way to see what was in a particular operation on a particular date.

Any hints (or has anyone made a BAQ like this)?

2

Create an Executive Query to capture the data daily?

3

Moving forward I could easily grab the table and date the records. However I need historical data too. This one is hard… my query isn’t pretty, but I may be close.