WOVarianceCostRollUp

WO Variance Cost Roll Up

Minor Business Rule

Object Name: B3100610

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
Retrieves the WO Variance (F3102) records that match the Index and Key(s) passed in. Accumulates and
returns the calculated Unit Cost (UNCS).

1.2Setup Notes and Prerequisites

• The user passes to the business function the number of the index they want to use and the number of
key fields within that index that will be used.
List of Indexes:
1. DOCO, PART, ITM,COST
2. DOCO, ITM, COST

• The returned error message will display automatically on the message line and the appropriate field
(if any) will be highlighted. This can be suppressed by turning on the "Suppress Error Message" flag.

1.3Special Logic
None.

2.Technical Specifications
2.4Processing
Clear the Unit Cost (UNCS) field.
Fetch the WO Variance (F3102) record corresponding to the Index and Key(s) entered by the user.

If no record was found return the error message.
Assign DS Error Message ID = '0002' (Record Invalid).
If DS Suppress Error Message is not equal to '1' then SetGBRError where error message is '0002'
(record Invalid) and the first field in the Index is highlighted.

If Fetch is successful then do the following:
Read all records matching the Index and Keys passed in.
If a record's Cost Type (COST) is equal to 'A1' then
If a record's Standard Units is not zero then
Divide the record's Standard Amount (OPAT) by the Standard Units (OPUN) and add the result to the
Unit Cost field.

List of Indexes:
1. DOCO, PART, ITM, COST
2. DOCO, ITM, COST

Returns:
The calculated Unit Cost.

^

Data Structure

D3100610 - WO Variance Cost Roll Up

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnDocumentOrderInvoicee	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.
cParentChildRelationship	PART	char	NONE	NONE
An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent records for the address book number entered. Also a field that indicates whether a record is a parent or child. For the field, valid values are: P Parent C Child
mnItemNumber	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
szCostType	COST	char	NONE	NONE
A code that designates each element of cost for an item. Examples of the cost object types are: o A1 Purchased raw material o B1 Direct labor routing rollup o B2 Setup labor routing rollup o C1 Variable burden routing rollup o C2 Fixed burden routing rollup o Dx Outside operation routing rollup o Xx Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The system then associates these cost components with one of six user defined summary cost buckets.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessage	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnAmountUnitCost	UNCS	MATH_NUMERIC	NONE	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
szIndex	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szKeys	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

Related Functions

None

Related Tables

F3102 Production Cost