Balance Due (LCY) on 4.0 SP3

satanbis2

Hello,

I upgraded to nav 4.0 from 2.6.
No problem.

But, now, I find a strange thing with the Balance Due on customers.

The value for this field is not the same on 2.6 and 4.0.

I thing, but i'm not expert :
On 2.6, it's based on cust ledger, on 4.0 on detailed ledger, not really a problem
On 2.6, the date filter is on posting date and we filter on open=yes
we don't tak into account for the posting date of the closing entry.
On 4.0, we filter on due date AND on posting date, and on the full detailled entry, so, we take into account of the posting date for the closing entry(entry type=application)

So, we have different value ...

My question : on nav 4.0, how can I have the due amount at a previous date ? = what are the "non closed entry" with a due date < x

Thx

philippegirod

To have a Aged at a previous date, the system filters the detailed vendor entries : if the payment is before the As Age of date, then ok, the invoice will be considered as payed, if it's after, no, it was not payed at this date, even if in the Vendor Ledger Entry, the field Open is equal to No.

This is one of the things I like a lot in Navision !