Forum Discussion

bronwenw's avatar
bronwenw
Contributing User
3 years ago

Supplier card shows negative current balance but no transactions found

One of our Supplier Cards has a current balance of -$165 however when I go into the Purchases Register there is nothing listed in the 'Returns & Debits' tab. Also when I go to 'Pay Bills' it doesn't ask to apply a credit.  I also ran the Supplier Ledger Report dated from 01/01/1900 to 31/12/9999 and the balance is -$165.  Can you please advise how I find the transaction?

5 Replies

Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

    have you run the supplier ledger report in detail so you can see the transactions as the credit is there in the report you did run

     

    the detail report should show all transactions , keep the dates as you have before

     

    lisa

  • bronwenw's avatar
    bronwenw
    Contributing User
    3 years ago

    Thanks for the suggestion Lisa but the Supplier Ledger report didn't reveal anything. Any other suggestions?

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    3 years ago

    Hi bronwenw , something worth checking is reviewing for any entries in GL account which is linked to the Purchases account for "I pay charges for late payment". If none in the current year, go back to previous years if you can. 

     

    Sometimes when pay bill entries are made, the amount gets put into the finance charge field at the bottom of that window. A review of the expense account will tell you if that has happened. 

     

    Let me know the result. If there is an entry for this supplier and amount, I can advise further.

  • bronwenw's avatar
    bronwenw
    Contributing User
    3 years ago

    I've checked the GL account with expanded dates for a 'Finance Charge' but still nothing. 

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

    I have been thinking so sorry for the delay in response

     

    The  only other thing I can suggest is to do a find transaction and see if the 165 comes up there

     

    So go into a find transaction

    go to the account tab

    go to advanced filters 

    select all accounts

    set date range from 2000 - 2999

    set amount to 165

    in payee put the customer name ( if nothing comes up then delete and leave blank and run again)

     

    Hope that helps

     

    The finance charge  - if that is what it is may show in a differnt gl code

     

    Lisa

     

Looking for something else?

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

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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