Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
gltrans amount uses double and not decimal
05-21-2016, 04:57 AM,
#3
RE: gltrans amount uses double and not decimal
(05-18-2016, 10:49 PM)agaluski Wrote: 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.

Thanks agaluski I will go locate problems and let you know.

Reply


Messages In This Thread
RE: gltrans amount uses double and not decimal - by Bill Schlaerth - 05-21-2016, 04:57 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)