We processed an invoice in A/P with a date of 03/12/09 for $134.27. We processed a credit note on 03/16/09 for $100.03 and issued a payment on 03/19/09 of $34.24. When reconciling our A/P subledger to our GL there is a difference of $100.03 - the amount of the credit note. Upon further investigation, it appears that the credit note was applied to the invoice on 11/14/43, which means that the open payables listing for this vendor includes the $100.03 in the balance, when the current balance of this transaction should be zero and therefore the outstanding balance should be less by $100.03. If I run the open payables report as of 11/30/40 the $100.03 is still outstanding. However, if I run the report at 11/30/43 the balance is zero. Is there a way to fix this so that the open payables report at 03/31/09 is correct? I need to somehow reverse the application of the CN in 2043 and reapply it in 2009. Hoping this is possible!


Thanks,
Tanja