Question

Update the shop cost - Standard Cost

  • 20 June 2022
  • 4 replies
  • 332 views
A
Rank
Userlevel 3
Badge +7

Hi, 

We are using manufacturing modules with configured parts. 

The setup for the inventory parts : 

  • Weighted average for the purchased parts
  • Standard cost, per configuration for manufactured parts

At the creation of the shop order, the standard cost is calculated using the structure information.

I have a question regarding the standard cost update :

  • We may have a time lap between the shop order creation and the shop order process. So if the components parts costs are updated (eg.: variance of the purchased price)
  • I would like to update the standard cost and include the component parts costs, into the inventory value.

I have already setup a migration job, to update the shop order costs. But this migration job, doesn’t update the standard cost.

Do you have any inputs regarding the automatic update the shop order standard cost, through the shop order cycle ?

Thanks, 

Tarek

4 replies

D
Rank
Userlevel 4
Badge +9

For Cost per Configuration Parts, the option “Save Standard Cost” updates the Standard Cost for the Configuration.

You can execute that function from the Shop Order costs to update the Standard Cost based on the calculated Shop Order Estimated Cost for the configuration.

 

A
Rank
Userlevel 3
Badge +7

Hi @dameenda, 

Thanks for your answer. That procedure is going to update each shop order individually.

Is there a way to automatically update all the standard cost of all the open shop orders, using a migration job similar to the one suggested above ? The idea would be to calculate the standard cost and then update the estimate cost, at a regular basis.

I tried here, but i have this error message.

Thanks

D
Rank
Userlevel 4
Badge +9

Hi Tarek;

The Standard Cost per configuration is specific for a Part and a Configuration.

Using Calculate Shop Order Cost and then save Standard Cost helps to update the Shop Order Costs of the selected Shop Order and updating the Standard Cost for the Part and Configuration.

If the goal is to update all the latest costs for configurations then using the Shop Order Costs may not be that standard as a shop order can have manual modifications for material; and operations.

One effective way is to have interim Headers created for all the Parts and Configurations in the system,

then after Standard Costs have been updated through cost calculations,

It is possible to Search for them (Parts and Configurations) in the Interim Order Costs and Select them and RMB select Calculate Interim Order Costs

This will update the Costs for each configuration based on the corresponding Structures and Routings.

Then it is possible to select all the parts and RMB Select Save Standard Cost

This will update the Standard Costs for all the selected  Parts and Configurations.

So the steps at the first time would be;

  1. Calculate and update Standard Cost from Costing
  2. Create interim Demand Headers for all the Configurable Parts and Configurations
  3. Evaluate Rules in the Interim demand Headers created in 2. above
  4. Calculate Interim Order Costs by selecting all the Interim Headers created in the step 2, above.
  5. Perform Save Standard Cost for all the Interim Headers selected in 4. above

next time the Steps would be 

  1. Calculate Interim Order Costs by selecting all the Interim Headers in Interim Order Costs
  2. Perform Save Standard Cost for all the Interim Headers selected in 6. above

Since Interim Orders are used for Simulations mostly, they can be reused without effecting real orders, demands and loads.

Vernon Anderson
Rank
Userlevel 3
Badge +8

Hi Tarek;

The Standard Cost per configuration is specific for a Part and a Configuration.

Using Calculate Shop Order Cost and then save Standard Cost helps to update the Shop Order Costs of the selected Shop Order and updating the Standard Cost for the Part and Configuration.

If the goal is to update all the latest costs for configurations then using the Shop Order Costs may not be that standard as a shop order can have manual modifications for material; and operations.

One effective way is to have interim Headers created for all the Parts and Configurations in the system,

then after Standard Costs have been updated through cost calculations,

It is possible to Search for them (Parts and Configurations) in the Interim Order Costs and Select them and RMB select Calculate Interim Order Costs

This will update the Costs for each configuration based on the corresponding Structures and Routings.

Then it is possible to select all the parts and RMB Select Save Standard Cost

This will update the Standard Costs for all the selected  Parts and Configurations.

So the steps at the first time would be;

  1. Calculate and update Standard Cost from Costing
  2. Create interim Demand Headers for all the Configurable Parts and Configurations
  3. Evaluate Rules in the Interim demand Headers created in 2. above
  4. Calculate Interim Order Costs by selecting all the Interim Headers created in the step 2, above.
  5. Perform Save Standard Cost for all the Interim Headers selected in 4. above

next time the Steps would be 

  1. Calculate Interim Order Costs by selecting all the Interim Headers in Interim Order Costs
  2. Perform Save Standard Cost for all the Interim Headers selected in 6. above

Since Interim Orders are used for Simulations mostly, they can be reused without effecting real orders, demands and loads.

your step 2 “Create interim Demand Headers for all the Configurable Parts and Configurations”, how do you suggest that be done??

 

Thanks

Vernon

Reply


Terms & ConditionsCookie settings