Project

General

Profile

cost bulk edit

Added by riccardo bernardi over 6 years ago

Hi,
I am new on beCPG.
Is there any way to change the cost of multiple raw materials in bulk?
Or maybe to import the cost from excel/database table.

Many thanks,
Riccardo.


Replies (3)

RE: cost bulk edit - Added by Philippe Quéré over 6 years ago

Hello,

You can do Where used on costs and update cost of multiple raw materials:
Select cost > Where used action > You see all products > Edit value of cost

Or you can import the file attached. ERP code is the erp code of the raw material.
Then upload the file in Repository > Exchange > Import to treat
You will see message in catalina.out or in Repository > Exchange > Logs

Best regards,

RE: cost bulk edit - Added by riccardo bernardi over 6 years ago

Dear Philippe,
thank you for your answer.
It works very well.

Anyway I have another question: are these values stored in the database?

BR
Riccardo

RE: cost bulk edit - Added by Philippe Quéré over 6 years ago

Dear Ricardo,

Yes, theses values are stored in the database.

Regards,

    (1-3/3)