[PLUG] java accounting math

[Rich Shepard]

On Wed, 6 Jun 2007, Carlos Konstanski wrote:

> Actually, most of the data is in an Oracle 9i database (the ERP backend).
> I could do all the accounting math in PLSQL. Then the results will be
> exactly as accurate as anything else in the system. This is actually a
> heck of an idea. Everyone in my department will consider this to be the
> best solution possible (except me; I want to write everything in lisp, but
> I'm a dweeb).

Carlos,

   This looks like the ideal solution: rewrite SL in Lisp and use Oracle as
the back end. SL supports PostgreSQL, Oracle, and DB2. :-)

> I have yet to install SQL Ledger, though I did obtain a copy when you last
> suggested it to me. It's something I mean to do.

   It may or may not be what you want, but the accounting algorithms work
(even if they're not the most polished). It will give you a frame of
reference if nothing else.

Have fun!

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863