The financials module uses the AcctgTransEntry to do this already.
Or you can use BillingAccount if you are setting up charge accounts.
On Aug 31, 2006, at 4:28 PM, Vinay Agarwal wrote:
Hello,
I am trying to create screen for showing customer balances similar
to our
utility bills - previous balance, paid, charges, and current
balance. But I
wasn't able to find appropriate entities for something like this.
Of course,
the balances can be created in real time but it may be more
efficient to
have some entities to consolidate prior invoices and payments.
I am thinking of creating a Balance entity as follows
Balance
partyIdFrom (typically Company)
partyIdTo
fromDate
thruDate (entity must be created after this
date to
make sure no other invoices or payments occur)
prevBalanceAmount
paymentsAmount
chargesAmount
currentBalance
Any thoughts?
Regards,
Vinay Agarwal
