Trial Balance

[agaluski]

My Trial balance off by .01, assuming it is due to some rounding. what is the best way to track this down?

---

Actually found a bad transaction. Wondering how this could happen.
And how to fix it.

[TimSchofield]

Hi Andrew, what are the actual values in the database for this?

Tim

[agaluski]

DB values are same as shown in screen shot. .03, -.03, .01.
No rounding.
Variance was .03 on the order. Expecting somehow the W/O close insert of gltrans using round function forced the extra penny.

---

Considering it is only .01, change that gltrans to .00 and run Z_RePostGLFromPeriod.php for the period before forward.

[TimSchofield]

That would solve it but it would be nice to find out why it happebed.

Tim

[agaluski]

For sure some or all of the inventory built on the W/O was shipped out before the W/O was closed meaning the inventory OH was less than the W/O Quantity. I know that for sure. Again - I probably could recreate it when i get some more time to setup the same BOM, costing, OH, orders etc. I noticed it happened outside of our backup retention period so it will take a little work.

[agaluski]

Happened again this month. .01 off
W/O Variance posting. 0.00, 0.00 and 0.01
Also bug in Z_CheckGLTransBalance.php doesn't show this as an unbalanced transaction because logic shows

PHP Code:

$sql = "SELECT gltrans.type,
        systypes.typename,
        gltrans.typeno,
        periodno,
        SUM(amount) AS nettot
    FROM gltrans,
        systypes
    WHERE gltrans.type = systypes.typeid
    GROUP BY gltrans.type,
        systypes.typename,
        typeno,
        periodno
    HAVING ABS(SUM(amount))>0.01"; 


SHOULD be

PHP Code:

HAVING ABS(SUM(amount))>=0.01"; 


More analysis needed