How to create 2017 costs in Sage X3

Author:
Categories: ERP, Sage X3
December 23, 2016

It’s that time of year! As the new year rolls around, it is time to create your 2017 costs. If you use X3’s manufacturing module, 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

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

Cost Calculation

  1. Navigate to the Standard Cost Calculation Function (CALCSTSTD)
  2. Select your Site
  3. Select All for updating all of your costs for 2017
  4. 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.
  5. Select the Routing Code – usually Primary or 1
  6. Select the BOM Code – usually Primary or 1
  7. Select the Material Cost you wish to use to update your Standard Material Costs.
  • Standard Cost (2016)
  • 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” is you wish the costs to be immediately created.
  2. Sage X3 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 existing transactions. Existing transactions will carry the old cost.

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

sage-x3-cost-transfer-1

Figure 1 – Sage X3 Cost Transfer


sage-x3-cost-transfer-2

Figure 2 – Sage X3 Cost Transfer


sage-x3-cost-calculation-1

Figure 1 – Sage X3 Cost Calculation


sage-x3-cost-calculation-2

Figure 2 – Sage X3 Cost Calculation