​Issue:

Advance Labor formulas in Control Out-of-the-Box Product Dataset reworked to more easily and accurately capture labor time and costs.

Datasets Affected:

  • OOB v2.50, v2.51, v2.52, v2.60, v2.61, v2.62, v2.63, v2.64

Products Affected:

  1. Sign Cabinets
  2. Sign Cabinet Quick Quote
  3. Sign Cabinet Kits

Variables Affected:

  1. CC_CabinetProductionMethod
  2. CC_CabinetProductionMethod2
  3. CC_FrameProductionMethod
  4. CC_FrameProductionMethod2

This fix will involve editing each of these variables and replacing the existing consumption formulas with the ones provided here.

Locating and Updating Variables:

  1. In Control, go to Setup | All Pricing Setup
  2. In the column on the left locate the Variables, to the right of the green icon.
  3. Expand Electric and then expand Cabinets
  4. In the list of variables, (the items with the green icons on the left), the first two variables are CC_CabinetProductionMethod and CC_CabinetProductionMethod2. Three variables below you will find CC_FrameProductionMethod and CC_FrameProductionMethod2. These are the four variable that we will be updating.
  5. To Update the variables, do this:
    • Highlight the first variable (in this case, CC_CabinetProductionMethod)
    • In the tool bar on the right select EDIT.
    • Towards the bottom of the screen, locate the Default Part Consumption formula and click on the ellipse (the dots) that appear under the FORMULA column.

  • Replace (copy and paste) the formulas in variables with the ones displayed below.

**WARNING: If you wish to undo changes, please be careful to preserve the original formulas. To do this add a "{" before and a "}" after the original formulas. This will comment out the original text and all you to paste the corrected formulas below it. This is good practice when ever editing formulas in Control.**

**IF YOU HAVE ANY QUESTIONS, CALL THE IMPLEMENTATION DEPT AT CYRIOUS.**

Edit variable CC_CabinetProductionMethod (copy and past formula below) 

(PartUDFByVariableName(CC_CabinetProductionMethod,"APM_One Time Setup Time",0) Minutes In Hours +
(PartUDFByVariableName(CC_CabinetProductionMethod,"APM_Per Piece Setup Time",0) Minutes In Hours) *
(Quantity) + (PartUDFByVariableName(CC_CabinetProductionMethod,"APM_Minutes Per Function",0) Minutes In Hours)
 * ( 4*(CC_SqrCorners + CC_RadiusCornersQty) * Quantity)
   + IF PartUDFByVariableName(CC_CabinetProductionMethod2,"APM_Length Per Minute",0) > 0 Then
   ((Quantity * (ImageHeight + ImageWidth) In UnitLengthSmall *2 )
   / PartUDFByVariableName(CC_CabinetProductionMethod,"APM_Length Per Minute",1) ) Minutes
   Else 0 Endif In Hours)

Edit variable CC_CabinetProductionMethod2 (copy and past formula below) 

(PartUDFByVariableName(CC_CabinetProductionMethod2,"APM_One Time Setup Time",0) Minutes In Hours +
(PartUDFByVariableName(CC_CabinetProductionMethod2,"APM_Per Piece Setup Time",0) Minutes In Hours) *
(Quantity) + (PartUDFByVariableName(CC_CabinetProductionMethod2,"APM_Minutes Per Function",0) Minutes In Hours)
  * ( 4*(CC_SqrCorners + CC_RadiusCornersQty) * Quantity)
+ IF PartUDFByVariableName(CC_CabinetProductionMethod2,"APM_Length Per Minute",0) > 0 Then
((Quantity * (ImageHeight + ImageWidth) In UnitLengthSmall *2 )
/ PartUDFByVariableName(CC_CabinetProductionMethod2,"APM_Length Per Minute",1) ) Minutes
Else 0 Endif In Hours)

Edit variable CC_FrameProductionMethod (copy and past formula below) 

(PartUDFByVariableName(CC_FrameProductionMethod,"APM_One Time Setup Time",0) Minutes In Hours
+ (PartUDFByVariableName(CC_FrameProductionMethod,"APM_Per Piece Setup Time",0) Minutes In Hours)
  * (Quantity) + (PartUDFByVariableName(CC_FrameProductionMethod,"APM_Minutes Per Function",0) Minutes In Hours)
  * ( CC_FrameConnections * Quantity) + IF PartUDFByVariableName(CC_FrameProductionMethod,"APM_Length Per Minute",0) > 0 Then
((CC_FrameConnections * 2 UnitLengthSmall ) /PartUDFByVariableName(CL_ProductionMethod,"APM_Length Per Minute",1) )
Else 0 Endif In Hours)

Edit variable CC_FrameProductionMethod2 (copy and past formula below) 

(PartUDFByVariableName(CC_FrameProductionMethod2,"APM_One Time Setup Time",0) Minutes In Hours
+ (PartUDFByVariableName(CC_FrameProductionMethod2,"APM_Per Piece Setup Time",0) Minutes In Hours)
  * (Quantity) + (PartUDFByVariableName(CC_FrameProductionMethod2,"APM_Minutes Per Function",0) Minutes In Hours)
  * ( CC_FrameConnections * Quantity) + IF PartUDFByVariableName(CC_FrameProductionMethod2,"APM_Length Per Minute",0) > 0 Then
((CC_FrameConnections * 2 UnitLengthSmall ) / PartUDFByVariableName(CC_FrameProductionMethod2,"APM_Length Per Minute",1) )
Else 0 Endif In Hours)
You could leave a comment if you were logged in.