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.
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.
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.
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";