Anyone knows the difference between “CreateDate” and “TranDate”?
Thanks
Not sure what you are looking at, but you can create a Shipment today (create date) and not mark it shipped until tomorrow (trandate).
Actually, I’m looking for the difference from the Labor Detail (table) point of view.
There is no trandate on labordtl.
Specifically we are looking at what populates the TranDate field on the GLC table for the records associated with the RelatedToFile = ‘LaborDtl’. We see CreatedDate, PayrollDate, and Approved Date but noticed that none of these line up with TranDate fully.
In that instance, I would expect the TranDate to be the date of the posting. You could probably check the data dictionary to see if it tells you.
1 Like
Unfortunately, the Data Dictionary was not a great place to tell us what we were looking for.
Thanks for your help.
In your explained context, CreateDate is the date the labor was Entered, TranDate is the date it was Posted to the GL.
Unfortunately, I do not know the rules on when the Labor BO(s?) post that detail to the GL.
(EndActivity Should be one area)
I’m not so sure about that. TranDate usually implies the date used in the GL posting. Which is different than the date it was posted.
For example:
- On 2/1 a PO receipt is entered with a receipt date of 1/30.
- Capture WIP/COS is run on 2/2.
The TranDate would be 1/30
The GL entry is created on 2/2 (but applies to the January fiscal period)
The create date would be 2/1. That’s the date the TranGLC entry was created. When the receipt was entered.
Best to do some tests to verify it.
1 Like
I’m not an accountant, by posted, I mean “reported to the gl”.
I forget those words mean different things.