You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
<div class="centre">' . _('This will update debtor transactions to show them as fully allocated where there is less than 1 cent remaining unallocated.') . '<br /><input type="submit" name="FixAllocations" value="' . _('Fix Allocations') .'" />
</div></form>';
if (isset($_POST['FixAllocations'])){
DB_query('UPDATE debtortrans
SET alloc=ovamount+ovgst+ovfreight+ovdiscount, settled=1
WHERE ABS(alloc-ovamount-ovgst-ovfreight-ovdiscount) <0.01;');