AP Aged Invoice line doubled the amount

Question

I am trying to correct some dating issues between transaction date and invoice date being in different years. I went through AP-Invoice Data Entry, using the incorrect date, and used the same invoice number with a negative amount. Then I re-entered the invoice, using the transaction date I wanted it to fall under. Now it is on my Aged Invoice report with double the amount. 
 Help, how do I fix this? Thank you!

BigLouie · Accepted Answer

First I'll tell you what you should have done. In an instance like this just go into AP Invoice Data entry, enter the same invoice number, it will ask if this is an adjustment, answer Yes and the change the date, leave the dollar amount at zero and post. The Invoice date will be updated. 
 You are going to have to do an adjustment to clear out the amounts.

Kevin M · Answer

First, don't ever try to use the AR / AP Aged Invoice reports to balance with the GL. The date filters work off of invoice date, instead of the posting date. 
 Balancing with the GL is what the AR / AP Trial Balance reports are for, which are based on the GL posting date. 
 When we get clients asking us to make the Aged reports work, since "non-Sage-100" system XYZ does it, my reply is: Sage 100 is not system XYZ. The audit trail / posting process means history can't just be edited directly (possible in less sophisticated ERP's), and the much higher price of more sophisticated ERP's buys you extra features. 
 If your payment was before the invoice, but the data entry was done after, no correction is possible (due to how the Aging report date filters work).

Sage 100

AP Aged Invoice line doubled the amount

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING