F3460GenerateActualNumbers

F3460 Generate Actual Numbers

Major Business Rule

Object Name: B3400820

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function will retrieve the actual information from the Detail Forecast file (F3460) and build a
quantity and amount list by customer.

1.2Setup Notes and Prerequisites

•

1.3Special Logic

2.Technical Specifications
1.If ProgramID is equal to 'R34650' or 'EP3461'
Call B3401050 with LastDateForActuals to create the actuals linked list if it doesn't
already exist and initialize it with NULL buckets
SETLL on the Detail Forecast file F3460with ShortItemNumber, Branch, the ActualType, and
FirstDateForActuals
If a record is found
Read all records equal to the key minus the date
If the date on the record (MFDRQJ) is less than or equal to
LastDateForActuals
And the date is not equal to zero
If LargeCustomer = '1'
Move MFAN8 to AddressNumber
Else
Move zeros to AddressNumber
End
Call B3401050 to add the forecast quantity and forecast amount to the
actuals linked list
End
End
End

2.Count the Number of Customers (including the zero customer) in the PntrToCustomer list and
place the result in NumberOfCustomers

^

Data Structure

D3400820 - F3460 Generate Actual Numbers

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnShortItemNumber	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.
szActualType	TYPF	char	NONE	NONE
A user defined code (34/DF) that indicates one of the following: o The forecasting method used to calculate the numbers displayed about the item o The actual historical information about the item
jdFirstDateForActuals	DRQJ	JDEDATE	NONE	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
jdLastDateForActuals	DRQJ	JDEDATE	NONE	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
mnYearOffFirstDate	YR	MATH_NUMERIC	NONE	NONE
The calendar year for this calendar.
idPtrToCustomers	GENLNG	ID	NONE	NONE
General purpose ID variable.
mnLastBucketPosition	MATH02	MATH_NUMERIC	NONE	NONE
- - - Good Performance High Value.
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.
cMonthlyVsWeekly	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
idPointerToDates	GENLNG	ID	NONE	NONE
General purpose ID variable.
cMeanAbsoluteDeviation	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cLargeCustomer	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnNumberOfCustomers	MATH02	MATH_NUMERIC	NONE	NONE
- - - Good Performance High Value.

Related Functions

B3401050 Forecast Accumulate Actuals

Related Tables

F3460 Forecast File