Aged Debtor Analysis

[phil]

It shouldn't be possible to have settled=1
if debtortrans.alloc NOT == (debtortrans.ovamount + debtortrans.ovgst + debtortrans.ovfreight + debtortrans.ovdiscount)
these miserable rounding issues normally arise out of currency exchange arithmetic.
So, your

Code:

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

SHOULD be ok ... but just check your debtors control account (from company preferences) agrees to the total of all balances as converted to local currency from DebtorsAtPeriodEnd.php script with a period end after today.