Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
gltrans amount uses double and not decimal
05-18-2016, 10:49 PM,
#2
RE: gltrans amount uses double and not decimal
I have seen this problem cause the balance to be off by very tiny portions of a penny - never multiple pennies. Are you sure that is the problem?
There have been a few times that rounding on W/O close has caused us to have an unbalanced entry off by .01.
Change this program: Z_CheckGLTransBalance.php.
Replace: HAVING ABS(SUM(amount))>0.01";
with: HAVING ABS(SUM(amount))>0.005";
Run it in the application - see if you have any unbalanced type "Work Order Variance" transactions.


Reply


Messages In This Thread
RE: gltrans amount uses double and not decimal - by agaluski - 05-18-2016, 10:49 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)