To Do List Accounts Receivables shows $0.00 balance invoices

Question

Need to revive this old issue, as it is causing problems with statements.

The responses from the original post https://community.myob.com/t5/AccountRight-Sales-and-purchases/To-Do-List-Accounts-Receivables-shows-0-00-balance-invoices/m-p/631312 indicate that the issue was brought about by the number of decimals being used for tax amount ( 3 instead of 2), so in theory there is an outstanding balance of less than a cent for each of these invoices, hence why these invoices still show in the Receivables list.

Without purging historical transactions, does anyone have a way of being able to record these invoices as being fully paid and thus drop of the list or at the least determine exactly what the balance is?

someone · Accepted Answer

Hi Tracey_H&nbsp;Thanks for the reply and the details of the PM.&nbsp;Earlier today I adding a payment for the $0.002, but the UI didn't appear to allow it.&nbsp;Have just tried it again using the following steps and this appears to have worked:Use the calculator UI to add the 3 decimal places in both the Amount Received and Amount AppliedNeeded to also check the "Include Closed Sales" checkbox as this screen considers the sales as ClosedConsider this now closed.

someone · Answer

Hi gavin12345&nbsp;Appreciate the response, as I previously did request MYOB to have their developers provide a script and as usual heard nothing more.&nbsp;I am aware of an external expert that does this kind of work. Heck I can even do the SQL script, but I shouldn't have to, as we are a paying MYOB Cover and now Subscriber. (bolding is for MYOB, not you gavin12345)&nbsp;It's just soooo frustrating to get MYOB to fix thier errors and bugs&nbsp;

gavin12345 · Answer

Hi&nbsp;someone&nbsp;&nbsp;In the referenced post, you were sent a reply by private message. Can you share what replay was provided?&nbsp;RegardsGavin

someone · Answer

Hi gavin12345&nbsp;I can't access my private messages (don't know why), but from memory, I recall it was to basically start a new company file!

gavin12345 · Answer

Hi&nbsp;someone&nbsp;&nbsp;Seems a standard response when things get difficult :(&nbsp;What you describe most likely requires a fix through the back end - so MYOB would need to fix this file or you would need an outside expert to do it. If you want to contact an outside expert I would normally say send me a private message, however as these have been disabled for you, try doing an internet search on 'purge for myox' - the same company that provides a purge service also repairs myox (or AR2021) company files as well. There would likely be a repair fee, so try MYOB first.&nbsp;RegardsGavin

tracey_h · Answer

Hi&nbsp;someone&nbsp;
&nbsp;
I've located our private messages where we were working on this and I advised you that I had spoken to our product specialists about this issue. This is my last private message to you:
&nbsp;
There isn't a script for this situation as each script is created for a specific common issue created by AccountRight not behaving the way we expect it to.&nbsp; Unfortunately for you, the only other time we have seen this is when the sales were imported and the GST amount needed to be corrected in AccountRight manually.
&nbsp;
At this stage the only way I can see to clear those invoices from the To Do List would be to apply a payment for the outstanding 0.002. If you don't have one already you could create a Suspense account, as either an asset or liability, and set the Account Type to Bank or Credit Card. Then when you record the Receive Payments transaction make the Deposit to Account the Suspense account. You can then journal the total amount to the account you choose to allocate it to. This way it won't affect your bank account.&nbsp; If those invoices don't appear in the Receive Payments window try clicking on&nbsp;Include Closed Sales.
&nbsp;
Sorry I couldn't give you a quick fix for this.
&nbsp;
As this hasn't been resolved I'll be happy to look into again for you and see if there's another way to remove those transactions. I'll update you when I have spoken to a product specialist.

Forum Discussion

To Do List Accounts Receivables shows $0.00 balance invoices

6 Replies

Related content

Invoices receivable not showing

Accounts Receivable Imbalance

Accounts receivable with tax report not loading

Invoices received from MYOB

Invoice in USD but receive payment in AUD

Accounts Receivable error

BPAY PAYMENT NOT RECEIVED

One line invoice with multiple accounting allocations