1.Functional Description
1.1Purpose
This business function will create/update the Standard Cost Variances in the WO Variance table
(F3102) for configured parts for a given Work Order.
1.2Setup Notes and Prerequisites
None.
1.3Special Logic
None.
2.Technical Specifications
2.4Processing
The following actions will be performed by the Business Function.
If the Standard Cost Calculation Method (input) is equal to '2'
Do until there are no more records,
If the row is found,
/* 'D' added as a valid Cost Type. 4/14/97. */
If COST='B' or 'C' or 'D'
Initialize the following work fields to zero: CTSvohm, CTSvohl, CTSfohm, CTSfohl, CTS1, CTS2,
CTS3, CTS4, CTS5, CTS6, VOHM, FOHM, VOHL, FOHL, EFFH, WCEF, AMT, HRS.
Load DOCO into the key for reading the SFC Routing Instructions table (F3112).
Do until there are no more records,
If WLVEND <> 0,
Item and Branch/Plant, using F4101 Get Primary Item Number(X4101).
If the Short Item Number is primary, remove the leading blanks.
Truncate the Primary Item Number to a length of twenty.
Concatenate the string, "*OP" to the Item Number.
Convert the Operations Sequence Number (WLOPSQ) to a left-justified string and
concatenate the result to the Item Number.
Use Get Item Master Description UoM (B4001040) to validate the outside operation Item
Number (wf-LITM) and return the Cost Level (IMCLEV).
Call F4105 Get Item Cost (XF4105) to retrieve the Unit Cost (COUNCS).
Load the audit information.
Read the variance file (F3102) by DOCO, ITM, and Cost ('D1').
If a record is found,
IGDOCO = ds-DOCO
IGITM = ds-ITM
IGLITM = ds-LITM
IGAITM = ds-AITM
IGCOST = 'D1'
Write a new F3102 row
/* End new processing for outside operations. */
If WLMCU<>IWMCU,
IWLEDG='07'
Read a row in the Work Center Rates table (F30008) by IWMCU and IWLEDG
Calculate efficiency variance: WORE = WLWORE / 100.
If a record is found in the Work Center Rates table (F30008),
CTS3=CTS3+WLRUNM
ASETL = IWSTFF * WLSETL
CTS5 = CTS5+ASETL
CTS6 = CTS6+ARUNM
(B4 Efficiency Cost) WCEF=IWSTLF * EFFH
WCEF is rounded to the 4th decimal position
Accumulate WCEF into CTSwcef
Accumulate VOHM into CTSvohm
Accumulate FOEM into CTSfohm
Calculate C3, Variable Labor Overhead
If IVO (input) = 'Y'
WKAT=0
Run Labor is used in overhead calculation
If CVDL (input) = 'Y'
WKAT = WKAT + ARUNL (Cost)
Setup Labor is used in overhead calculation
If CVSL (input) = 'Y'
WKAT = WKAT + ASETL (Cost)
Efficiency is included in overhead calculation
If CVDS (input) = 'Y'
WKAT = WKAT + WCEF (Add efficiency cost from the B4 calculation)
When overhead is expressed as percentages of labor cost
VOHL is accumulated into CTSvohl
Calculate C4, Fixed Labor Overhead
If FVO (input) = 'Y'
WKAT=0
Run Labor is used in overhead calculation
If CFDL (input) = 'Y'
WKAT = WKAT + ARUNL (Cost)
Setup Labor is used in overhead calculation
If CFSL (input) = 'Y'
WKAT = WKAT + ASETL (Cost)
Efficiency is included in overhead calculation
If CVDS (input) = 'Y'
WKAT = WKAT + WCEF (Add efficiency cost from the B4 calculation)
When overhead is expressed as percentages of labor cost
FOHL is accumulated into CTSfohl
Build a string array for the following cost types: 'B1 ', 'B2 , 'B3 ', 'B4 ', 'C1 ', 'C2 ',
'C3 ', 'C4 '
IECOST = aryszCOST[current cost type]
IGOPUN=UORG (input)
If IECOST = 'B1 '
If IECOST = 'B2 '
If IECOST = 'B3 '
If IECOST = 'B4 '
If IECOST = 'C1 '
If IECOST = 'C2 '
If IECOST = 'C3 '
If IECOST = 'C4 '
/* NOTE: The following logic was added 10/13/96 for Configurator */
Add IGOPAT to Total Standard Cost field (OPAT); this accumulated value will be passed
back to the calling program.
Load audit information with PID = "ER31410"
If a row (F3102) was found
IGDOCO=Input DOCO
IGITM=Input ITM
IGLITM=Input LITM
IGAITM=Input AITM
IGCOST=IECOST
Write a new row if IGOPAT is not zero
COST>'C4 '
If row found,
IGOPUN=TRQT/WO Conversion factor (input)
IGUOM=UOM (input)
/* NOTE: The following logic was added 10/13/96 for Configurator */
Add IGOPAT to Total Standard Cost field (OPAT); this accumulated value will be passed
back to the calling program.
Load audit information
Read the variance file (F3102) using DOCO, ITM, and COST (=IECOST) as keys
If a record is found
IGDOCO=Input DOCO
IGITM=Input ITM
IGLITM=Input LITM
IGAITM=Input AITM
IGCOST=IECOST
Write a new row
If any errors occur, the function will return '1' in the Error Code field, and '0' if there are no
errors.
^
D3100840 - Update WO Standard Cost Variance for Configured Parts
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szSecondItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szBranch | MMCU | char | NONE | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
szUnitofMeasure | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnPrimaryOrderQty | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnOrderQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
cStandardCalculationMethod | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cModifyCostbyWorkCenterEff | MWCE | char | NONE | NONE |
An option that determines whether the cost rollup creates cost component B4 (for labor efficiency) based on the direct labor value (cost
| ||||
cIncVarMachOverheadInCost | IVMO | char | NONE | NONE |
An option that determines whether the cost rollup creates cost component C1 (for variable machine overhead) in the Cost Components
| ||||
cOverheadAsPerOrRates | PORR | char | NONE | NONE |
An option that determines whether values for overhead fields (cost components C1 through C4) in the Work Center Rates table (F30008) are
| ||||
cIncFixMachOverheadInCost | IFMO | char | NONE | NONE |
An option that determines whether the cost rollup creates cost component C2 (for fixed machine overhead) in the Item Cost Component
| ||||
cIncVarLabor | IVO | char | NONE | NONE |
An option that determines whether the cost rollup creates cost component C3 (for variable labor overhead) in the Item Cost Component
| ||||
cCalcVarOnDirectLabor | CVDL | char | NONE | NONE |
An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate variable
| ||||
cCalcVarOnSetupLabor | CVSL | char | NONE | NONE |
An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate variable
| ||||
cIncWorkCenterEff | CVDS | char | NONE | NONE |
An option that determines whether the cost rollup includes work center efficiency when calculating overhead values, if you specified that
| ||||
cIncFixedLaborOverInCost | IFO | char | NONE | NONE |
An option that determines whether the cost rollup creates cost component C4 (for fixed labor overhead) in the Item Cost Component
| ||||
cCalcFixOrDirectLabor | CFDL | char | NONE | NONE |
An option that determines whether the cost rollup includes direct labor expenses (cost component B1) in the total used to calculate fixed
| ||||
cCalcFixOnSetup | CFSL | char | NONE | NONE |
An option that determines whether the cost rollup includes setup labor expenses (cost component B2) in the total used to calculate fixed
| ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
mnConversionFactor | MN29D9 | MATH_NUMERIC | NONE | NONE |
This is a generic field used as a work field in Everest. | ||||
mnStandardamount | OPAT | MATH_NUMERIC | NONE | NONE |
The standard amount to produce a given amount of product. |
B9800100 Get Audit Information |
F30006 Work Center Master File | ||||
F30008 Work Center Rates File | ||||
F30026 Item Cost Component Add-Ons | ||||
F3102 Production Cost | ||||
F3112 Work Order Routing |