The operation has been completed the required quantity but the Completed checkbox is not ticked.
In Job Status Dashboard found the Opr Completed and checkbox is tick.
But we can’t find the related record for the Employee for the date in Time and Expense screen. But the data is in sql.
Please advice. How can i retrieve back the record.
Assuming you have employee selected, did you check these?
Hi Chris,
Yes, i checked this but still unable to find the job detail.
What table are you looking at? If it has been enetered (Report Qty) but the user hasnt ended activity, that may be your problem.
the data is exist in labordtl table. clock in date and clock out data is there for this job.
Look at LaborHed using LaborHedSeq from LaborDtl and review the payroll date. Select this payroll date in T & E and see if you find your records. Possible this employee has not clocked out in a few days.
Hi, I check the labordtl table, the clock out date is there. Is there any other was to check the missing time and expense?
may i know which screen is this?
Job Tracker, or you can BAQ/SQL LabourDtl table this field exist in there
Hi,
Upon checking, the approved date is before clock in date and payroll date.
