How to create 2020 costs in Sage X3

[vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ width=”1/1″ tablet_text_alignment=”default” phone_text_alignment=”default”][vc_column_text]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.[/vc_column_text][/vc_column][/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ width=”1/1″ tablet_text_alignment=”default” phone_text_alignment=”default”][vc_column_text]

Cost Transfer

[/vc_column_text][divider line_type=”No Line” custom_height=”15″][vc_row_inner text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][image_with_animation image_url=”9573″ alignment=”” animation=”Fade In” box_shadow=”none” max_width=”100%”][vc_column_text]Figure 1[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][vc_column_text]

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

[/vc_column_text][/vc_column_inner][/vc_row_inner][divider line_type=”No Line” custom_height=”15″][vc_row_inner text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][image_with_animation image_url=”9574″ alignment=”” animation=”Fade In” box_shadow=”none” max_width=”100%”][vc_column_text]Figure 2[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][vc_column_text]

  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

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” scene_position=”center” text_color=”dark” text_align=”left” overlay_strength=”0.3″][vc_column column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ background_hover_color_opacity=”1″ width=”1/1″ tablet_text_alignment=”default” phone_text_alignment=”default”][vc_column_text]

Cost Calculation

[/vc_column_text][divider line_type=”No Line” custom_height=”15″][vc_row_inner text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][image_with_animation image_url=”9571″ alignment=”” animation=”Fade In” box_shadow=”none” max_width=”100%”][vc_column_text]Figure 3[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][vc_column_text]

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

[/vc_column_text][/vc_column_inner][/vc_row_inner][divider line_type=”No Line” custom_height=”15″][vc_row_inner text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][image_with_animation image_url=”9572″ alignment=”” animation=”Fade In” box_shadow=”none” max_width=”100%”][vc_column_text]Figure 4[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][vc_column_text]

  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

[/vc_column_text][/vc_column_inner][/vc_row_inner][divider line_type=”No Line” custom_height=”15″][vc_column_text]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.[/vc_column_text][divider line_type=”No Line” custom_height=”15″][vc_column_text]

Inventory Revaluation

[/vc_column_text][divider line_type=”No Line” custom_height=”15″][vc_row_inner text_align=”left”][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][image_with_animation image_url=”9692″ alignment=”” animation=”Fade In” box_shadow=”none” max_width=”100%”][vc_column_text]Figure 5[/vc_column_text][/vc_column_inner][vc_column_inner column_padding=”no-extra-padding” column_padding_position=”all” background_color_opacity=”1″ width=”1/2″][vc_column_text]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.

[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]

Scroll to Top