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
