1,295
Hello,
Average Days to Pay Year to Date and Life to Date are showing at zero. This is only for certain customers but these customers do have recent activity on their account. The RM00103 table also shows 0.00 in these fields. We tried running reconcile and checklinks which made no difference.
Does the problem have to do with the way MS calculates Average Days to Pay or is it Data Corruption of some sort?
Thanks
Nancy
*This post is locked for comments
Hi Nancy,
Were you ever able to get a firm answer to this? Or did the responses below provide a resolution? Please update us if you can. Thanks.
Hello Kyle,
Thank you for the update. The best way to get the recalc scripts that we have to update the amount since last close in the Customer Summary window or if you are using Payables the amount since last close view in the Vendor Summary window is to open a support case. What these scripts will do is reset the last year and current year for that particular view. The fiscal and calendar year are already date sensative and will go off the fiscal year setup or the calendar year.
If you have any other questions please let me know.
Best regards,
Brad G
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
community.dynamics.com/.../default.aspx
This posting is provided AS IS with no warranties, and confers no rights
Hi Brad,
I would be interested in getting my hands on those scripts to reset the values since last closed. How would we go about doing that?
Thanks,
Kyle
Hello Kyle,
Thank you for the update. I did look through my RM20101 table and I also have a date of 1900-01-01 00:00:00.000 for different customers. This is telling me that these invoices have not been paid off yet, so they would not be included in the calculation. Once the invoice is paid off this date will change to the date it was applied.
As far as the chunk file that was discussed i am not sure what that would be. If we are talking about yearend closing we do have scripts that would reset the vaules for the amount since last closed view in the summary window.
If you have any other questions please let me know.
Best regards,
Brad G
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
community.dynamics.com/.../default.aspx
This posting is provided AS IS with no warranties, and confers no rights
Hi Brad,
I ran the following for the customer that is showing a zero Avg Days
select DINVPDOF,* from RM20101 where CUSTNMBR = 'XX'
Every date for the column DINVPDOF is set to 1900-01-01 00:00:00.000
I also ran the query for customers where the Avg Days is working properly, or at least being populated with a number other than zero. For all customers the date is the same so this is telling me this may not be the issue. I'm wondering if that chunk file Mariano mentioned would help fix the numbers for us. Would you know how I could get a hold of that?
Thanks,
Kyle R
Hello Nancy
Thank you for using Microsoft Online Communities. I understand that you have some customers that are showing blank average days to pay.
Most of the time that this field is blank is the table is not getting fully updated. This does happen sometimes when invoices are imported. Are you importing any invoices?
In Query Analyzer please run the following script against the company database
select DINVPDOF,* from RM20101 where CUSTNMBR = 'XX'
XX = Customer Number
If this field is blank for any of the invoices for this customer it will cause the average days to pay to be blank. If this is the case you will need to update those invoices through the table. If the field is blank you can run the following script to update that field.
Update RM20101 set DINVPDOF = 'YYYY-MM-DD 00:00:00.000' where dex_row_id = ZZ
You will want to change the date to the date the invoice was paid off.
ZZ = the dex row id for that invoice.
Once you have updated these fields for the invoices does the average days to pay show correctly?
Please make sure you try this in a test company and make sure you have a complete backup before attempting in live company.
Best regards,
Brad G
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
social.microsoft.com/.../threads
This posting is provided AS IS with no warranties, and confers no rights
Nancy,
Have you found a solution for this issue? I see the post is quite old but I'm just wondering if you remember how you fixed the issue. Thanks
Kyle
Just to be sure, these customers with 0 average days to pay and activity, have they fully paid some invoices??
This problem may be related to one of two things:
a) You did not perform the year-end close on the last day of your year-end
b) Your data is corrupted
Either way, you can get a chunk file from the MS Support group that will fix the numbers for you. I do suggest you run a fiscal and calendar reconcile before you run the chunk's routines.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (