How can I know the date when the operation was marked as completed using a BAQ?

Kinetic ERP
1

How can I know the date when the operation was marked as completed using a BAQ?

2

JobOper > LaborDtl

Filter LaborDtl by OpComplete = true to get the row when the op was completed. It has columns for Create Date, Change Date, ApprovedDate, depending on what you’re looking for.

3

I would be looking at the LabourDtl table but would also group on JobNum, AsmSeq, OprSeq and then look for the earliest Payroll Date (“FIRST” in the calculated fields aggregate syntax IIRC) (assuming your operators clock in/out daily which they really should be) where the Operation is marked complete. Otherwise if anyone transacts on the operation after that point you will end up with multiple rows for it.

4

You are correct. I just never assume anybody else’s business process so I would leave it up to whomever was writing the BAQ to filter their data accordingly. If Op asked “How can I know the date when an operation was first marked complete since we constantly have people making labor transactions against an operation after it’s completion?”, then I would have gone more in depth with my suggestion.