Customer Aging report 10040 V4.0 sp1

Hello. Found this bug in Navision 4.0 and Navision SP1. for Aged customer report 10040. Probably the same applies Aged Accounts Payable report.

Here is the problem in version 3.x and previously Navision has 2 additional datatimes on this report that looks at customer ledger entries closed before and after. The report uses an array to keep track of amount and remaining amount based on aged as of date.


The problem is that these dataitems have been removed from 4.0. Instead it uses a temporary custledgerentry and inserted the records into the table. And this is where the problem is.


If you have the following entries


Doc type..............doc no..............posting date
invoice..................12471..............8/16/01
Credit..................Return_12.........12/20/04


application was done on 11/17/05 which creates two detail cust. ledger entries with entry type application with posting date 11/17/05


When you run the report with aged as of 9/30/05, based on transaction date, you should see the first invoice in when the report is printed in detail .
The problem is that you don't. Has anybody seen this?
How could they have redisigned the report so much and forget the whole point of the report is to run it as of date.

I loaded the 3.7 report in 4.0 and ran it but didn't see the details either.
Am I missing something.