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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AVG Days In Customer Payment Summary Inquiry - Where it come from?

(0) ShareShare
ReportReport
Posted on by 4,130

Hi,

Where is the AVG days in the customer payment summary inquiry comes from?

I have a scenario where this field for a customer is showing empty

 

Thank you,

 

*This post is locked for comments

I have the same question (0)
  • Alaa Ramadan Profile Picture
    4,130 on at

    When I looked at the table RM00103 which it contains value 0 for in the ADTP fields

    There is a recent invoice and payment applied for that invoice  

    still not sure why it shows 0 for that particular customer?

    Any help would be greatly appreciated

    Thank you,

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    Have you ever closed the Receivables module?  ADTP is calculated based on activity since the last close date.

  • Alaa Ramadan Profile Picture
    4,130 on at

    Do you mean closing the period for AR module? If yes, the period is still open

    thanks,

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    No, I mean closing the year.  Sales>>Routines>>Year End Close.

  • Alaa Ramadan Profile Picture
    4,130 on at

    No Sir, We are in the mid-year

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    Have you EVER closed it?  You can tell by looking at the Last Closed Date in the Year End Close window.  If not, that could be the reason you are seeing no ADTP in your system.

  • Alaa Ramadan Profile Picture
    4,130 on at

    I forgot to mention this happen only with one customer, all others looks fine

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    Hmmm, interesting.  If that's the case, then try running the Reconcile utility in that customer.

  • Alaa Ramadan Profile Picture
    4,130 on at

    That Reconcile utility was the first thing I tried earlier but did not make any change

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Hi,

    Have you tried the checklink against receivables that might fix this.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans