MRPWriteSupplyQuantitiesFromPL

MRP, Write Supply Quantities from Parts List

Minor Business Rule

Object Name: B3500010

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function should ONLY be used by R3483. It will read F3411 records by Item and Supply
Branch(MMMMCU), calculate the Other Branch Demand quantity and write the quantity to the Quantities Cache.

1.2Setup Notes and Prerequisites

1.3Special Logic

2.Technical Specifications
1.Open F3411 using two request handles - first is for selecting and reading, the second for
deleting..
2.Select Records from F3411 using MMITM=Input Item, MMMMCU=Input Branch and MMDRQJ <= Input End
Date. (Use Index 7 to select)
3.Wk Exit Flag = '0'
4.While Wk Exit Flag <> '1'
5. Fetch from F3411
6. If Fetch Failed then
7. Exit While Loop
8. End If
9. If MMSTRT = 0 then
10. Continue
11. End If
12. Call B3401290 in mode '1' to fetch cache record using Input Branch, 'ID', and
MMSTRT.
13. If Cache Code Error = '0'
14. Add MMTRQT to quantity from cache record and Call B341290 in mode '3' to
update.
15. Else
16. Call B3401290 in mode '2' to Add a new cache record with Input Branch, 'ID',
MMSTRT and MMTRQT.
17. End If
18. If MMSTRT > Input $$MSGD then
19. Using MMUKID from current record, delete the record from F3411 using the
second requesthandle (use Index 1 to delete).
20. End If
21.End While
22.Close both request handles
23.Close user handle

Data Structure

D3500010 - MRP, Write Supply Quantities from Parts List

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 MCU char NONE NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

jdBeginningDate DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdEndingDate DATE02 JDEDATE NONE NONE

Event point for JDE Date.

nNumberOfPastDueDates INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

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

cPotencyControl OT1Y char NONE NONE

A code that indicates whether you control the item by potency.

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

cSuppressErrors EV01 char NONE NONE

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

szJobNumber JOB char NONE NONE

Job Number

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

cProcessWOFlag EV01 char NONE NONE

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

cTransitFlag EV01 char NONE NONE

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

cInspectFlag EV01 char NONE NONE

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

cOther1Flag EV01 char NONE NONE

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

cOther2Flag EV01 char NONE NONE

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

cConsolidationMethod EV01 char NONE NONE

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

szConsolidationBranch MCU char NONE NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szStdUOMConversion TFLA char NONE NONE

Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:    blank Use the item-specific
unit of measure    1       Bypass the item-specific unit of measure and use the standard unit of measure

mnStandardPotency STDP MATH_NUMERIC NONE NONE

The percentage of active ingredients normally found in an item.

Related Functions

B3401290 Cache, Process MRP Item Quantities

B3401300 Cache, Process MRP Inclusion Rules

B3401310 Cache, Process MRP Work Orders

B4000520 Get Item UoM Conversion Factor

Related Tables

F3111 Work Order Parts List

F43092 Purchase Order Receipt Routing File

F4801 Work Order Master File

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	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
jdBeginningDate	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdEndingDate	DATE02	JDEDATE	NONE	NONE
Event point for JDE Date.
nNumberOfPastDueDates	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
szPrimaryUOM	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).
cPotencyControl	OT1Y	char	NONE	NONE
A code that indicates whether you control the item by potency.
cInReceiptRoutingFlag	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.
cSuppressErrors	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szJobNumber	JOB	char	NONE	NONE
Job Number
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).
cProcessWOFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cTransitFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cInspectFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cOther1Flag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cOther2Flag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cConsolidationMethod	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szConsolidationBranch	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szStdUOMConversion	TFLA	char	NONE	NONE
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are: blank Use the item-specific unit of measure 1 Bypass the item-specific unit of measure and use the standard unit of measure
mnStandardPotency	STDP	MATH_NUMERIC	NONE	NONE
The percentage of active ingredients normally found in an item.

B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B3401310 Cache, Process MRP Work Orders
B4000520 Get Item UoM Conversion Factor

F3111 Work Order Parts List
F43092 Purchase Order Receipt Routing File
F4801 Work Order Master File