NAV 2018 Balance due on customer card not calculated correct

(0) Share

Report

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

All responses (4)

Answers (1)

evasmart on at

Like (0)

Report

RE: NAV 2018 Balance due on customer card not calculated correct

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

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

Like (0)

Report

RE: NAV 2018 Balance due on customer card not calculated correct

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
MadsG on at

Like (0)

Report

RE: NAV 2018 Balance due on customer card not calculated correct

Works like a charm. Thanks Artur.
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: NAV 2018 Balance due on customer card not calculated correct

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);