dolibarr-tasktrack
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Dolibarr-tasktrack] [Task #645] Remove field fk_product_fournisseur_pri


From: Doliforge
Subject: [Dolibarr-tasktrack] [Task #645] Remove field fk_product_fournisseur_price from all "->addline" and "->updateline" method. Remove fields from details tables.
Date: Thu, 06 Jun 2013 18:53:07 +0200

Doliforge
Is this email not displaying correctly?
update email preferences.

Remove field fk_product_fournisseur_price from all "->addline" and "->updateline" method. Remove fields from details tables.

Latest modifications

2013-06-06 18:53 (Europe/Paris)
I agree with you. What i would like to say is that field is useless once invoice is done.

If we speak about order, proposal, this field is required to be used later to get current supplier price (or not) when building invoice.
For invoice, field should be useless. However to have same fields between elements (orders, invoices, proposal...), we may keep the field also for invoices. So i close task (i have just added comment onto fields of sql files)

Answer now

Snapshot

 Details
Submitted by:  Laurent Destailleur (eldy) Last Modified On:  2013-06-06 14:21
Submitted on:  2012-12-19 15:57 
Summary:  Remove field fk_product_fournisseur_price from all "->addline" and "->updateline" method. Remove fields from details tables.
Description:  Remove field fk_product_fournisseur_price from all addline method and details tables.
This field is useless, because the pa_ht is used instead for margin calculation.
Priority:  9 - Highest Open to Any Developer:  No
Subproject:  None Assigned to (multiple):  None
 Status
Start Date:  - End Date:  -
Completion (0-100%):  0 Status:  Open

Comments

Laurent Destailleur 2013-06-06 18:53
I agree with you. What i would like to say is that field is useless once invoice is done.

If we speak about order, proposal, this field is required to be used later to get current supplier price (or not) when building invoice.
For invoice, field should be useless. However to have same fields between elements (orders, invoices, proposal...), we may keep the field also for invoices. So i close task (i have just added comment onto fields of sql files)
Christophe Battarel 2013-06-06 14:21
i persist to think that margin calculation must be made at invoice time, so the buying price must be the one at invoice time.
if a customer orders a 10 euros product that costs me 5 euros at this time, but when i do the invoice it costs 6 euros, the margin is 10 - 6, and not 10 - 5.
other solution, we should maybe use an average price (PMP in french) but it can only be done with stocked products.
Laurent Destailleur 2013-06-05 22:34
Price used when order is defined must be saved into pa_ht.
So price can change after, it is not a problem since value used was saved during order creation. There is no reason to have a link to a table that is a view at t time, so a value useless for calculation since what we need is value when element was created.
address@hidden 2012-12-19 22:34
This field is used in case supplier price change between order and invoice
Laurent Destailleur 2012-12-19 17:42
Remove field fk_product_fournisseur_price from all "->addline" and "->updateline" method.
Remove fields from details tables.
Remove also field label that are duplicate fields and create conflicts.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]