Subtracting Numbers over 1 Billion

PROBLEM

Doing math that involves subtraction of numbers over 1 billion gives a #Number Too Big error in Goldenseal accounting software version 3.2. That error 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 of Goldenseal accounting software. 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.