Aged Accounts Receivable Report - 120


I’m using the Navision 4.0SP3 aged receivables report 120 and have a problem when running it using aging by Due Date upto a specific date. If an invoice has been paid and is not yet due as at the report date then it shows as a negative in the ‘Not Due’ column and also throws the balance column out.

I have already applied the hotfix for KB921900 which fixed the problem with invoices that are not due not displaying in the ‘Not Due’ and ‘Balance’ columns but when they fixed this Microsoft seem to have not taken into account if the not due invoices have been paid.

Anybody else seen this problem or have a solution? The hotfix I applied is dated 22/09/2006 and I can’t see any others for report 120 after this date.