[comp.databases] Unify help

emrozek@ecsvax.UUCP (Ed Mrozek) (02/18/88)

I am working with several projects that require some accounting in them.
Not being a business type, I plead for any assistance from anyone who
can make available a basic set of routiness to do receivables under
UNIFY.  I will also accept any rules of thumb that you might share
and warn you that at this point I probably won't be able to tell good 
advice from bad.

Are there any kind hearted souls out there wiling to share.  At this 
point, I am not interested in anything except information on commercial
packages.

I do offer to post a summary of what I get if there is interest.

Please e-mail responses to emrozek@ecsvax

UH2@PSUVM.BITNET (Lee Sailer) (02/18/88)

In article <4623@ecsvax.UUCP>, emrozek@ecsvax.UUCP (Ed Mrozek) says:
>
>I am working with several projects that require some accounting in them.
>Not being a business type, I plead for any assistance from anyone who
>can make available a basic set of routiness to do receivables under
>UNIFY.  I will also accept any rules of thumb that you might share
>and warn you that at this point I probably won't be able to tell good
>advice from bad.

Free advice--you get what you pay for...

If the accounting system needn't be too powerful, you can probably
crib from an accounting information systems textbook.  You might
find "Case Studies in Business Data Systems" by Bradley (HRW, isbn
0-03-014134-6) of use.  |This book, and others, discuss how to implement
Accounting systems in the relational model, and should be easily
mapped on to Unify.

Secondly, be advised that in several key areas, Accounting Practice
and modern Relational Theory disagree.  In short, RT usually
strives to reduce redundancy in the database to ensure integrity
and consistencey.  AP often introduces redundancy by calculating
different balances in several different ways, and then compares
the balances as an integrity check.  In these cases, Accounting
Practice takes precedence, since auditors are accountants and they
insist that things be done their way.

Accounting is a lot harder than it looks, but then again, isn't that
true of anything that you look at closely?

                                          lee