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 NAV (Archived) / NAV 2018 Balance due o...
Microsoft Dynamics NAV (Archived)

NAV 2018 Balance due on customer card not calculated correct

(0) ShareShare
ReportReport
Posted on by MadsG

In 2018 we got Balance due (lcy) on the customer list page. It shows exactly same amount as Balance (lcy). In the factbox the amount is correct.
Example on Cronus: set date to 10-02-2019 (dd-mm-yyyy). Navigate to customer 49525252 - "Beef House". The Balance is 486.874,55 and so is Due.
In fact box balance is still 486.874,55, but Due is 430.070,69.
Is this an error, or do I need to calculate/set due functionality etc. somehow?

*This post is locked for comments

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

    It's a bug. Make sure that you have the following default filter for "Date Filter" on OnOpenPage trigger of Customer List page:

    SETFILTER("Date Filter",'..%1',WORKDATE);

  • MadsG Profile Picture
    MadsG on at

    Works like a charm. Thanks Artur.

  • evasmart Profile Picture
    evasmart on at

    hello,

    this problem is still on the latest versions of business central. The question is, how to calculate the correct balances of the customers when using for example a codeunit or a report?

    thanks

  • evasmart Profile Picture
    evasmart on at

    did the same on PreDataItem of the report and it worked.

    SETFILTER("Date Filter",'..%1',WORKDATE);

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans