Aged Debtor Analysis

[agaluski]

If you run the Statements program it should take care of this.
Sometimes the float issue in the fields used to store amounts leaves tiny little decimals out there.
There is a block around line 52 in the PrintCustStatements.php that takes care of this

PHP Code:

/* Do a quick tidy up to settle any transactions that should have been settled at the time of allocation but for whatever reason weren't */
    $ErrMsg = _('There was a problem settling the old transactions.');
    $DbgMsg = _('The SQL used to settle outstanding transactions was');
    $sql = "UPDATE debtortrans SET settled=1
            WHERE ABS(debtortrans.ovamount+debtortrans.ovdiscount+debtortrans.ovfreight+debtortrans.ovgst-debtortrans.alloc)<0.009";
    $SettleAsNec = DB_query($sql,$db, $ErrMsg, $DbgMsg);