Had a customer order some product about 8 months ago. The invoice was paid. I have no open invoice for this customer any more. He's all paid up and current.
Got a call from that customer a few days ago and he asked if he could return the product. It was a for a customer of his who later decided he couldn't use it. (I sell to wholesalers) Normally I wouldn't take a return that old, but this is a pretty good customer, so we agreed that I'd apply it as a credit against future purchases.
I went to the Credit Memo screen, entered in the amount of product returned, filled out everything, and applied it to sales. (Since Invoice was greyed out, I assume because he currently has no outstanding unpaid invoices)
Now, however, the credit memo is showing up in my Aged Receivables as a negative amount.
This isn't a HUGE problem, but it does somewhat annoy me because (to me) the A/R is for showing my RECEIVABLE by age. Not receivables minus outstanding credits that may or may not be taken/used any time soon.
As it stands now, (and these numbers are for purposes of discussion only), say I have $10K in outstanding invoices, the A/R screen is showing that MINUS the $1K credit memo for a total of $9K outstanding. No big deal, I can mentally do the math to see that even though peachtree shows a total of $9K, I really have $10K in outstanding invoices. (For clarification, none of these outstanding invoices are related to the customer I did the credit memo for, these are all different customers)
But, what if, at some future date, I had ten or fifteen, or even fifty credit memos outstanding? I would have to do a lot of math to figure out what I'm owed since peachtree is messing it all up by subtracting my liablilites. I am interested in seeing the totals of my outstanding RECEIVABLES, not receivables minus credit memos.
Is there perhaps a different way I could handle this? I certainly want to keep track of the credit memos, but when I run my A/R report I am interested in seeing totals of the outstanding invoices. Perhaps a different report? Or maybe I need to do some sort of a custom report?
If anyone could help or offer some insight, I'd be most grateful.
Thanks in advance!