Forum Discussion

paulheath's avatar
paulheath
3 years ago

CUSTOMER CARD FILE OUT OF BALANCE - SHOWS OUTSTANDING AMOUNT BUT NO INVOICE OUTSTANDING

Customer card file shows amount outstanding of $211.20, however no invoices outstanding when reports run.  Have found issue dates back to 18/07/2014.  Payment received and allocated to multiple invoices including an invoice for $211.20 with reference CR001239 (no finance charges). Click into invoice relating to $211.20 and clearly shows an invoice allocation, however CR001239 also shows a finance charge which doesn't exist when looking at the original payment allocation screen. How do I fix this considering it is so far back? Screenshots included.

 

  • SKing's avatar
    SKing
    Experienced Cover User
    2 years ago

    Hi Did you get this issue resolved because I have the exact same issue and I've been talking to helpdesk but they say to reverse it (which I've already tried) and all that does is fix this issue but throws out my trade debtors and accounts receivable.

     

    Thank you

    • gavin12345's avatar
      gavin12345
      Ultimate User
      2 years ago

      Hi SKing 

       

      When a finance charge is recorded on an invoice (correctly or incorrectly) and the invoice is later reversed, the finance charge (which is usually a separate transaction processed by MYOB) needs to be reversed as well.  If not, the card balance will not match the Sales Register. This is in the normal course of events (and certainly how it worked in earlier MYOB versions - not sure if this also applies with AR2023). Look for the transactions in the Linked account for Finance Charges at the date of payment. Setup > Linked Accounts > Sales.

       

      If however something went wrong as MYOB was processing the transactions (aka bug), then the issue will need to be fixed via the back end - in other words not a user fix. The file will either need to go to MYOB or a MYOB specialist would need to look at it. If you are unable to resolve yourself, get in touch with MYOB again armed with this extra information. Sometimes first level support only reads from scripts and assume it is a user error. Otherwise if you want contact details for someone else who can fix this, send me a private message or an email.

       

      Regards

      Gavin

      • SKing's avatar
        SKing
        Experienced Cover User
        2 years ago

        Hi Gavin

         

        Really appreciate your response.  I think you've pinpointed the issue exactly.  It is related to finance charge but reversing it now causes things to go out of whack.  Was on the phone for over an hour on Thursday trying to explain it and sending screen shots - I ended up having to go because I had an appt.  Will try again this morning.  Fingers crossed :)

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content