Value change for bulk products

Question

Dear Sagians, 
 We have 2000+ products to change the cost. We need to change the cost only without changing the quantity. Sage have the option for this using Value change under stock module. But this has to run one by one. Is there any way to do this in one shot? 
 
 Regards, 
 Shereef N

Rafael · Answer

Have you seen this KB that discusses what Deb is referring to?

How to update the valuation method of a product and/or multiple products?

Products

Sage X3

Description

A Customer decided to change the valuation method for all products from Average to STD

Resolution

To change for one product: 
 
 Navigate to Common data, Products, Product-sites 
 Cost tab, locate the field Valuation, change it to STD. 
 
 To change for some or all products: 
 
 You will need to use an Import/export template to export all products or a set of products, change the Valuation method in the file and import it back in. 
 This can be done in Usage, Import/exports, Exports, select template ITF 
 
 Note: If there are items in stock, the system will create an adjustment whenever the Average cost is different from the STD cost, as expected. Otherwise you may want to issue out all items (i.e. creating a Misc. issue for all products) PRIOR to changing the Valuation method. Once the Valuation method is changed, you can create a Misc. receipt for all products.

Related resources

Internal: Error:"Modification is not recommended! Stock is present for this product" when Changing the Stock valuation method

Sage X3

Value change for bulk products

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING