manufacturing job/order fulfillment financing

[gp]

Hello.  I am currently investigating if tryton would be a good solution for my problem.

How would one model the following flow:

• Order placed by customer
• Loan taken out against order for cost (not sale price) required to manufacture and fulfill order
• Order fulfilled and paid by customer for sale price
• Loan amount plus interest repaid
• interest fee recorded and used to calculate order profit/margin/roi for individual order and overall
  

Is tryton capable of this?

[Cédric Krier]

On 2017-01-26 09:04, gp wrote:
> Hello. I am currently investigating if tryton would be a good solution for
> my problem.
>
> How would one model the following flow:
>

> - Order placed by customer
> - Loan taken out against order for cost (not sale price) required to
> manufacture and fulfill order
> - Order fulfilled and paid by customer for sale price
> - Loan amount plus interest repaid
> - interest fee recorded and used to calculate order profit/margin/roi

> for individual order and overall

I do not understand why is not the loan used to pay the sale?

Otherwise it sounds in between the sale_advanced_payment [1] and the
account_deposit [2] but both reuse the deposit/payment to actually pay
the invoice.
Also none has a interest computation but I think it makes sense only for
deposit.
It will be a matter of defining a rate and compute it over the period to
post a move that will credit the deposit account.
But if it is a deposit, I can not see how you can include the interest
in the computation of the sale profit/margin. Interest should not be a
cost.
Also I think you need to be a registered bank to compute interest.


[1] https://discuss.tryton.org/t/sale-advanced-payments/221
[2] http://doc.tryton.org/4.2/modules/account_deposit/doc/index.html

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[gp]

I do not understand why is not the loan used to pay the sale?

By the way... I think miscommunication has occurred.  The loan is taken out by the company not the customer.  The company uses the loan to manufacture the products ordered by the customer.  That is why it is a cost to the company profit and not the customer 

[gp]

I do not understand why is not the loan used to pay the sale?

The loan is used to fund manufacturing the product that the customer has purchased.  The product sold to the customer is built to order.

 

Interest should not be a cost.

 

The interest paid for the loan is a "fee" so it must be subtracted from the profit of the sale to calculate actual profit.

Also I think you need to be a registered bank to compute interest.

What do you mean by this? 

[Cédric Krier]

On 2017-01-26 10:23, gp wrote:
>
> >
> > I do not understand why is not the loan used to pay the sale?
> >
>
> The loan is used to fund manufacturing the product that the customer has
> purchased. The product sold to the customer is built to order.
>
> >
> > I do not understand why is not the loan used to pay the sale?
> >

> By the way... I think miscommunication has occurred. The loan is taken out
> by the company not the customer. The company uses the loan to manufacture
> the products ordered by the customer. That is why it is a cost to the
> company profit and not the customer

OK, it is clearer.
So you want to add the loan interest to the cost of the production.
I guess the amount of the loan is reflected in the cost of the component
used for the production.

So for me, it looks like this feature:
https://discuss.tryton.org/t/bom-and-labour-input-costs/283/8?u=ced
But of course, in your case the extra cost could not be predefined in
the BoM but I guess added it manually on each production order should
work.
The production module is designed to allow easy customization of the
production cost.

[Cédric Krier]

I forgot to say that in case of the loan interest is known after the
production, it is still possible to implement something similar to the
landed cost but for production.

http://doc.tryton.org/4.2/modules/account_stock_landed_cost/doc/index.html