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) / no balance available f...
Microsoft Dynamics GP (Archived)

no balance available for customers in Aging report in Collection management window

(0) ShareShare
ReportReport
Posted on by Arunsh 606

Hi all,

We have collection management in sales module. The issue is, there are customer that have balance in aging report. i can see the balance in aging report, but in collection management window i cant see that balance. Please see the screen  shot attached. What can be the possible solution. Its bit urgent, im not able find any solution.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi,

    Have you run aging routines.

    Microsoft Dynamics GP menu >> Tools >> Routines >> Sales >> Aging

    Use the Receivables Aging Process window to age customer accounts, which are used to calculate the number of days old or past due customer accounts are, and adds amounts to the correct periods. You should enter and post transactions and payments before aging to ensure up-to-date calculations. Aging balance forward customers does not move all transaction amounts to the noncurrent aging period; this occurs when documents are consolidated through paid transaction removal. Unapplied credit amounts will be aged if you marked Age Unapplied Credit Amounts in the Receivables Management Setup window.

  • Community Member Profile Picture
    Community Member on at

    Arun, This look odd.  Are you able to see any information for the same customer in Customer Payment Summary Inquiry window or other collection screens?

  • Arunsh Profile Picture
    Arunsh 606 on at

    Hi Arunprasath,

    It's showing zero in Customer Payment Summary Inquiry window and other collection window

  • Community Member Profile Picture
    Community Member on at

    GP showing values in Aging and collections showing as zero which is strange.  Is this happening for all customer? What is the GP Version?  I suggest you to run sql profiler or profiler or script log to analyze the cause.

  • Community Member Profile Picture
    Community Member on at

    Arun, do you have any feedback on this?

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

    Arun,

    have you tried to run routines or not please confirm.  Also you may try to run Checklink against Receivables Open transactions and check Collection window.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans