web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Average Days to Pay Ca...
Microsoft Dynamics GP (Archived)

Average Days to Pay Calculation

(0) ShareShare
ReportReport
Posted on by Nancy Hogan 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

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Just to be sure, these customers with 0 average days to pay and activity, have they fully paid some invoices??

     

  • Kyle Reierson Profile Picture
    Kyle Reierson 300 on at

    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

  • Bradley Gehrls Profile Picture
    Bradley Gehrls Microsoft Employee on at

    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

  • Kyle Reierson Profile Picture
    Kyle Reierson 300 on at

    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

  • Bradley Gehrls Profile Picture
    Bradley Gehrls Microsoft Employee on at

    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

  • Kyle Reierson Profile Picture
    Kyle Reierson 300 on at

    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

  • Bradley Gehrls Profile Picture
    Bradley Gehrls Microsoft Employee on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans