Supplier card shows negative current balance but no transactions found

[bronwenw]

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?

[LRBooks61]

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]

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

[Mike_James]

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]

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

[LRBooks61]

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