Jacopo, Thanks for thinking through this. Makes sense to me. Thanks and Regards Anil Patel HotWax Media Inc http://www.hotwaxmedia.com http://us.apachecon.com/c/acus2009/sponsors/sponsors
On Nov 23, 2009, at 5:36 AM, Jacopo Cappellato wrote: > I would like to introduce the following changes to the entity definitions of > AcctgTrans and AcctgTransEntry: > > 1) move the field AcctgTransEntry.currencyUomId to AcctgTrans.currencyUomId > (but keeping the AcctgTransEntry.origCurrencyUomId as is now) > 2) add the new field AcctgTrans.totalAmount: for a valid transaction the > field (its absolute value) will have to match with absolute value of the sum > of all credits (or debits); before a transaction it is posted, the system > will check that AcctgTrans.totalAmount = sum of all credits (AcctgTransEntry) > = sum of all debits (AcctgTransEntry) > > Main reasons for this: > a) since the records in AcctgTrans actually represents the lines of a > Journal, it makes sense to have in them all the fields required by journals > (type/description of the transaction, date and amount) > b) the user workflow will be improved: when the AcctgTrans is created (before > the entries) the user already know the amount to be posted (and split into > the different Ledgers) > > What do you think? > > Jacopo >