Small and medium business | Business Central, N...

Difference Balance due (LCY) on customers screen compared to within the customer card

(0) Share

Report

Posted on by KellyEnhanced

192

Dear All,

I wonder if anyone else has noticed this and I wondered if it was something I wasn't doing that was causing the issue.

One of my customers has recently starting using business central and they have noticed a few customer accounts, where the Balance Due (LCY) field on the customers list screen is showing one figure. But on going into the Customer card itself the same field it is another figure which is correct. Surely both of those fields should be reporting the exact same figure? They are running v21.4 of Business central.

For example the customer acct is set as payment terms CM_1M and my system date is 13/03/23 (todays date) added a transaction with due date of Jan, one for Feb & one for March.

So I would expect the field Balance due to be 1380 will is the figure of 2 transactions dated feb & jan. Which is what the customer card shows.

But the main screen shows the same as the total Balance.

I tried adding another transaction with a due date in the future to see if that recalculated the balance due on the main customer list but that doesn't make any difference. Can anyone suggest anything to force a recalculate of the customer list view, I have tried refresh on the website, logged out of bc365 and logging back in but that doesn't seem to work.

Kind regards,

Kelly

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (1)

Report

Hi, please check the Filter totals by settings on the Customer List page.

This field on the customer card does not have any filtering by default, so it may be inconsistent with the list page.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
KellyEnhanced 192 on at

Like (0)

Report

Thank you Zhu.

I have fixed that now, but there are still times when the customer list screen (even with the filter) isn't agree to the customer card total, but it seems temporary and then it agrees again.

What processes does the customer card balance due (LCY) get updated, I assumed when transactions are posted against the customer card with the due date set and when payments are posted and assigned to transactions? Is there any other processes that would update the balance? Customer is new to Business central, is MS aware of any issues with this in v21.4. There isn't anything on the list for this with hotfixes that I could see.

Kind regards,

Kelly

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (0)

Report

Customer balances are updated whenever new Customer Ledger Entries are created for that customer. Any act/transaction creating CLE will be responsible to change the values on Customer Balance fields

Was this reply helpful? Yes No