Correct an incorrect RM Date Invoice Paid Off date

  • Correct an incorrect RM Date Invoice Paid Off date

    Posted by DSC Communities on February 20, 2017 at 12:25 pm
    • Steve Erbach

      Member

      February 20, 2017 at 12:25 PM

      Dear Collaborators,

      During our upgrade to GP 2016 I did some reviews of our Receivables data. I found that the DINVPDOF (Date Invoice Paid Off) for a series of invoices for one Customer was way off. Instead of 12/23/2016, the date was 12/23/2106. Clearly a fingerslip.

      Any recommendations for changing that DINVPDOF through the GP screens before I go ahead and alter the dates in the back-end?

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439)
      MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————

    • Bert Green

      Member

      February 20, 2017 at 12:33 PM

      Steve,
      Has the payment and invoices been sent to History? Or are they all in open? The only way to do it through the screens that I can think of would be to void the payment and set up the new payment.

      If you go the SQL route, also take a look at the date on the payment and don’t forget the key table which also holds dates.

      ——————————
      Bert Green
      GP Developer/GP Administrator
      Berger Transfer & Storage, Inc.
      Saint Paul MN
      GP2015/MR CU11
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      February 20, 2017 at 1:08 PM

      Bert,

      We haven’t made a habit of sending paid invoices to History yet. Not sure why… so they’re all in RM20101/201.

      I kinda figured that the only UI recourse would be what you suggested. Thank you for the notes about what to watch for in the back end. I’ll just change them “manually” in SSMS.

      Thanks, Bert. See you tomorrow!

      Regards,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439)
      MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Amber Bell

      Member

      February 20, 2017 at 2:45 PM

      I wanted to add 1 tip to prevent this happening again in the future.

      Turn on “Doc Date Verify” in the PSTL screen. I will be covering this as one of my tips at GPUG Amplify:

      8cflxYSdTRe2FHgoaX8T_DocDateVerify.JPG

      ——————————
      Amber Bell
      Owner
      Training Dynamo LLC
      Derby CT
      ——————————
      ——————————————-

    • Steve Erbach

      Member

      February 20, 2017 at 4:07 PM

      Amber,

      Ooooo! That’s a good one! I’m going to forward this to our A/R Supervisor. Thank you!

      Sincerely,

      ——————————
      “Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
      WOW Logistics Company – Appleton, WI
      VP for Communication, GPUG WI (Milwaukee) Chapter
      Co-Chair, GPUG WI (Green Bay) Chapter
      GP 2016 (16.00.0439)
      MR 2012 CU15
      Blog: https://www.gpug.com/blogs/steve-erbach
      Twitter: @serbach
      ——————————
      ——————————————-

    • Beat Bucher

      Member

      February 21, 2017 at 8:29 AM

      Steve,
      That’s one tip I repeat every at GPUG Summit when presenting the PSTL tools.. 🙂
      ..And going to talk about tomorrow in our Chapter meeting.

      ——————————
      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      +1-514-489-4267
      @GP_Beat http://dyngpbeat.wordpress.com/
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14
      ——————————
      ——————————————-

    • Kathy Kim

      Member

      February 21, 2017 at 8:47 AM

      I always forget about that one.  I’m modifying GP Jeopardy for my meeting tomorrow – I think I’ll throw that in there.  🙂  PS – I’m stealing a lot of your tips for my new version of GP Jeopardy.  Thank you Amber!  

      ——————————
      Kathy Kim
      Director of Finance
      Donor Network of Arizona
      Phoenix AZ
      ——————————
      ——————————————-

    Members

    DSC Communities replied 6 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!