Re: Accounts Receivable

Posted by Jacopo Cappellato on Nov 03, 2007; 7:31am
URL: http://ofbiz.116.s1.nabble.com/Accounts-Receivable-tp184969p184983.html

Hi Skip,

skip@theDevers 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