Microsoft Dynamics GP (Archived)

Time of Day

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

You could use the system date/time that appears on the Posting Journal.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Tim W 2,925 on at

Like (0)

Report

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, Tim and Leslie, for your excellent assistance! You are both wonderful!

John

Was this reply helpful? Yes No