VerifyCoByRatio

Minor Business Rule

Object Name: N3003240

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
This function validates that if the co-/by- product passed in as input exists for another batch
quantity on this process, the ratio of the batch quantity to the quantity per are the same on both
processes. Error message "3939" ("Invalid Co/By Product Ratio") is set if the co-/by- product exists multiple
times on the same process with different ratios.

1.2Setup Notes and Prerequisites
None.

1.3Special Logic
None.

2.Technical Specifications

2.4Processing
1. Calculate the ratio (new) of the Process batch quantity and Co/By output quantity (passed in as
input):

a)Convert the input Process batch quantity (QNTY) to primary unit of measure (i.e. file format)
using the "Convert Batch Quantity" business function.

b)New Ratio = Process batch quantity (QNTY) / Co/By output quantity (BQTY).
c)Round New Ratio to 9 decimals places.

2. Read the Bill of Material Master table (F3002) using Process Item (ITM), Process Branch (CMCU),
Co/By Item (KIT), and Co/By Branch (MMCU) passed in as input.   Process each record retrieved:

a)Skip the record if:    (i.e. Select only co-/by- products).

'b7F3002 Co/By Indicator (COBY) is not a "C" or a "B"

b)Skip the record if:    (i.e. Do not compare the record being changed against itself).

'b7F3002 Line Number (CPNT) is the same as the Line Number (CPNT) passed in as input AND
'b7F3002 Substitute Item Seq No (SBNT) is the same as the Substitute Item Seq No (SBNT)
passed in as input  AND
'b7F3002 Type Bill (TBM) is the same as the Type Bill (TBM) passed in as input  AND
'b7F3002 Process Quantity (QNTY) is the same as the Process Quantity (QNTY) passed in as
input

c)For each selected record, calculate the ratio of the process batch quantity and co/by output
quantity on the retrieved record

'b7Convert the F3002 Process batch quantity (QNTY) to primary unit of measure (i.e. file
format) using the "Convert Batch Quantity" business function.
'b7Old Ratio = F3002 Process batch quantity (QNTY)  /  F3002 Co/By output quantity (BQTY)
'b7Round Old Ratio to 9 decimals places.

d)If the Old Ratio and New Ratio are not equal, set the Error Message Id to "3939" and exit the
program.

Data Structure

D3003240 - Verify CoBy Ratio

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

mnProcessItem ITM MATH_NUMERIC OPT 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

szProcessBranch CMCU char OPT NONE

A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows:
Branch/Plant - (MMCU)       Dept A - (MCU)       Dept B - (MCU)       Job 123 - (MCU)

mnCoByItem KIT MATH_NUMERIC OPT NONE

The system provides for three separate item numbers.    1.   Item Number (short) - An eight-digit, computer assigned, completely
non-significant 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.

szCoByBranch MMCU char OPT 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.

szTypeBill TBM char OPT NONE

A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
For example:    M     Standard manufacturing bill    RWK   Rework bill    SPR   Spare parts bill The system enters bill type M in the work order
header when you create a work order, unless you specify another bill type. The system reads the bill type code on the work order header to
know which bill of material to use to create the work order parts list. MRP uses the bill type code to identify the bill of material to use when it
attaches MRP messages. Batch bills of material must be type M for shop floor management, product costing, and MRP processing.

mnCoByOutputQty BQTY MATH_NUMERIC OPT 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.

szCoByOutputQtyUom UOM char OPT 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).

mnProcessQty QNTY MATH_NUMERIC OPT NONE

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

szProcessQtyUM UM char OPT NONE

A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
cubic meter, liter, hour, and so on.

cCoproductsByproducts COBY char OPT NONE

A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
(concurrent) end items as the result of a process. By-products are items that can be produced at any step of a process, but were not planned.
Intermediate products are items defined as a result of a step but are automatically consumed in the following step. Generally, intermediates are
nonstock items and are only defined steps with a pay-point for reporting purposes. Standard components (Discrete Manufacturing) or ingredients
(Process Manufacturing) are consumed during the production process. Valid values are:    C Co-products    B By-products    I Intermediate
products    Blank Standard components or ingredients

mnSubstituteItemSequenceNu SBNT MATH_NUMERIC OPT NONE

A number that indicates the sequence for the substitute items for a component. The system looks for substitute items by this sequence
number.

cSuppressErrorMsgs EV01 char OPT NONE

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

szErrorMsgId DTAI char OPT 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.

mnComponentLineNumber CPNB MATH_NUMERIC OPT NONE

A number that specifies how the system displays the sequence of components on a single-level bill of material. This number initially
indicates the sequence in which a component was added to the bill of material. You can modify this number to change the sequence in which the
components appear.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnProcessItem	ITM	MATH_NUMERIC	OPT	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
szProcessBranch	CMCU	char	OPT	NONE
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows: Branch/Plant - (MMCU) Dept A - (MCU) Dept B - (MCU) Job 123 - (MCU)
mnCoByItem	KIT	MATH_NUMERIC	OPT	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant 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.
szCoByBranch	MMCU	char	OPT	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.
szTypeBill	TBM	char	OPT	NONE
A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses. For example: M Standard manufacturing bill RWK Rework bill SPR Spare parts bill The system enters bill type M in the work order header when you create a work order, unless you specify another bill type. The system reads the bill type code on the work order header to know which bill of material to use to create the work order parts list. MRP uses the bill type code to identify the bill of material to use when it attaches MRP messages. Batch bills of material must be type M for shop floor management, product costing, and MRP processing.
mnCoByOutputQty	BQTY	MATH_NUMERIC	OPT	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.
szCoByOutputQtyUom	UOM	char	OPT	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).
mnProcessQty	QNTY	MATH_NUMERIC	OPT	NONE
The number of units that the system applies to the transaction.
szProcessQtyUM	UM	char	OPT	NONE
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box, cubic meter, liter, hour, and so on.
cCoproductsByproducts	COBY	char	OPT	NONE
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are (concurrent) end items as the result of a process. By-products are items that can be produced at any step of a process, but were not planned. Intermediate products are items defined as a result of a step but are automatically consumed in the following step. Generally, intermediates are nonstock items and are only defined steps with a pay-point for reporting purposes. Standard components (Discrete Manufacturing) or ingredients (Process Manufacturing) are consumed during the production process. Valid values are: C Co-products B By-products I Intermediate products Blank Standard components or ingredients
mnSubstituteItemSequenceNu	SBNT	MATH_NUMERIC	OPT	NONE
A number that indicates the sequence for the substitute items for a component. The system looks for substitute items by this sequence number.
cSuppressErrorMsgs	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMsgId	DTAI	char	OPT	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.
mnComponentLineNumber	CPNB	MATH_NUMERIC	OPT	NONE
A number that specifies how the system displays the sequence of components on a single-level bill of material. This number initially indicates the sequence in which a component was added to the bill of material. You can modify this number to change the sequence in which the components appear.