UpdateCostRollupRouting

Update Cost Rollup Routing

Major Business Rule

Object Name: B3000880

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
The UpdateF30026CostSimulation business function updates all standard routing cost records and
routing outside operation cost records in the Item Cost Component Add-ons Table (F30026).  If the Item Cost
Component Add-on record does not exist, the record will be added.  If the Item Cost Component Add-on
record exists, the cost passed in the BF data structure will be accumulated to the cost in the existing
record.

1.2Setup Notes and Prerequisites
• B3001660 - loads a link list with the outside operation costs.
• B3001670 - calculates the Parent Cost Percent.
• Determine if the parent item is a Process or not prior to calling this business function.
• Processing Options determine:
• •

Outside Operation Cost Method.
• whether or not CoByProducts are rolled up.
•

1.3Special Logic

2.Technical Specifications

2.4Processing

1.0. Process all standard costs (B1, B2, B3, B4, C1, C2, C3, C4).  Then if the DS Outside
OperationPointer is not equal to NULL, read through OutsideOperation Linked list processing all Outside
Operation Costs.
      Set WK CostType = B1, B2, B3, B4, C1, C2, C3, C4, or Cost Type from
Outside Operation Linked list.

1.1.  Fetch the Item Cost Component Add-on record.
Index:   ID_F30026_ITEMNUMBER_BRANCH___A.
where:  ITM=DS Item, MMCU=DS Branch, LOCN=DS Location, LOTN=DS Lot, LEDG=DS CostMethod, COST=
WK cost type.

1.2.  Retrieve date, time, userid, and workstation ID using BF GetAuditInfo.

1.3.  Move Cost to a work field.
If WK CostType is equal to 'B1', assign WK Cost =  DS B1DirectLabor.
If WK CostType is equal to 'B2', assign  WK Cost =  DS B2SetupLabor.
If WK CostType is equal to 'B3', assign WK Cost = DS B3MachineRun.
IF WK CostType is equal to 'B4', assign WK Cost =  DS B4LaborEfficiency.
If WK CostType is equal to 'C1', assign WK Cost = DS C1MachineVariableOH.
If WK CostType is equal to 'C2', assign WK Cost = DS C2MachineFixedOH.
If WK CostType is equal to 'C3', assign WK Cost = DS C3LaborVariableOH.
IF WK CostType is equal to 'C4', assign WK Cost = DS C4LaborFixedOH.
If ProcessingOutsideOperation, assign  WK Cos t  = LL OutsideOperationCost.

1.3.  If DS RollCoByProducts = '1', and DS ProcessItem = '1', and WK Cost not equal to zero, and
DS ParentCostPercent ne 1, WK Cost = WK Cost * DS ParentCostPercent.

1.3.  If the record exists, update existing record.
1.3.1.  Accumulate the cost in XSMC Amount Mfg Simulated.
F30026 XSMC = F30026 XSMC + WK Cost.

1.3.2  Update the Workstation, Userid, Time, Date, and Program ID.

1.4. If the record does not exist, add the record to the Item Cost Component Add-on Table.
1.4.1.  Initialize.
1.4.2.  Move the Item Number, Branch, Location, Lot, Cost Method, 2nd Item Number, 3rd Item
Number, and Program ID from the data structure.
1.4.3.  Assign F30026 XSMC = WK Cost.
1.4.4.  Move the Workstation, Userid, Time, and date.
1.4.5.  Move WK Cost Type to COST.

Data Structure

D3000880 - Update Cost Rollup Routing

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

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

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.

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

szLot LOT char NONE NONE

A lot is a quantity of items that you want to group together because they have similar characteristics.

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.

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.

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.

mnB1DirectLabor XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnB2SetupLabor XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnB3MachineRun XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnB4LaborEfficiency XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnC1MachineVariableOH XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnC2MachineFixedOH XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnC3LaborVariableOH XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnC4LaborFixedOH XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

cSuppressErrorMessages EV01 char NONE NONE

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

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.

szProgramID PID char NONE NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

idOutsideOperPointer GENLNG ID NONE NONE

General purpose ID variable.

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

cProcessItem EV01 char NONE NONE

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

cRollCoByProducts EV01 char NONE NONE

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

mnParentCostPercent F$RP MATH_NUMERIC NONE NONE

A percentage that the Simulate Cost Rollup program uses to calculate the cost of a feature or option item as a percentage of the total cost
of the parent. Enter the percentage as a whole number, for example, enter 5% as 5.0.

Related Functions

B3001660 Costing Process Outside Operation

B9800100 Get Audit Information

Related Tables

F30026 Item Cost Component Add-Ons

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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
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.
szLocation	LOCN	char	NONE	NONE
The storage location from which goods will be moved.
szLot	LOT	char	NONE	NONE
A lot is a quantity of items that you want to group together because they have similar characteristics.
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.
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.
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.
mnB1DirectLabor	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnB2SetupLabor	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnB3MachineRun	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnB4LaborEfficiency	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnC1MachineVariableOH	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnC2MachineFixedOH	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnC3LaborVariableOH	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnC4LaborFixedOH	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
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.
szProgramID	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
idOutsideOperPointer	GENLNG	ID	NONE	NONE
General purpose ID variable.
szOutsideOperCostMethod	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.
cProcessItem	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cRollCoByProducts	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnParentCostPercent	F$RP	MATH_NUMERIC	NONE	NONE
A percentage that the Simulate Cost Rollup program uses to calculate the cost of a feature or option item as a percentage of the total cost of the parent. Enter the percentage as a whole number, for example, enter 5% as 5.0.

B3001660 Costing Process Outside Operation
B9800100 Get Audit Information