Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • Suggested answer
    RE: no balance available for customers in Aging report in Collection management window

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: no balance available for customers in Aging report in Collection management window

    Arun, do you have any feedback on this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: no balance available for customers in Aging report in Collection management window

    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.

  • Arunsh Profile Picture
    Arunsh 606 on at
    RE: no balance available for customers in Aging report in Collection management window

    Hi Arunprasath,

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: no balance available for customers in Aging report in Collection management window

    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?

  • Suggested answer
    RE: no balance available for customers in Aging report in Collection management window

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans