My finance department is asking if I can query labor tickets created from a certain date or date range, and figure out which GL batch they went into. I am having one heck of time trying to get it to work correctly. I started with table LABOR_TICKET and WIP_ISSUE_DIST. However, I can only link it via workorders and there could be the same workorder from several days ago that might've posted in multiple different batch. So I would have duplicate labor that's been posted 2 or 3 times verse just for that 1 day or days I am looking for. Anyone know if there's another table I am missing that can tell me which transactions went into that particular batch?
Example, we have labor transactions created on 1/29/2022 and 1/30/2022. It just got posted on 1/31/2022 since we don't run costing nightly. I am trying to figure out which GL batch created on 1/31/2022 of which labor transactions from the 29th and 30th that went into which batch.
