I am again having problem with posting negative balance invoices.
As recommended last, I am now posting negative balance invoices as Credit Notes. However, there is an inconsistency in the overdue receivables report. The customer in question is a balance forward account, who pays in advance.
The current transactions are as follows
################################################################
Type - DocDate -- DueDate -- Document - CurrentAmt - OriginalAmt
CA --- 12/22/08 - 12/22/08 - 1017546 -- (898.25) --- (1,168.69)
IN --- 02/26/09 - 03/25/09 - 870839 ---- 0.00 ------- 8.69
CN --- 02/27/09 - 02/27/09 - 870946 ---- 0.00 ------ (2.68)
IN --- 03/04/09 - 03/25/09 - 871371 ---- 0.00 ------- 5.55
################################################################
The CN (870946) has a current amt. of 0.00 and has been applied to the CA (1017546). If I click the 'Calc Aging' button on the customer profile, Transaction tab, the entire credit amount of -898.25 appears in the Current field. However, on the Overdue Receivables report under the Current column is the amount -895.57 and under the Over92 column is the amount of the CN, -2.68.
This should be the same for both. Why is there an inconsistency in the two figures? Is there any way I can correct this?