Hi,
A few of our customers have a balance amount in their card file but there are no outstanding invoices. I have run a receivables report and they are not showing up. I was just wondering how do I fix this problem.
Thankyou.
Hi leawalt,
Thank you for your post and welcome to the MYOB Community Forum. I hope you find plenty of useful information.
We need to make sure invoices are closed, you may navigate to the sales register, close invoices, and put the date range to make sure the status of the invoice is closed.
When you open the Print/Email Statement window the system will look at the balance on the customer's card to determine whether that customer will appear in that window. The filter of Include Customers with Zero Balances is a filter on that window that will filter the window to show customers with a zero balance or not.
What can happen is that if you record a future-dated transaction (after the statement date), the system will populate the list with the customer balance. Along with that, if you have to Include invoices up to the statement date enabled when producing those statements, you are indicating that do not include that future-dated invoice, and thus it will likely produce a blank statement as a result.
The only area that could be worked on would be to dynamically work out the balances up to the statement date rather than pulling all the current card balances. At this stage, this is not a feature of the product that is actively being considered currently. It may be something to investigate for the future, however, no immediate plans.
If you need further help, don't hesitate to start a new post and we'll be happy to assist.
Otherwise, if my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information.
Cheers,
Shella
Hi,
My customers do not have any invoices open they are all closed, but in their card file it is showing up with a balance amount. Just a couple of weeks ago I allocated a payment to one of my customers which left them with a zero balance but then an amount showed up in their card file which wasn't there before and their card file always balanced.
Thanks.
