The other day I was chasing down an issue on a Labor Detail report. There was a transaction on the report that I could not find in the LD table. Futhermore, there was no correlating transaction in the TKDetail table either. Lastly, I checked to make sure the record was not part of a timesheet data entry file.
I was working with one of our accountants while discussing the issue, and found how the entry made it's way onto the labor detail report. In Interactive Billing, there's a screen where you can "create" labor records. These records are stored in the BILD table in Vision. The labor detail report queries the BILD table along with the LD table.
If you ever run into this issue after checking, LD, TKDetail, TSDetail, try looking through the BILD table.
Enjoy.....
No comments:
Post a Comment