Customer Aging report 10040 V4.0 sp1

ara3n

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.

ara3n

Well I found the problem.

The report only looks ledger entries which are open and posted before the date of the aging.

Why would you look only at open entries? It should look at all the entries.

You run the report to find out that as of this date, how much did the customer owe me.

I can't believe nobody has looked at their aging reports that closely.


I fixed it by remove the filter open = true from the <Cust. Ledger Entry> dataitem.

johnson_alonso

It's nice that you have found the problem. you must rejoice for it and also for all mibuso forum members I think.


rgds,

ara3n

I'm just supprised that nobody has seen this problem. Customers run that report everyday. I'm solving navision problems everyday, and only get pleasure out of the ones that are realy hard.

kine

Yes, for example I hadn't found this problem, because I never used this report. Why? Because this report is not part of WW1 version nor CSY and other European version... 8)

ara3n

The report is based on world wide agging report version.