What we are doing now, is to add a term for each payment.Here is the data defined in OFBiz to get an invoice that will be paid with 3 payments:
<TermType description="Payment net days, part 1" hasTable="N" parentTypeId="FIN_PAYMENT_TERM" termTypeId="FIN_PAY_NETDAYS_1"/> <TermType description="Payment net days, part 2" hasTable="N" parentTypeId="FIN_PAYMENT_TERM" termTypeId="FIN_PAY_NETDAYS_2"/> <TermType description="Payment net days, part 3" hasTable="N" parentTypeId="FIN_PAYMENT_TERM" termTypeId="FIN_PAY_NETDAYS_3"/>
If you need more payments, you should create more records like the ones above. Then you just have to add all the one you want to the order, for example if you want an order paid with 2 payments, you will add the first two records: Part1: termDays= 30, termValue=80 (i.e. pay within 30 days the 80% of the order) Part1: termDays= 60, termValue=20 (i.e. pay within 60 days the remaining 20% of the order)
Jacopo On Aug 9, 2008, at 10:09 PM, Daniel Riquelme wrote:
I was thinking about doing something like this. 1) Define a TermType that specifies that an Invoice must be paid in N monthly sub payments.2) Perform a calculation every month to inform the customers how much dothey owe that specific month. Perhaps in this monthly process it would be convenient to use aSubPaymentInfo Entity to track debt and payment. This would simplify theDebt Collection queries and customer pay analysis. DanielOn Fri, Aug 8, 2008 at 9:41 AM, BJ Freeman <[EMAIL PROTECTED]> wrote:[What do receivables have to do with agreements, except perhaps to determine terms on invoices or something? ] David we were talking about, is determining terms on invoices. Likepayment schedule. To my way of thinking, any money owed the company, for product or service sold, is receivables, from an accounting point of view.so I am not sure why you expressed yourself, since it looks like we agree.David E Jones sent the following on 8/7/2008 10:57 PM:What's the difference... I see none. -David On Aug 7, 2008, at 11:51 PM, BJ Freeman wrote:so how is correct you or Jacopo David E Jones sent the following on 8/7/2008 10:46 PM:What do receivables have to do with agreements, except perhaps to determine terms on invoices or something? The main entities, and related functionality to look at, are the BillingAccount (has credit limit, and all invoices and paymentsrelevantare attached to it), and of course Invoice, Payment, and PaymentApplication. Receivables are best reviewed with outstanding invoices, which are of course posted to the GL too if it is setup properly. -David On Aug 7, 2008, at 8:40 PM, BJ Freeman wrote:hopefully someone that is doing the financial can tell you about theconnection of agreements to receivables.The agreement is the contract, but the invoice that is generated from the agreement would be what you put you payments against. I believethis is implemented but would have to check.service (not yet done) can be scheduled to run on certain day like15th to check if payments are made.the part I do know is that the email to send such info and the widgetsto create the format you have is not in ofbiz at this moment. however all the data is available. the payments should have the invoice number on them to be applied correctly. Daniel Riquelme sent the following on 8/7/2008 6:54 PM:Correct me if I'm wrong.To express that the payment to an order is to be divided in 12 subpayments each of them due the 15th of the following 12 months I need to create an Agreement that says something like: Payment (due on specified day of month), Term value = 15 Payment (number of sub payments), Term value = 12 My question is: If the following 15th the client has paid, how do I apply that payment to the agreement ? I would like to send to the client the following information regarding their due payments: For the product X you have made 10 sub payments out of 11For the priduct Y you owe me your 5th sub payment out of (10), andit's over due so you owe me Z in interest. Thanks four your help. On Thu, Aug 7, 2008 at 9:32 PM, Daniel Riquelme <[EMAIL PROTECTED]>wrote:Thanks, I'll take a look at them.On Thu, Aug 7, 2008 at 9:29 PM, BJ Freeman <[EMAIL PROTECTED] man.net>wrote:Agreements Daniel Riquelme sent the following on 8/7/2008 6:23 PM:Hi,I would like to know if is possible to express future payments inacreditsale.Perhaps with some sort of payment schedule which indicates duedate and amount for payments. Best Regards, Daniel
smime.p7s
Description: S/MIME cryptographic signature
