1.Functional Description
1.1Purpose
This function will update and or create detail forecast records (F3460)
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
If the GrandTotalQuantity is not equal to zero
Or the GrandTotalAmount is not equal to zero
Retrieve the Forecast detail record (F3460) with the key of ShortItemNumber, Branch and
theSaveYear.
If a record was found update it
GrandQuantity add toMFFQT
GrandAmount add toMFFAM
GrandQuantity add toMFUORG
GrandAmount add toMFAEXP
Get the following from GetAuditInfo
CurrentDateMFUMPJ
CurrentTimeMFTDAY
UserMFUSER
Terminal NumberMFJOBN
ProgramIDMFPID
Else Write the detail record
ShortItemNumberMFITM
SecondItemNumberMFLITM
ThirdItemNumberMFAITM
BranchMFMCU
'FR'MFDCTO
ForecastTypeMFTYPF
ZerosMFDRQJ
SaveYearMFYR
GrandQuantity MFFQT
GrandAmountMFFAM
MFFQTMFUORG
MFFAMMFAEXP
'N'MFBPFC
Get the following from GetAuditInfo
CurrentDateMFUMPJ
CurrentTimeMFTDAY
UserMFUSER
Terminal NumberMFJOBN
ProgramIDMFPID
End
Move zeros to the GrandTotal Quantity and Amount
End
^
D3400775 - Update Detail Forecast Records
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
| ||||
szSecondItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
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
| ||||
szForecastType | 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
| ||||
mnGrandTotalQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnGrandTotalAmount | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnSaveYear | YR | MATH_NUMERIC | NONE | NONE |
The calendar year for this calendar. | ||||
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
| ||||
szDocumentType | DCTO | char | NONE | 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
| ||||
cBypassForcing | BPFC | char | NONE | NONE |
A code that indicates whether to bypass the Forecast Forcing program (R34610). A Y indicates that the quantity and amount of a forecast
| ||||
cUpdateOriginals | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. |
B9800100 Get Audit Information |
F3460 Forecast File |