HI All
is there a report in Epicor to show me the last transaction date of any job? or is this going to be a Baq i need to make, and if so any pointers would be great.
I have abit more information now on what is needed so this needs to have the last Tran date for the job and it needs to be anything so labour,mtl anything for that job that was done they woudl like a date on.
Thank you so much for the support
Cheers
D
I am not aware of such a report that would give you the information for each of your Jobs. You will need to query LaborDtl and PartTran to get the appropriate labor and material transactions and then compare them, if I understand you correctly.
JobOper.LastLaborDate will get you the last labor transaction for the Job Operations which you can aggregate to show the Max for the job.
For Mtl transactions I would look at PartTran and similarly aggregate against the Max transDate (or possibly SysDate depending on your processes).
I would have this with the main Top Level Query just having the JobHead table(assuming you don’t want to filter against other criteria) then 2 subqueries, one each for the above calcualtions, linking both those queries back to the main on through Company & Job Number.
For the PartTran SubQuery I would limit it to Stk-Mtl transaction types as otherwise you will end up with non-mtl issuing dates to contend with.
Both SubQueries would group on Company & Job Number.
You can also use PartTran for any PO receipts or Inspection receipt to Job for Subcontract Operations if you want to include that data also in your last transaction scope.