The Ultimate Business Machine - Archives
List of Categories : Commentary * Database * Singapore * Technology * Travel *
Fri 06 Oct 2006
Luca 2.3 Relesed
Category : Technology
I've released Luca 2.3 to run on OS X 10.4.8.
All the Preference Settings and Utility windows are now consolidated into one single Luca Preferences window, below :
Currency display formats and decimal number precision can now be set for individual currencies (e.g., the Japanese yen has no decimal places and you can now set this, as shown below, by setting Max fraction digits to 0) :
Instead of having its own Utility window, you can now check the status of the accounting period (e.g., whether you had closed the accounts for a certain month) in the Periods pane in the Preferences :
Certain accounts play important roles in the accounting system, e.g., you need to have an account to post Foreign Exchange Gain/Loss amounts to, and you need an account to post the year's Retained Earnings to, and you need to set up Checking Accounts that are linked to your bank accounts. This is now made clearer in the following Preference pane, which you can also use to assign a different account to play the selected role instead (if you had not yet made any postings to that special account) :
Finally, some changes have been made to Luca's database structure. You can use the following Preference Pane to upgrade an older Luca database :
To update an older MySQL database, re-import it into LucaDB (the built-in SQLite database), using the second button shown above. And then Export it back into MySQL. That should effect the database change.
The third button, shown above, is to allow the user to re-use an older SQLite-based Luca database. Just click on the button and show Luca where that previous SQLite LucaDB database is stored.
Of course, the whole point of this 2.3 release is to take advantage of Cocoa's NSDecimalNumber class to improve the numeric accuracy of Luca's data handling, and MySQL's ability to store these data objects as an equivalent Decimal data type. With this release I've eliminated the rounding errors associated with the use of floating point numbers, though some of this remains if we use the SQLite database since SQLite does not yet support the Decimal number format. But at least we've made some significant progress in business computing. And on the Mac, no less.