Hello,
Which are the best way to update the item base price by statistical group family?
We would like to increase all the products from a specific statistical group family by 5%.
Thanks.
Best regards,
Daniel
Hello,
Which are the best way to update the item base price by statistical group family?
We would like to increase all the products from a specific statistical group family by 5%.
Thanks.
Best regards,
Daniel
Disclaimer. This method will bypass all the system checks for validity of data. Otoh for this, i'm not sure it matters. You can use database mass update. This method is however, fraught with peril, if you mess up. Here is an example of a fixed cost change. The client accidentally enterred these and asked me to zero them.
Hi Stephen,
Thank you, for your reply.
I was looking for a more standard solution inside X3 but this can be useful.
How did you made this?
Thanks.
Best regards,
Daniel
>>more standard solution inside X3 but this can be useful.
There is a price update definition in Sales to update pricing tables but this is not in a pricing table.
>>How did you made this?
All>Development>Script dictionary>update Transactions
It's well hidden . Don't want folks messing with the data.
Hi Stephen,
Thanks, your solution worked like a charm!
I was looking for "Price Update function" I didn't know that SAGE had changed the function name to "Update Transactions".
Thanks a lot.
Best regards,
Daniel
>>I was looking for "Price Update function" ..changed the function name to "Update Transactions"
It's not just for updating pricing as you can write all kinds of little routines. The issue is that it bypasses all integrity checks so you need to be careful using it.
*Community Hub is the new name for Sage City