Estimating Software
Project Management Software
Accounting Software
Inventory SoftwareInventory Management SoftwareBookkeeping SoftwareTime Tracking SoftwareConstruction Estimating SoftwareConstruction Management SoftwareProject Management Software

Subtracting Numbers over 1 Billion

PROBLEM

Doing math that involves subtraction of numbers over 1 billion gives a #Number Too Big error (which shouldn't happen until the value hits 2 billion).

Caught By

User bug report.

Workaround

Avoid numbers over 1 billion in transactions that include subtraction (e.g. discounts).

Solution

This bug is fixed in version 3.3. That update also adds a decimal shift option so you can handle numbers up to 20 trillion.

Technical Details

Goldenseal was being too conservative when checking for numbers that might "overflow" during subtraction.

NOTE-- We store our money and number values with a 31-bit signed number for the dollar portion, which allows numbers up to 2 billion.