Share
ReportHello:
Is there a way of knowing the time of day upon which a purchase receipt is posted in GP 2010?
John
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hello:
Is there a way of knowing the time of day upon which a purchase receipt is posted in GP 2010?
John
*This post is locked for comments
Thank you, Tim and Leslie, for your excellent assistance! You are both wonderful!
John
Hi Tim,
This would be for the date the receipt was posted to GL, right? I was hoping they had put the Dex Row Time Stamp to the receipt table in the subledger, but it was not to be.
Good suggestion Tim, for sure the Activity Tracking tool is old technology, but for some folks, it's all they've got.
Thank you for your kind words,
Leslie
Hi John,
Assuming you have post through set I would opt for a SQL query against the GL_OPEN (GL20000) table to get the system time of a post of a receipt. GP has added the Dex Row Time Stamp field to the Gl which you wont see from SmartList but which will give you the server date and time of a post to the GL.
In your case I would query this:
select
ORPSTDDT, dex_row_ts from gl20000 where sourcdoc = 'RECVG' and ORCTRNUM = '<your receipt number>'
which would return the posting date of the receipt and the actual date and time that receipt was posted (assuming your server is 'on time').
With all deference to Leslie Vail who is an incredible and impeccable wealth of knowledge on this site my experience is that the Activity Tracking feature is old technology and not a good tool from an audit perspective in GP which has caused performance issues on larger datasets.
Best
Tim
Hi John,
Assuming you don't keep the posting journals, I looked at the reprint journals and they are no help. What CAN help is for you to use Activity Tracking (Administration | Setup | System | Activity Tracking). Set it up to track additions to transaction files and you will see when a transaction was posted according to it's audit trail code. This method doesn't help the past, but it gives you a good (cheap) option for the future.
Kind regards,
Leslie
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
