Post Reply 
Thread Rating:
  • 2 Votes - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
gltrans amount uses double and not decimal
05-18-2016, 05:41 AM
Post: #1
gltrans amount uses double and not decimal
Hi All,

We are a live customer and using webERP pretty well. Here is what we found in the gltrans table. The amount is a numeric defined as double. As a result we are finding amount going out to many more decimal places than 2. This causes the Trial balance and the Balance Sheet to be out of balance by pennies.

I understand when using exchange rates, but we were not expecting it in calculating Cost Of Goods when the qty is integers and the std cost is only to two places. Is the problem because the amount in gltrans is defined as double and maybe should be defined as decimal (14,2) or similar format?

We also saw an article on DOUBLE vs DECIMAL in MySQL that said financial amounts should not be defined as DOUBLE.

Your input is greatly appreciated.

Find all posts by this user
Quote this message in a reply
Post Reply 

Messages In This Thread
gltrans amount uses double and not decimal - Bill Schlaerth - 05-18-2016 05:41 AM

Forum Jump:

User(s) browsing this thread: 1 Guest(s)