Open Forum

Expand all | Collapse all

Receivables Transaction Inquiry - Documents: by Document date

  • 1.  Receivables Transaction Inquiry - Documents: by Document date

    Posted 14 days ago
    Are you guys seeing the same thing as me on this screen.  If you enter dates MM/DD/YY the date is return for YY/MM/DD.
     So if you put in a date range of 12/01/02 to 12/01/03  you get a 2 day period from 01/02/12 to 01/03/12.  


    ------------------------------
    Rob White
    Sr. Tech Architect
    D'Arrigo Bros. Co. of CA
    Salinas CA
    ------------------------------


  • 2.  RE: Receivables Transaction Inquiry - Documents: by Document date

    Posted 14 days ago
    Edited by Kelly Marinoff 14 days ago
    Hi Rob,

    GP's date format pulls from the system format setup on your PC. Mine is MM/DD/YYY:


    This is what shows on my Receivables Transaction Inquiry window:

    I changed my system format to YY/MM/DD, restarted GP, and now the change is reflected in the Inquiry window:


    So, in order to change the display in GP, you would need to adjust your system date format.

    Hope that helps.

    Thanks!


    ------------------------------
    Kelly Marinoff
    Keel & Company, LLC
    Virginia Beach VA
    ------------------------------



  • 3.  RE: Receivables Transaction Inquiry - Documents: by Document date

    Posted 13 days ago
    Thank you for the response Kelly.  Yes, our date setting are MM/DD/YY and in all of the screen shots (yours and mine)  the date format in the filter matches the date format in the results.  What i am talking about is the results are returning a completely different date.  Can you try it for one day in the date range?

    ------------------------------
    Rob White
    Sr. Tech Architect
    D'Arrigo Bros. Co. of CA
    Salinas CA
    ------------------------------



  • 4.  RE: Receivables Transaction Inquiry - Documents: by Document date

    Posted 13 days ago
    Also, this just started happening with the new version of GP (18.2)

    ------------------------------
    Rob White
    Sr. Tech Architect
    D'Arrigo Bros. Co. of CA
    Salinas CA
    ------------------------------



  • 5.  RE: Receivables Transaction Inquiry - Documents: by Document date

    Posted 13 days ago
    Edited by Kelly Marinoff 13 days ago
    Hey Rob,

    This is what I get when searching one date (i changed my system format back to my original MDDYYYY)

    Sounds silly but try closing GP, change your system format to something different, re-open GP, check the inquiry window to see if anything changed, then close GP, change the system format back to MMDDYYY, re-open GP, check the inquiry window again...

    Also - are you seeing the same behavior with recent, Open transactions?


    ------------------------------
    Kelly Marinoff
    Keel & Company, LLC
    Virginia Beach VA
    ------------------------------



  • 6.  RE: Receivables Transaction Inquiry - Documents: by Document date

    Posted 13 days ago
    Thanks again @Kelly Marinoff .  Yes I have found that the ​other date formats work fine but with GP version 18.2.1036 and the MM/dd/yy date format it is not pulling back the correct data.  As long as the year is 4 digits it is fine.   I'm working with Microsoft on this and it looks like a product issue.  They will be checking to see if the issue has been addressed in their mid-year release.
    Thanks again.

    ------------------------------
    Rob White
    Sr. Tech Architect
    D'Arrigo Bros. Co. of CA
    Salinas CA
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role