You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Derek Lew <eu...@hotmail.com> on 2015/10/07 14:28:22 UTC

Create payment milestones/schedule for Sales/Purchase Order

Hi,

 

Is it possible to create payment milestones for the Sales/Purchase Order.
E.g. 20% down payment, 80% upon delivery.  Or quarterly payments.

 

Best regards. 
  
Derek Lew

 


Re: Create payment milestones/schedule for Sales/Purchase Order

Posted by Jacopo Cappellato <ja...@hotwaxsystems.com>.
On Thu, Oct 8, 2015 at 6:14 AM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:

> PS: I thought about another way, but it a bit different: subscriptions. Of
> course only interesting if you have recurring payments, which does not seem
> to be the case.
>
>
Oh  yes, you are right Jacques, this would be a third option:

c) four orders; 4 invoices; four payments

Jacopo

Re: Create payment milestones/schedule for Sales/Purchase Order

Posted by Jacques Le Roux <ja...@les7arts.com>.
Derek,

Looks like you not only got a data-model+code but also specifications :)

Thanks Jacopo!

Jacques
PS: I thought about another way, but it a bit different: subscriptions. Of course only interesting if you have recurring payments, which does not seem 
to be the case.


Le 08/10/2015 05:56, Jacopo Cappellato a écrit :
> Hi Derek,
>
> please see my comment below:
>
> On Thu, Oct 8, 2015 at 2:26 AM, Derek Lew <eu...@hotmail.com>
> wrote:
>
>> E.g. an order of $1M, can be paid in quarterly, so in Jan, Apr, Jul, Oct,
>> $250K would be invoiced.  The customer would pay in 30 days (assuming if 30
>> days term), after the receipt of invoice.
>>
>>
> you could model the above scenario in the following alternative ways:
>
> a) one order; four invoices of $250K each; every invoice has a 30 days
> payment term; four payments of $250K
>
> b) one order; one invoice of $1M each; the invoice has four payment terms
> (3, 6, 9, 12 months); four payments of $250K each
>
> Jacopo
>

Re: Create payment milestones/schedule for Sales/Purchase Order

Posted by Jacopo Cappellato <ja...@hotwaxsystems.com>.
Hi Derek,

please see my comment below:

On Thu, Oct 8, 2015 at 2:26 AM, Derek Lew <eu...@hotmail.com>
wrote:

>
> E.g. an order of $1M, can be paid in quarterly, so in Jan, Apr, Jul, Oct,
> $250K would be invoiced.  The customer would pay in 30 days (assuming if 30
> days term), after the receipt of invoice.
>
>
you could model the above scenario in the following alternative ways:

a) one order; four invoices of $250K each; every invoice has a 30 days
payment term; four payments of $250K

b) one order; one invoice of $1M each; the invoice has four payment terms
(3, 6, 9, 12 months); four payments of $250K each

Jacopo

RE: Create payment milestones/schedule for Sales/Purchase Order

Posted by Derek Lew <eu...@hotmail.com>.
Thanks, let me take a look.

-----Original Message-----
From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com] 
Sent: Thursday, 8 October 2015 11:49 AM
To: user@ofbiz.apache.org
Subject: Re: Create payment milestones/schedule for Sales/Purchase Order

You may define specific agreement terms to handle "quarterly payment, percentage payment, etc. "

I'd refer to Silverston's book vol I, where the data model used by OFBiz is defined: 
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books

Of course related specific code needs also to be introduced. At least you have a data-model/existing-code framework to help you doing so Of course have also a look at the OOTB demo data to get you on the right track.

HTH

Jacques

Le 08/10/2015 02:26, Derek Lew a écrit :
> Hi Taher,
>
> Thanks.
>
> Correct me if I am wrong, the payment term is for after the issue is sent.  E.g. 30 days term, meant to be payment after 30 days of receiving invoice.
>
> However, payment milestones are talking about quarterly payment, percentage payment etc.
>
> E.g. an order of $1M, can be paid in quarterly, so in Jan, Apr, Jul, Oct, $250K would be invoiced.  The customer would pay in 30 days (assuming if 30 days term), after the receipt of invoice.
>
> Once again, thank you for your response.
>
> Derek
>
> -----Original Message-----
> From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com]
> Sent: Thursday, 8 October 2015 2:15 AM
> To: user@ofbiz.apache.org
> Subject: Re: Create payment milestones/schedule for Sales/Purchase 
> Order
>
> Hi Derek,
>
> Entering the payment terms is part of the order entry. You can investigate the screens and check it out on demo.
>
> Cheers,
>
> Taher Alkhateeb
>
> ----- Original Message -----
>
> From: "Derek Lew" <eu...@hotmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, 7 October, 2015 6:09:20 PM
> Subject: RE: Create payment milestones/schedule for Sales/Purchase 
> Order
>
> Hi Taher,
>
> I am looking at Sales/Purchase Order, not yet reaching the invoice stage.
>
> Derek
>
> -----Original Message-----
> From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com]
> Sent: Wednesday, 7 October 2015 8:34 PM
> To: user@ofbiz.apache.org
> Subject: Re: Create payment milestones/schedule for Sales/Purchase 
> Order
>
> Hi Derek,
>
> Look at payment terms on the invoice.
>
> Taher Alkhateeb
>
> ----- Original Message -----
>
> From: "Derek Lew" <eu...@hotmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, 7 October, 2015 3:28:22 PM
> Subject: Create payment milestones/schedule for Sales/Purchase Order
>
> Hi,
>
>
>
> Is it possible to create payment milestones for the Sales/Purchase Order.
> E.g. 20% down payment, 80% upon delivery. Or quarterly payments.
>
>
>
> Best regards.
>
> Derek Lew
>
>
>
>
>
>
>

Re: Create payment milestones/schedule for Sales/Purchase Order

Posted by Jacques Le Roux <ja...@les7arts.com>.
You may define specific agreement terms to handle "quarterly payment, percentage payment, etc. "

I'd refer to Silverston's book vol I, where the data model used by OFBiz is defined: 
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books

Of course related specific code needs also to be introduced. At least you have a data-model/existing-code framework to help you doing so
Of course have also a look at the OOTB demo data to get you on the right track.

HTH

Jacques

Le 08/10/2015 02:26, Derek Lew a écrit :
> Hi Taher,
>
> Thanks.
>
> Correct me if I am wrong, the payment term is for after the issue is sent.  E.g. 30 days term, meant to be payment after 30 days of receiving invoice.
>
> However, payment milestones are talking about quarterly payment, percentage payment etc.
>
> E.g. an order of $1M, can be paid in quarterly, so in Jan, Apr, Jul, Oct, $250K would be invoiced.  The customer would pay in 30 days (assuming if 30 days term), after the receipt of invoice.
>
> Once again, thank you for your response.
>
> Derek
>
> -----Original Message-----
> From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com]
> Sent: Thursday, 8 October 2015 2:15 AM
> To: user@ofbiz.apache.org
> Subject: Re: Create payment milestones/schedule for Sales/Purchase Order
>
> Hi Derek,
>
> Entering the payment terms is part of the order entry. You can investigate the screens and check it out on demo.
>
> Cheers,
>
> Taher Alkhateeb
>
> ----- Original Message -----
>
> From: "Derek Lew" <eu...@hotmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, 7 October, 2015 6:09:20 PM
> Subject: RE: Create payment milestones/schedule for Sales/Purchase Order
>
> Hi Taher,
>
> I am looking at Sales/Purchase Order, not yet reaching the invoice stage.
>
> Derek
>
> -----Original Message-----
> From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com]
> Sent: Wednesday, 7 October 2015 8:34 PM
> To: user@ofbiz.apache.org
> Subject: Re: Create payment milestones/schedule for Sales/Purchase Order
>
> Hi Derek,
>
> Look at payment terms on the invoice.
>
> Taher Alkhateeb
>
> ----- Original Message -----
>
> From: "Derek Lew" <eu...@hotmail.com>
> To: user@ofbiz.apache.org
> Sent: Wednesday, 7 October, 2015 3:28:22 PM
> Subject: Create payment milestones/schedule for Sales/Purchase Order
>
> Hi,
>
>
>
> Is it possible to create payment milestones for the Sales/Purchase Order.
> E.g. 20% down payment, 80% upon delivery. Or quarterly payments.
>
>
>
> Best regards.
>
> Derek Lew
>
>
>
>
>
>
>

RE: Create payment milestones/schedule for Sales/Purchase Order

Posted by Derek Lew <eu...@hotmail.com>.
Hi Taher, 

Thanks.

Correct me if I am wrong, the payment term is for after the issue is sent.  E.g. 30 days term, meant to be payment after 30 days of receiving invoice.

However, payment milestones are talking about quarterly payment, percentage payment etc.  

E.g. an order of $1M, can be paid in quarterly, so in Jan, Apr, Jul, Oct, $250K would be invoiced.  The customer would pay in 30 days (assuming if 30 days term), after the receipt of invoice.

Once again, thank you for your response.

Derek

-----Original Message-----
From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com] 
Sent: Thursday, 8 October 2015 2:15 AM
To: user@ofbiz.apache.org
Subject: Re: Create payment milestones/schedule for Sales/Purchase Order

Hi Derek, 

Entering the payment terms is part of the order entry. You can investigate the screens and check it out on demo. 

Cheers, 

Taher Alkhateeb 

----- Original Message -----

From: "Derek Lew" <eu...@hotmail.com> 
To: user@ofbiz.apache.org 
Sent: Wednesday, 7 October, 2015 6:09:20 PM 
Subject: RE: Create payment milestones/schedule for Sales/Purchase Order 

Hi Taher, 

I am looking at Sales/Purchase Order, not yet reaching the invoice stage. 

Derek 

-----Original Message----- 
From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com] 
Sent: Wednesday, 7 October 2015 8:34 PM 
To: user@ofbiz.apache.org 
Subject: Re: Create payment milestones/schedule for Sales/Purchase Order 

Hi Derek, 

Look at payment terms on the invoice. 

Taher Alkhateeb 

----- Original Message ----- 

From: "Derek Lew" <eu...@hotmail.com> 
To: user@ofbiz.apache.org 
Sent: Wednesday, 7 October, 2015 3:28:22 PM 
Subject: Create payment milestones/schedule for Sales/Purchase Order 

Hi, 



Is it possible to create payment milestones for the Sales/Purchase Order. 
E.g. 20% down payment, 80% upon delivery. Or quarterly payments. 



Best regards. 

Derek Lew 






Re: Create payment milestones/schedule for Sales/Purchase Order

Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Derek, 

Entering the payment terms is part of the order entry. You can investigate the screens and check it out on demo. 

Cheers, 

Taher Alkhateeb 

----- Original Message -----

From: "Derek Lew" <eu...@hotmail.com> 
To: user@ofbiz.apache.org 
Sent: Wednesday, 7 October, 2015 6:09:20 PM 
Subject: RE: Create payment milestones/schedule for Sales/Purchase Order 

Hi Taher, 

I am looking at Sales/Purchase Order, not yet reaching the invoice stage. 

Derek 

-----Original Message----- 
From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com] 
Sent: Wednesday, 7 October 2015 8:34 PM 
To: user@ofbiz.apache.org 
Subject: Re: Create payment milestones/schedule for Sales/Purchase Order 

Hi Derek, 

Look at payment terms on the invoice. 

Taher Alkhateeb 

----- Original Message ----- 

From: "Derek Lew" <eu...@hotmail.com> 
To: user@ofbiz.apache.org 
Sent: Wednesday, 7 October, 2015 3:28:22 PM 
Subject: Create payment milestones/schedule for Sales/Purchase Order 

Hi, 



Is it possible to create payment milestones for the Sales/Purchase Order. 
E.g. 20% down payment, 80% upon delivery. Or quarterly payments. 



Best regards. 

Derek Lew 






RE: Create payment milestones/schedule for Sales/Purchase Order

Posted by Derek Lew <eu...@hotmail.com>.
Hi Taher, 

I am looking at Sales/Purchase Order, not yet reaching the invoice stage.

Derek

-----Original Message-----
From: Taher Alkhateeb [mailto:slidingfilaments@gmail.com] 
Sent: Wednesday, 7 October 2015 8:34 PM
To: user@ofbiz.apache.org
Subject: Re: Create payment milestones/schedule for Sales/Purchase Order

Hi Derek, 

Look at payment terms on the invoice. 

Taher Alkhateeb 

----- Original Message -----

From: "Derek Lew" <eu...@hotmail.com> 
To: user@ofbiz.apache.org 
Sent: Wednesday, 7 October, 2015 3:28:22 PM 
Subject: Create payment milestones/schedule for Sales/Purchase Order 

Hi, 



Is it possible to create payment milestones for the Sales/Purchase Order. 
E.g. 20% down payment, 80% upon delivery. Or quarterly payments. 



Best regards. 

Derek Lew 





Re: Create payment milestones/schedule for Sales/Purchase Order

Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Derek, 

Look at payment terms on the invoice. 

Taher Alkhateeb 

----- Original Message -----

From: "Derek Lew" <eu...@hotmail.com> 
To: user@ofbiz.apache.org 
Sent: Wednesday, 7 October, 2015 3:28:22 PM 
Subject: Create payment milestones/schedule for Sales/Purchase Order 

Hi, 



Is it possible to create payment milestones for the Sales/Purchase Order. 
E.g. 20% down payment, 80% upon delivery. Or quarterly payments. 



Best regards. 

Derek Lew