Forum Discussion

someone's avatar
someone
Trusted Cover User
4 years ago
Solved

To Do List Accounts Receivables shows $0.00 balance invoices

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's avatar
    someone
    4 years ago

    Hi Tracey_H 

    Thanks for the reply and the details of the PM.

     

    Earlier today I adding a payment for the $0.002, but the UI didn't appear to allow it.

     

    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 Applied
    • Needed to also check the "Include Closed Sales" checkbox as this screen considers the sales as Closed

    Consider this now closed.

6 Replies

Replies have been turned off for this discussion
  • someone's avatar
    someone
    Trusted Cover User
    4 years ago

    Hi gavin12345 

    Appreciate the response, as I previously did request MYOB to have their developers provide a script and as usual heard nothing more.

     

    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)

     

    It's just soooo frustrating to get MYOB to fix thier errors and bugs

     

  • someone's avatar
    someone
    Trusted Cover User
    4 years ago

    Hi Tracey_H 

    Thanks for the reply and the details of the PM.

     

    Earlier today I adding a payment for the $0.002, but the UI didn't appear to allow it.

     

    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 Applied
    • Needed to also check the "Include Closed Sales" checkbox as this screen considers the sales as Closed

    Consider this now closed.

  • Hi someone 

     

    In the referenced post, you were sent a reply by private message. Can you share what replay was provided?

     

    Regards

    Gavin

  • someone's avatar
    someone
    Trusted Cover User
    4 years ago

    Hi gavin12345 

    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's avatar
    gavin12345
    Ultimate User
    4 years ago

    Hi someone 

     

    Seems a standard response when things get difficult :(

     

    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.

     

    Regards

    Gavin

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    4 years ago

    Hi someone 

     

    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:

     

    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.  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.

     

    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.  If those invoices don't appear in the Receive Payments window try clicking on Include Closed Sales.

     

    Sorry I couldn't give you a quick fix for this.

     

    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.