Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Steve Erbach]

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]

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]

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]

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:

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

[Steve Erbach]

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]

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]

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
——————————
——————————————-