AssureAvailability_by_CSID

F41021 Assure Availability by ITM, MCU, CFGSID

Minor Business Rule

Object Name: N3201330

Parent DLL: CMFG

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
The main purpose of this Business Function is to find out if there is Available Quantity or not.
This function will find Location (LOCN) and Lot/Serial Number (LOTN) from F41021 table based on input values of Short Item Number (ITM),
Branch/Plant (MCU) and Unique Configured String ID (CFGSID), than will call B3100380 Business Function to calculate Available Quantity for specified
parameters. As soon as Available Quantity is greater than zero, this function will pass IsQuantityAvailable = 1 to the application, otherwise function will
pass IsQuantityAvailable = 0 to the application.

1.2Setup Notes and Prerequisites

1.3Special Logic
None.

2.Technical Specifications

2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
ITMShort Item NumberIY
MCUCost CenterI Y
CFGSIDUnique Configuraton IDIY
EV01Is Quantity AvailableOY
SUPPSSuppress Error MessageIYValue of 1
DTAIError Message IDON

2.2Related Tables
Table Table Description
F41021Item Location File
F32941Configured String Master

2.3Related Business Functions
Source NameFunction Name
B3100380Calculate Quantity Available Shell

2.4 Processing

2.4.1 Assign value zero to following variables:
BF cIsQuantityAvailable = "0"
VA evt_cRecordFound_EV01 = "0"

2.4.2 Open Table
F41021.Open

2.4.3 Check if Table is Open
If SV File_IO_Status is equal to CO SUCCESS

2.4.4 Select Records based on ITM, MCU and CSID
F41021.Select

        BF mnIdentifierShortItem =  TK Item Number - Short
        BF szCostCenter =  TK Business Unit
        BF szUniqueConfigurationID =  TK Unique Configuration ID

2.4.5 Fetch Next until end of selection or if returned parameter is not equal to
While SV File_IO_Status is equal to CO SUCCESS And BF cIsQuantityAvailable is equal to

Get additional parameters ( LOCN, LOTN) for B3100380 Business Function
F41021.Fetch Next

           VA evt_szLocation_LOCN <- TK Location
           VA evt_szLotSerialNumber_LOTN <- TK Lot/Serial Number

VA evt_mnConfigID_CFGSID <- TK Unique Configuration ID

2.4.6 Call external Business Function (B3100380)

VA evt_cRecordFound_EV01 = "1"
F41021 Calculate Quantity Available

           BF mnIdentifierShortItem -> mnShortItemNumber
           BF szCostCenter -> szBranchPlant
           VA evt_szLocation_LOCN -> szLocation
           VA evt_szLotSerialNumber_LOTN -> szLotNumber
           "1" ->  cSuppressErrorMessages
           VA evt_mnQuantityAvailable_QAVAL <- mnQuantityAvailable
           "1" -> mnIndex
           "4" -> mnKeys
            "1.0000000" -> mnConversionFactor
2.4.7 Quit While loop  as soon as Quantity Available is > 0

If VA evt_mnQuantityAvailable_QAVAL is greater than

BF cIsQuantityAvailable = "1"

End If

End While
2.4.8 Check if any matching records were found
If VA evt_cRecordFound_EV01 is equal to

//

// No records (for given ITM, MCU, CSID) were found
//
BF szErrorMessageID = "2838"
//

// Do not pass the Error Message if cSuppressErrorMessage = 1
//

If BF cSuppressErrorMessage is not equal to "1"

Set NER Error(2838, BF szErrorMessageID)

End If

End If

2.4.9 Close Table

else

//
// Table could not be opened
//
BF szErrorMessageID = "078D"
//
// Do not pass the Error Message if cSuppressErrorMessage = 1
//
If BF cSuppressErrorMessage is not equal to "1"

Set NER Error("078D", BF szErrorMessageID)

End If

End If

Data Structure

D3201330 - F41021 Assure Availability by ITM, MCU, CSID

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

mnIdentifierShortItem 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

szCostCenter MCU char OPT 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.

cIsQuantityAvailable EV01 char OPT NONE

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

cSuppressErrorMessage SUPPS char OPT NONE

A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.        0 = allow
runtime error message handling.        1 = suppress runtime error message handling.

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

szUniqueConfigurationID CFGSID char OPT NONE

An identifier that represents a unique configuration. It is generated from an encryption algorithm.  Regardless of the number of segments or
levels in the configured item, the system always converts the information into a 32-character digest. The digest is always a full 32 characters
in length, consists of numbers and characters, and does not contain any blanks. You cannot determine the initial value from the digest, and it
has no significant meaning.

szLotGroup LOTGRP char OPT NONE

Lot Group is the name of a user defined list of allowed non-blank lot status codes.  Entry of a Lot Group name in the Processing Option will
allow this Application to process lots whose lot status code is defined within the specified Lot Group Name.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnIdentifierShortItem	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
szCostCenter	MCU	char	OPT	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.
cIsQuantityAvailable	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageID	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.
szUniqueConfigurationID	CFGSID	char	OPT	NONE
An identifier that represents a unique configuration. It is generated from an encryption algorithm. Regardless of the number of segments or levels in the configured item, the system always converts the information into a 32-character digest. The digest is always a full 32 characters in length, consists of numbers and characters, and does not contain any blanks. You cannot determine the initial value from the digest, and it has no significant meaning.
szLotGroup	LOTGRP	char	OPT	NONE
Lot Group is the name of a user defined list of allowed non-blank lot status codes. Entry of a Lot Group name in the Processing Option will allow this Application to process lots whose lot status code is defined within the specified Lot Group Name.
szOrderType	DCTO	char	OPT	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents