AP Zero Balance Vender

[peripheral]

Hello,

I have some vendors that have zero balances. (i.e. I imputed an invoice, but then was issued a credit memo from the vendor and imputed the credit memo) my vendor reflects $0 is due, however when I print an AP Aged Invoice report the vendor always shows up with both the invoice and credit memo on their account. I do not anticipate ever buying from this vendor again, how do I get their account to not show up on my report any longer. I have a few vendors with this problem and I cant figure out a way to clear it off the report.

Thank you,
Sandy

 

[CsaintAZ]

If you have not applied the credit/debit memo against the invoice, Go to Manual Check Entry. Enter a Check No of APP000 where "000" can be any number up to 999 (This stands for "APPLY"). Enter a zero check amount. On the lines page, apply the check against the credit/debit first. Then apply against the original invoice. This should bring your check distribution to zero. Update the batch and you shoud be done.

Once this is done, you can view the Aging with "Open" transactions only.

To completely remove the vendor and invoices from the system, do the following:

In AP Vendor Maintenance, set the vendor to Tempoary (There is a checkbox). When you run period end for AP, all temporary vendors with zero balance invoices are removed.