Product Price based on Product cost + Margin

[Pritesh Shah]

Hello,

I have one requirement where when product is selected in the SO line, product price in the unit price should be set based on the current product cost in the system plus some margin.

For example, current product cost of PChair is $10 and margin required on the product is 20% then in SO line when Pchair is selected, unit price should set as $12.

After sometime, if the product cost changes to $12 then unit price should become $14.4. Hence product price on SO should be calculated on the fly based on the current product cost.

Can anyone help me to achieve this in idempiere?

Thanks, 

Pritesh

[Syed (syvasoft)]

Hi Pritesh, 

In my mind, I have these two options for your requirement.

Using Price List:

Write a new process which will create/update Price List based on "Products' Current Cost + Margin",  rather than using existing "Create Price List" process.

Using Callout:

Write a callout for Product field in SO Line to set the unit price based on "Product Cost + Margin".

You decide which one suits your business requirement.

Regards,

Syed.

[Pritesh Shah]

I am not sure but how does the pricelist schema works in iDempiere. Do you have any idea about the same?

Callout looks good but i want to explore if anything already there in iDempiere.

Thanks,
Pritesh

On 27-Jul-2016 8:03 pm, "Syed (syvasoft)" <sy...@syvasoft.com> wrote:

Hi Pritesh, 

In my mind, I have these two options for your requirement.

Using Price List:

Write a new process which will create/update Price List based on "Products' Current Cost + Margin",  rather than using existing "Create Price List" process.

Using Callout:

Write a callout for Product field in SO Line to set the unit price based on "Product Cost + Margin".

You decide which one suits your business requirement.

Regards,

Syed.

Why don't you create a DB View for purchase price-list including all "best known purchase prices"? 

Then write a process which will use the "best known purchase prices" View  to populate the "common price-list" rather than using existing "Create Price List" process.

On Wednesday, July 27, 2016 at 7:40:01 PM UTC+5:30, Pritesh Shah wrote:

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/df279e95-6881-48e3-9b21-b3a76ed67d61%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Syed (syvasoft)]

More info on Price List:

http://wiki.adempiere.net/Price_List_Setup

http://wiki.compiere.com/display/docs/Pricing

http://wiki.idempiere.org/en/Price_List_(Window_ID-146)

https://www.safaribooksonline.com/library/view/adempiere-34-erp/9781847197269/ch04s05.html