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
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156