UpdateWOStdCostVar

Update WO Standard Cost Variance

Minor Business Rule

Object Name: B3100430

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This business function will create/update the Standard Cost Variances in the WO Variance table
(F3102) for a given Work Order.

1.2Setup Notes and Prerequisites

• None.

1.3Special Logic
None.

2.Technical Specifications
2.4Processing
The following actions have to be performed by the Business Function.
1. Set the Work fields TSTDC, TCSL, ASTDC equal to zeros.
2. Load ITM, MMCU, LOCN(=Blanks), LOTN(=Blanks) and  LEDG(='07') into the keys for reading the Cost
Component table (F30026).
3.  Do Until there are no more records,
Read a row from the F30026 table using the above partial keys.
If row found
TSTDC = TSTDC + IESTDC
TCSL    = TCSL + IECSL
If IECOST = 'A1'
ASTDC = IESTDC.
Else
If IECOST = 'B2'
Work OPAT = IESTC * ACQ
Else
Work OPAT = IESTDC * TRQT
End
Read F3102 table using Input DOCO,ITM and COST (=IECOST) as the key
If row found
IGOPAT = Work OPAT
IGOPUN = Input UORG
Update F3102 row
Else
IGPART = 'P'
IGDOCO = Input DOCO
IGITM  = Input ITM
IGLITM = Input LITM
IGAITM = Input AITM
IGUOM = Input UOM
IGCOST = IECOST
IGOPAT = Work OPAT
IGOPUN = Input UORG
Load Audit information
Write F3102 row.
Endif
Endif
Endif
Enddo.
4. If TCSL is <> zeros
Work OPAT = TSTDC - TCSL
If ASTDC <> zeros
Work OPAT = Work OPAT + ASTDC
Endif
Work OPAT = Work OPAT * TRQT
Read F3102 table using Input DOCO,ITM and COST (= 'A1') as the key
If row found
IGOPAT = Work OPAT
IGOPUN = Input UORG
Update F3102 row
Else
IGPART = 'P'
IGDOCO = Input DOCO
IGITM  = Input ITM
IGLITM = Input LITM
IGAITM = Input AITM
IGUOM = Input UOM
IGCOST = 'A1'
IGOPAT = Work OPAT
IGOPUN = Input UORG
Load Audit information
Write F3102 row.
Endif
Endif

If  any errors occur,  the function will return '1' in the Error Code field, and '0' if there are no
errors.

^

Data Structure

D3100430 - Update WO Standard Cost Variance

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnDocumentNumber	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, and so on.
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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
sz2ndItemNumber	LITM	char	NONE	NONE
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A 25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
sz3rdItemNumber	AITM	char	NONE	NONE
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item numbers are as follows: 1. Item Number (short) - An 8-digit, computer-assigned item number. 2. 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number. In addition to these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
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 represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
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 backorders. You enter this value in the Branch/Plant Constants program (P41001).
mnOrderQuantity	UORG	MATH_NUMERIC	NONE	NONE
The quantity of units affected by this transaction.
mnAccountingCostQuantity	ACQ	MATH_NUMERIC	NONE	NONE
An amount that the system uses in the Cost Rollup program to determine the allocation of setup costs. The system totals the setup costs and divides the sum by this quantity to determine a unit setup cost. The default is 1.
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 Set Server program (XT4914).

Related Functions

B9800100 Get Audit Information

Related Tables

F30026 Item Cost Component Add-Ons
F3102 Production Cost