Purpose
Retrieve date sensitive balance information for an account ledger type. The balances are stored in the F1202 table. When a non end of period date is
sent, the F0911 records are backed out of the end of the period or added to the beginning of the period based on where the date lands in the date
pattern.
Setup Notes and Prerequisites
A valid account and data must exist in the F0901, F1202, and F0911.
A company's fiscal date pattern must be set up in the F0010, and the date pattern must exist in the F0008.
This function uses a data structure to store the hUser, hRequestF0911, and hRequestF1202. Memory is allocated and passed back and forth between
the business function and event rules. The ER programmer needs to call Memory Free Fixed Asset Retrieval to clean up the file handles and the user
handles. The pointer in memory should yield better performance.
OCM: Mappings this function is critical with other applications. These functions B1200005 and B1200006 should be mapped to the same place.
These functions primarily are called with UBEs, so the UBE probably have been mapped to a server, and it should not be an issue.
There are two things left out:
Determine if record is Cost Account for non 'AA' and units ledgers, and independent of 'AA'.
If the ledger type is dependent on the 'AA' ledger for cost, adjust the account ledger balance by any transactions in the 'AA' ledger.
Special Logic
Calculate the mid point between the data pattern to check reading the balance from the start period date and adding to the balance or reading the
balance from the end of period and subtracting the journal entries from the end period date.
The F1202 index must be added to fetch the information: F1202LC - logical on the AS400
FLMCU
FLOBJ
FLSUB
FLLT
FLCTRY
FLFY
FLFQ
FLSBL
FLSBLT
The F0911 index must be changed to add a field to help fetch the information: F0911LY - logical on the AS400 must also be changed to
accommodate this functionality
GLAID
GLLT
GLCTRY
GLFY
GLPN
GLSBL
GLSBLT
GLDGJ
D1200A - F1202 Data Sensitive Retrieval
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAssetID | NUMB | MATH_NUMERIC | REQ | INPUT |
An 8-digit number that uniquely identifies an asset. | ||||
szAccountID | AID | char | REQ | INPUT |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
szCompany | CO | char | REQ | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szLedgerType | LT | char | REQ | INPUT |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
szSubledger | SBL | char | REQ | INPUT |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | REQ | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
jdDate | DGL | JDEDATE | REQ | BOTH |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
cErrorFlag | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
mnCentury | CTRY | MATH_NUMERIC | REQ | BOTH |
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 | REQ | BOTH |
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
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | REQ | BOTH |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
jdStartPeriod | DGL | JDEDATE | OPT | BOTH |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
jdEndPeriod | DGL | JDEDATE | OPT | BOTH |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
idPointer | GENLNG | ID | REQ | BOTH |
General purpose ID variable. | ||||
mnInception | AO1OW | MATH_NUMERIC | OPT | OUTPUT |
A value that the method of computation and processing options are set to in order to determine which fields appear on this form. Valid
| ||||
mnYearToDate | AO1OW | MATH_NUMERIC | OPT | OUTPUT |
A value that the method of computation and processing options are set to in order to determine which fields appear on this form. Valid
| ||||
mnPeriod | AO1OW | MATH_NUMERIC | OPT | OUTPUT |
A value that the method of computation and processing options are set to in order to determine which fields appear on this form. Valid
|
B5100016 Validate Job Cost Date and Period | ||||
X1202 F1201 Validate Asset Number | ||||
XX0901 Validate Account Number |
F0025 Ledger Type Master File | ||||
F0911 Account Ledger | ||||
F1202 Asset Account Balances File |