Aged Debtor Analysis

[daveparrish]

My mistake - you said they were already settled. I was looking to close them out - which they already are closed.

What version are you running?
In AgedDebtors.php my version has a line around 362 in the show detail section that limits showing these fractions.
AND ABS(debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount - debtortrans.alloc)>0.004";

You can also add "AND settled=0" to your detailed query. This will hide settled transactions from the details.

Version 4.12.3

What I did is run this script below on lab server and seems to clean up all the issues with .01 -.01 also there are some that had -0.00 show up.
Also there were some on the statements showing .01 and -.01 that the script cleared up.
Would this have any other affects on the data that I am missing all seems well after running.

UPDATE debtortrans
SET debtortrans.alloc=debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount
WHERE debtortrans.settled=1

Thanks for all the help