Jacopo Thanks for pointing these all out. I had already considered b and C , but was not aware of A. I'll have to explore the entities involved. In case A, is there a billing account involved?
Skip -----Original Message----- From: Jacopo Cappellato [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 11:32 PM To: dev@ofbiz.apache.org Subject: Re: Accounts Receivable Hi Skip, [EMAIL PROTECTED] wrote: > Scott > > In my view, this is kinda the hard way of doing things. > > Easy way: > > billing account amount = SUM(unpaid invoice amounts) > billing account available balance = billing acount limit - (billing account > amount + uninvoiced orders) > > Because customer returns and credits also generate an invoice, this all > works. > > Simple as long as you can determine which invoices are unpaid. Of course, > If you are gonna do a proper customer billing statement, you have to know > this anyway. > > I have no idea why you guys feel the need to cling to this > OrderPaymentPreferences entity for computing billing accounts. > > Skip > Please, when fixing this, also consider the following situations: a) if you select, during order entry, an offline payment, then in the order detail screen you can receive the payment (also a partial payment) even if there are no invoices for the order: the system creates a Payment record with no PaymentApplications (the Payment is associated to the OrderPaymentPreference) b) an order, associated to a billing account could be only partially invoiced (partially shipped order) c) handle payment in advance: the customer fills the billing account with a payment, and then consume that amount to pay orders Jacopo