Skip to main content

Notifications

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

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

Posted on by 180

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. 

pastedimage1678726088176v1.png

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. 

pastedimage1678726342767v2.png

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

 pastedimage1678726402669v3.png

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:
  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,234 Super User 2024 Season 1 on at
    RE: Difference Balance due (LCY) on customers screen compared to within the customer card

    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

  • KellyEnhanced Profile Picture
    KellyEnhanced 180 on at
    RE: Difference Balance due (LCY) on customers screen compared to within the customer card

    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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    RE: Difference Balance due (LCY) on customers screen compared to within the customer card

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

    pastedimage1678753735938v1.png

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

    pastedimage1678753876910v2.png

    Hope this helps.

    Thanks.

    ZHU

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans