How to create 2019 costs in Sage Enterprise Management (formerly Sage X3)

Author:
Categories: ERP, Sage Enterprise Management, Sage X3
December 12, 2018

It’s that time of year! As the new year rolls around, it is time to create your 2019 costs. If you use the Manufacturing Module in Sage Enterprise Management (formerly 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

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

Cost Calculation

  1. Navigate to the Standard Cost Calculation Function (CALCSTSTD) (See Figure 3)
  2. Select your Site
  3. Select All for updating all of your costs for 2019 (See Figure 4)
  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 (2018)
  • 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 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 3 – Sage X3 Cost Calculation


sage-x3-cost-calculation-2

Figure 4 – Sage X3 Cost Calculation