Hello,
When transaction batches are posted the posting date can be edited and back dated. This is an important ability and we use it often. However, if I want to find the date and time of when those batches were really posted where do I look?
Jared
Hi Jared,
Did you ever figure this one out? We are having a debate about a problem batch and my theory is that is was post dated but I can't prove it...
One clue might be to compare the batch close date with the posted date. If the posted date is before the close day, you know the post date was changed. This would find the most common usage of this ability, where the batch is created and closed soon after the end of the year, but posted as of the last day of the year.
David
I might have interpreted your question wrong- but when you print a copy of the posting report, the date and time that you actually did the posting always appears in the top right hand corner.
Alison
No, I never did resolve this. I think David's idea is a good one. It's still an assumption, but without an audit trail I think it is the best guess we can make and I am going to use it as my answer for now.
There is one little gotcha about how the data is recorded which is that while the closing date of a batch is specific to the fraction of a second the posting dates are only specific to the minute. This means that if a batch is closed and then posted before the big hand on the clock goes tick then the data will appear as though the batch was closed after it was posted.
For example, a batch is closed at 1:00:20 (one o'clock, zero minutes and twenty seconds) and then posted thirty seconds later at 1:00:50, the posting time is truncated to the minute and recorded as 1:00:00. So, a simple query of batches that were posted before they were closed would return this example even though it is not technically a problem. This issue can be adjusted for by using datediff() in the query and finding only those cases when the posting was made more than one minute before the batch was closed.
Alison, the time at the top right of the report is the time of when the report was run, which may or not be comparable to when the batches were posted. It's not a bad date, but I can't rely on its accuracy and I don't want to sort through .pdfs or hard copies. I want to have the data in the computer so it could be something I can report on.
My thanks to all of you for replying.