How to create 2020 costs in Sage X3

Categories: ERP, Sage X3
December 10, 2019

It’s that time of year! As the new year rolls around, it is time to create your 2020 costs. If you use the Manufacturing Module in Sage X3, you must create standard costs for the new year. You may accomplish this in a number of ways. It can be as simple as copying your costs to the new year or you may wish to go through the exercise of recreating new standards from the lowest level on up. Listed below are a couple of quick examples of how to proceed.

Cost Transfer

Figure 1

  • Navigate to the Cost Transfer function (COPYCOUT) (See Figure 1)

Figure 2

  1. Select All
  2. Select the Company and Site you wish to transfer the costs FROM (See Figure 2)
  3. Select the Cost type
  4. Select the Fiscal Year
  5. Select the Company and Site where you wish to transfer the costs TO
  6. Select the Cost type – Standard
  7. Select the New Fiscal Year
  8. Click OK
  9. Sage returns a log file with all of the copied costs

Cost Calculation

Figure 3

  • Navigate to the Standard Cost Calculation Function (CALCSTSTD) (See Figure 3)

Figure 4

  1. Select your Site
  2. Select All for updating all of your costs for 2020 (See Figure 4)
  3. Select the Date – if you create your standard costs ahead of time – you will “future date” this field. If you are running this after the new year – simply accept the default date.
  4. Select the Routing Code – usually Primary or 1
  5. Select the BOM Code – usually Primary or 1
  6. Select the Material Cost you wish to use to update your Standard Material Costs
  • Standard Cost (2019)
  • Revised Standard
  • Budgeted Cost
  • Simulated Cost
  • Last Cost
  • Average Cost
  • Last Purchased Price
  • List Price
  1. Select “Deferred” if you are running this for a future date (see step 3) -or- Select “Immediate” if you wish the costs to be immediately created
  2. Sage returns a Log File with all of the newly calculated costs

Caution: Changing your standard costs may revalue your inventory and only carries forward on new transactions. Existing transactions will carry the old cost.

If you need additional assistance, please use the form on the right to contact us.

Inventory Revaluation

sage x3 costs - inventory revaluation

Figure 5

In order to revalue the inventory after a Cost Transfer or Deferred Cost Calculation, you must run the Standard Cost Adjustment (FUNSMI) function. This function does not appear on your browser menu. However, you may run it as a task.

Navigate to Usage>Batch Server>Query Submission

  1. Enter or Select your Site
  2. Enter the FUNSMI function in the task code field
  3. Enter the date for the function to run.  You must run this task if you selected the Deferred Cost Calculation update or the Cost Transfer.
  4. Enter a time for the task to run
  5. Click Validate.
  6. The query/task will run on the date and time you selected.