RKL eSolutions Blog Trends and Insights

How to Correct the Material Cost in Sage X3

Simulated and/or Revised Cost is not using the correct Material Cost in Sage X3

Are you running Simulated or Revised Cost to update a Finished Good and you want to use Standard Cost for the Material Cost but Sage X3 is using Revised Cost instead of Standard Cost for Material? This blog will walk thru the steps of how to correct the Material Cost in Sage X3.

Ex. Here is the BOM for Finished Good FIN010 – it has one component BMS012

Sage X3 Manufacturing BOM BOMP

Here is the Standard Cost for the component BMS012 – you can see it is $35.97.

Sage X3 Manufacturing Std Cost

Here is the Revised Cost for Component BMS012 – it is $20.00

Sage X3 Manufacturing Revised Costs

Now go to Costing > Cost Calculations > Revised Cost Calculation

Enter the parameters as shown below – note that Standard Cost is chosen for the Material Cost (the Standard Cost for the component was $35.97)

Sage X3 Manufacturing Cost Calculation

However, when the Cost is calculated the Revised Cost was used for the Component (Material) not the Standard Cost that you requested.

Sage X3 Detail Cost Calculations

This is the reason why: on the Product-site record for the Component BMS012 the update method for Revised Cost is ‘Entered’ – it needs to be ‘Calculated’ so the Sage X3 can calculate the Revised Cost.Sage X3 Revised Cost Calc

Change these as shown below and Save.

Sage X3 Updated Cost Calc

Go back to Costing > Cost Calculations > Revised Cost Calculation and run again using Standard Cost for Material Cost

Sage X3 Std Cost-Material Cost

Now Sage X3 is using the Standard Cost for the Material Cost.

Sage X3 Detail Cost Calculations

Be sure to contact us with your questions or for help with Sage X3.
I Need X3 Support »

Tags: Sage X3
RKL Team

Written by RKL Team

Since 2001, RKL eSolutions has helped growing companies maximize their technology resources and investment. Over the years, we have helped hundreds of small and medium sized businesses as their strategic business partner. We specialize in the needs of Entertainment, Software & SaaS, Professional Services, Manufacturing, and Non Profit organizations. Our experienced consultants have a passion for making every facet of your business successful and are intent on building a long-term relationship with every client.