Functional Description
Purpose
This business function CheckAs Of file (F41112) is used when it changed a quantity or amount value
in
Direct As Of Entry. Then this business function check if cumulative quantities and amounts it's
correct.
Setup Notes and Prerequisites
The Direct As Of File passes to the business function the index will be used.
List of fields of the index:
2. ITM
3. MCU
4. LOTN
5. LOCN
6. GLPT
7. CTRY
8. FY
Special Logic
None
Technical Specifications
When Call Type if equal "1" the business function calculate the cumulative quantity and amount. The
program read the previous record of the Item As Of file with the key (DCT, MCU, ITM, LOCN ,LOTN, GLPT,
CTRY, FY).The previous record must have the same key except the fiscal year. The previous cumulative
quantity is the sum of all period quantities plus the cumulative quantity of the year. The same thing
is for previous cumulative amount. If the previous cumulative quantity and amount not equal to
Variance Amount and Quantity send error message. In all case the business function return with the correct
cumulative quantity and amount.
When Call Type if equal "2" the business function update the cumulative quantity and amount for all
next years. The program read all next records of the Item As Of file with the key (DCT, MCU, ITM, LOCN,
LOTN, GLPT, CTRY, FY).The next records must have the same key except the fiscal year. For this next
records the cumulative quantity or amounts is the same value plus the Variance Quantity or Variance
Amount. If next records don't exist, the program doesn't update anyone record and it doesn't send an
error message.
^
D4100890 - F41112 - Check and Update F41112
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
mnIdentifierShortItem | 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
| ||||
szBusinessUnit | 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
| ||||
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szGLCategory | GLPT | char | NONE | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
| ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
cCallType | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnAmountVariance | VARA | MATH_NUMERIC | NONE | NONE |
The variance amount of an inventory transaction for an inventory item. | ||||
mnQuantityVariance | QTYA | MATH_NUMERIC | NONE | NONE |
The number of units that you adjusted during the receipt routing. | ||||
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
| ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. |
B9800100 Get Audit Information |
F41112 Item ASOF File |