Vendor credit invoice has positive open balance (instead of negative) that is affecting AP aging report but not the outstanding balance of A/P
Vendor Centre
Transactions Show Balance Details Filter Open
Type Ref Amount Open Balance
Bill AAA 26681.59 26681.59
Credit BBB -461.04 5458.50
Total 26220.55 32140.09
Vendor Balance on the left side screen 26665.64
Unpaid Bills Detail
Type Number Open Balance
Credit Card Credit Clear ref -
Deposit Various 433.97
Credit BBB 5458.50
Bill AAA 26681.59
Total 38247.28
A/P Aging Summary
Current 1-30 31-60 61-90 total
0 26681.59 -449.92 433.97 5673.22 32338.86
Pay Bills Window
Ref Amt Due
AAA 26681.59
Clear ref 5673.22
433.97
Set Credits Window
Ref Credit Amt Amt to Use Credit Balance
BBB 461.04 0 5458.50
We have a vendor that will give the credit invoices for entering in QB but the refund checks will be mailed later here at the head office or to the stores, we have 9 stores, and they will mail them to head office for bank deposit. We have to record so our inventory balance matches what's in the stores. We close monthly.
I tried deleting the credit and entering it again but that month was already closed. I think the credit card credit/refund (crediting AP) and Deposit (crediting AP) that my colleague made what's affecting this. How do I get rid of that positive open balance of the credit? TIA
