Skip to Content
Menu
This question has been flagged
1 Reply
2183 Views

Dear all,

I want to the system to be able to automatically update my purchase price as the sales price, without me having to do the adjustment. 

Can anyone one suggest how this can be done pls ?


Thanks.

Avatar
Discard
Best Answer

Hello Oluwafunto,

First, enable developer tools.

Then, in the technical menu go to Automation > Automated Actions.

Create a new one, and this is how you should configure it so that when you modify or create a product, the cost will be equal to the sales price.

Model = Product Template

Trigger = On Creation & Update

Trigger Fields = Sales Price (product.template)

Action To Do = Update the Record

And in the Data to Write tab, add:

Field = Cost (product.template)

Evaluation Type = Python expression

Value = record.list_price


Hope it helps

Avatar
Discard
Author

Hello Plaitin,
Thank you for your response.
I have made the above configuration, but the sales price didn't not update when I raised a purchase order. Is there anything I am missing out please?

Yes because my answer is based on the update and creation of a product form.

It adapts the cost when you change the Sales price on the form.

First, you need to adjust it the other way around to fit your request. It was not clear.

Even though, the automated action is not triggered after the cost was modified after the reception of goods. I don't know why.

Author

Plaitin,

Can you please help me with the configuration settings to fit my requirement? (Update sales price using the price on the PO).

I tried to adjust it the other way round to fit in as suggested, no breakthrough.

Sorry, I do not know how to.

Author

oops.

Thank you

Related Posts Replies Views Activity
2
Jun 24
15517