aged accounts receivable

Horse06

Hi expert! when we ran the report today, we found a big problem. when running the report from the due date, the total balance due number of each day period at the end of the report is wrong and it looks like we have fewer customers that past the due date, but in fact lots of customers past the due date. When we select the trans date and document date, the number look a little reasonable. Since I will check this report tomorrow, could anyone give any advice of a easy way to check these errors.
I will start from the ledger entry. My concern is if we have got the posting date somewhere wrong, it will affect only a limited number of customers, perhaps one or two.
I checked the coding today and didn't find anything wrong. Also from the coding due date = posting date = document date. Why is there a great difference when running from the due date and document date? Appreciate it!

idiot

Which version?

Horse06

We are using version 4.0. Thanks!

idiot

Try the version from 4.01 or 4.02 where they fixed somethings...