CalculateOutsideOperations

Calculate Outside Operation

Major Business Rule

Object Name: B3000640

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
The purpose of this function is to calculate the Routing Costs for outside operations.  The Cost
Bucket (the first description in UDC table 30/CO for the Cost Type), Outside Opertion Cost, Unit Cost, and
Outside Operation Description are returned.   Using the values sent in, this function will retrieve
the Unit Costs from F4105.  From the Unit Cost and other information about the item, the Outside
Operation Cost will be calculated.

1.2Setup Notes and Prerequisites
The following are setup issues that should be resolved before calling this function:

• Determine if an intermediate item exists for the operation.
• Determine the Primary Item Number (short, 2nd item, or 3rd Item).  The primary Item number should be
passed in.
• If Cost Level for the item is at Item Location, a F41021 record must exist for this Item and Branch.

1.3Special Logic
This function contains no special logic

2.Technical Specifications

2.4Processing

1.  Retrieve Cost Bucket from DRDL01 in UDC table and return in EV01.

2.  Take LITM and attach '*OP' to the end.  Take OPSQ  and remove decimal zeros and leading
zeros and add to the end.  Check to see if record exists in F4101 for this item number.
3.  Retrieve IMCLEV (Item Cost Level).  If equal to '3' get Location and Lot from Primary Bin
in F41021.

4.  Retrieve COUNCS from F4105 with key as follows:
If IMCLEV = 1use  COITM

If IMCLEV = 2use  COITM
       COMCU

If IMCLEV = 3use  COITM
       COMCU
       COLOCN
       COLOTN
       COLEDG

Outside Operation Cost = F4105 COUNCS.

5.  If CPYP NE zero and NE 10000 and COUNCS NE zeros, inflate costs for Operation Yield
Percent.

Outside Operation Costs = Outside Operation Cost / (CPYP / 100)

6. If an Intermediate Items exists(EV02 = '1'), multipy the Outside Operation cost by the
Intermediate Qty/Batch Quantity ratio.

Outside Operation Cost = Outside Operation Cost * (Intermediate Qty / Batch Qty)

7.  Multiply by TRQT and return this value in B1EV1.

Outside Operation Cost = Outside Operation Cost * DS TRQT

Data Structure

D3000640 - Calculate Outside Operations

Parameter Name Data Item Data Type Req/Opt I/O/Both

szCostComponent 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.

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.

mnOperationsSequenceNo OPSQ MATH_NUMERIC NONE NONE

A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the
manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering
change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin
the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13.

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.

szCostMethod LEDG char NONE NONE

A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
use.

mnScrapPercent CPYP MATH_NUMERIC NONE NONE

The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the
components at that operation step. This enables the MRP system to use the operation step scrap percent along with the existing component scrap
percent to plan component demand.

mnRequestedQuantity 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).

cIntermediateItem EV02 char NONE NONE

An option that specifies the type of processing for an event.

mnRequiredQuantity QNTY MATH_NUMERIC NONE NONE

The number of units that the system applies to the transaction.

cCostBucket EV01 char NONE NONE

An option that specifies the type of processing for an event.

mnOutsideOperationCost B1EV1 MATH_NUMERIC NONE NONE

Work Amount field for the Manufacturing System.

mnBatchQuantity BQTY MATH_NUMERIC NONE NONE

The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
based on the amount of finished goods produced. For example, 1 ounce of solvent is required per unit up to 100 units of finished product.
However, if 200 units of finished product is produced, 2 ounces of solvent are required per finished unit. In this example, you would set up batch
quantities for 100 and 200 units of finished product, specifying the proper amount of solvent per unit.

szErrorMessageID 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.

cSuppressErrorMessages EV01 char NONE NONE

An option that specifies the type of processing for an event.

mnUnitCost UNCS MATH_NUMERIC NONE NONE

The amount per unit, derived by dividing the total cost by the unit quantity.

szOutsideOpDesc DSC1 char NONE NONE

Brief information about an item; a remark or an explanation.

szParentCostMethod LEDG char OPT NONE

A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
use.

Related Functions

B3000390 Calculate Optional Add on Computations

B9800420 Get Data Dictionary Definition

Related Tables

F0005 User Defined Codes

F30026 Item Cost Component Add-Ons

F41001 Inventory Constants

F4101 Item Master

F41021 Item Location File

F4105 Item Cost File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCostComponent	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.
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.
mnOperationsSequenceNo	OPSQ	MATH_NUMERIC	NONE	NONE
A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps 12 and 13.
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.
szCostMethod	LEDG	char	NONE	NONE
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards use.
mnScrapPercent	CPYP	MATH_NUMERIC	NONE	NONE
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the components at that operation step. This enables the MRP system to use the operation step scrap percent along with the existing component scrap percent to plan component demand.
mnRequestedQuantity	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).
cIntermediateItem	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
mnRequiredQuantity	QNTY	MATH_NUMERIC	NONE	NONE
The number of units that the system applies to the transaction.
cCostBucket	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnOutsideOperationCost	B1EV1	MATH_NUMERIC	NONE	NONE
Work Amount field for the Manufacturing System.
mnBatchQuantity	BQTY	MATH_NUMERIC	NONE	NONE
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components based on the amount of finished goods produced. For example, 1 ounce of solvent is required per unit up to 100 units of finished product. However, if 200 units of finished product is produced, 2 ounces of solvent are required per finished unit. In this example, you would set up batch quantities for 100 and 200 units of finished product, specifying the proper amount of solvent per unit.
szErrorMessageID	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.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnUnitCost	UNCS	MATH_NUMERIC	NONE	NONE
The amount per unit, derived by dividing the total cost by the unit quantity.
szOutsideOpDesc	DSC1	char	NONE	NONE
Brief information about an item; a remark or an explanation.
szParentCostMethod	LEDG	char	OPT	NONE
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards use.

B3000390 Calculate Optional Add on Computations
B9800420 Get Data Dictionary Definition

F0005 User Defined Codes
F30026 Item Cost Component Add-Ons
F41001 Inventory Constants
F4101 Item Master
F41021 Item Location File
F4105 Item Cost File