Microsoft Dynamics GP

Forums

Home » Microsoft Dynamics GP » Microsoft Dynamics GP Forum
Related Search Results

back-ordered items received report for posted receipts

by
on 30 Sep 2011
  • Not Answered

Dynamics GP Three-Way Match Process

by Anonymous
on 4 Dec 2008
  • 0 comments

Automate Void Historical Transactions and Void Open Transactions

by
on 18 Oct 2011
  • Not Answered

Time of Day

This question is answered
johnellis
Posted by
on 15 Feb 2013 8:34 PM

Hello:

Is there a way of knowing the  time of day upon which a purchase receipt is posted in GP 2010?

John
Verified Answer
  • Tim W
    Posted by
    on 15 Feb 2013 10:16 PM
    Verified Answer
    Verified by

    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
All Replies
  • L Vail
    Posted by
    on 15 Feb 2013 9:20 PM
    Suggested Answer

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

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net
  • L Vail
    Posted by
    on 15 Feb 2013 9:43 PM

    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

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net
  • Tim W
    Posted by
    on 15 Feb 2013 10:16 PM
    Verified Answer
    Verified by

    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
  • L Vail
    Posted by
    on 15 Feb 2013 11:17 PM

    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

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net
  • johnellis
    Posted by
    on 16 Feb 2013 9:08 AM

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

    John