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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Customer's future ...
Microsoft Dynamics SL (Archived)

Customer's future balance

(0) ShareShare
ReportReport
Posted on by Community Member

Hello

One of our customers is running SL 2011 SP2 and in several customers the Customer's future balance shows a negative amount. The customer balance current balance minus future balance is correct but there are no open payments on those customers.

We have already run the aging statement customer detail and the close statement process but didn't correct the future balance.

Any ideas on how to correct this future balance?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Miguel,

    I have seen this a few times before and I am not 100% certain as to the cause but I suspect it has to do with posting a payment or credit memo to a future period.  While not revealing the cause, if you turn on initialize mode on the customer screen, you can edit these fields to what they should be.  If you do not do anything, the issue eventually goes away as you move through the posting periods.  You could run the following query to see if you have any credit documents with a future period.

    select PerPost,DocType,OrigDocAmt from ARDoc where Custid = 'xxxxxxx' order by ardoc.perpost

  • Community Member Profile Picture
    Community Member on at

    Hello Rick

    I did check all the ardocs and there is none with a posting period greater thatn 2016-04.

    I'll use the initialize mode to correct the customers manually, but still haven't find the reason por this problem.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans