Question

Schedule Calculate Shop Order Costs

  • 2 December 2019
  • 7 replies
  • 225 views

Userlevel 3
Badge +6

Does anyone know if it’s possible to schedule the “Calculate Order Cost” for all Shop Orders on a particular site or can this job only be run manually one shop order at a time?

 

 

Thanks

 


7 replies

Userlevel 1
Badge +3

Hi, Calculate Order Costs, which calculates/recalculates the shop order cost estimate amounts, is calculated automatically when you (1)create anorder or (2) modify an order. When it comes to (2) system recalculates the shop order estimate cost when the shop order status is: Planned, Released, Reserved. You can manually calculate a shop order which is Started.

The logic looks at the components and operations that are connected to the specific Shop Order.

Do you really need to schedule this job?

-Mats

Userlevel 3
Badge +6

We are looking to do some reporting based on Estimated SO Costs.  Our material costs change frequently.  We create our Shop Orders in advance and don’t really modify them. 

So, for example, material cost on SOs created at the beginning of the month may change throughout the month so the estimated cost at the beginning may differ from start of month to end.  

If we are reporting daily or weekly and don’t run the re-calc and don’t modify the SO we’ll not pick up the change in cost.

Scheduling the re-calc would also then mean we could state the reporting was as at ‘x’ period of time (ie when job ran).

Hope that makes sense!

Linda

Userlevel 1
Badge +3

Hi again,

Perhaps you know below already… Anyway here we go:

If estimated level- and accumulated cost per shop order is good enough you can run the “Aggregate Shop Order Costs per Shop Order” job. You can schedule this job. The result is visible in the overview screen Shop Orders Costs, however as I indicated, result is per Shop Order and not per Shop Order AND Cost Bucket level.

-Mats

Userlevel 3
Badge +6

Hi @majose

Thanks for the information.  

Could you clarify?  You seem to indicate the “Aggregate...” job does the same as the RMB/Calculate Order Costs but then say result is not per Shop Order and Cost Bucket.  I’m not sure I follow?

Regards

Linda

Userlevel 1
Badge +3

Aggregate Shop Order Costs per Shop Order job basically uses the same logic as Calculate Order Costs, but result is aggregated per Shop Order, while Calculate Order Costs saves data per Cost Bucket. In above screen the Total Estimated Cost should match with the sum in “Shop Order Costs/Order Cost Estimates” tab, if they are calculated at the same date.

Cheers

-Mats

Userlevel 4
Badge +9

@PRODQ 

If you need the bucket cost. E.g. data from SHOP_ORDER_VARIANCE2 or SHOP_ORDER_COST_BUCKET you have to either open each order in the shop order costs window or run the procedure SHOP_ORDER_COST_UTIL_API.Calc_Shop_Order_Cost_Details from somewhere (someone correct me if i’m wrong).

Attached is an event action that make the calculation when a SO is closed. You can also do it inside a loop of SO’s, but that will require a Database task. 

I am not sure about the unique_user_id_, but someone else might help with that.

 

Userlevel 3
Badge +6

Thanks for the input, folks.  This is turning into a really interesting thread and helping my understanding too.  

Yes, I do need the “Cost Bucket” rather than the “Aggregate” because we’re reporting only against the Material Cost (bucket 110).  

I can certainly move forward with your event action, Hans, with our tech supporter.  Many thanks for sharing.  

Linda

Reply