Is there a way of knowing the time of day upon which a purchase receipt is posted in GP 2010?
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:
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.
You could use the system date/time that appears on the Posting Journal.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
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.
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,
Thank you, Tim and Leslie, for your excellent assistance! You are both wonderful!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13