Purpose
Retrieve date sensitive balance information for an account in a Range of AAIs. The range of accounts is looped through for each account
accumulating the balances. 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. If the balance character code is passed then the correct F1202 account
records will be selected, and the totals accumulated. The balance character code is used for user defined depreciation in A73. It is not implemented
anywhere else in fixed assets until A8.1. The AAI range is the same concept as the balance character code, but will cost in processing. The AAI must contain
the range of F0901 Accounts to retrieve the correct information.
A company's fiscal date pattern must be set up in the F0010, and the date pattern must exist in the F0008.
This function calls X1200 which uses a data structure to store the hUser, hRequestF0911, and hRequestF1202. Memory is allocated and passed
back and forth between the two business functions and event rules. The ER programmer needs to call Memory Free Accumulated Retrieval to clean up
the file handles and the user handles. The pointer in memory should yield better performance.
D1200007 - F1202 Accumulate Date Sensitive Balances
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szAAI | ITEM | char | OPT | INPUT |
Special Input
| ||||
cBalanceCharacterCode | CHCD | char | OPT | INPUT |
| ||||
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
| ||||
mnAssetItemNumber | NUMB | MATH_NUMERIC | REQ | INPUT |
An 8-digit number that uniquely identifies an asset. | ||||
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 | OPT | NONE |
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 | OPT | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
mnCentury | CTRY | MATH_NUMERIC | OPT | 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 | OPT | 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
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
jdStartPeriod | DGL | JDEDATE | OPT | NONE |
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 | NONE |
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. | ||||
mnAccumulatedInception | A12OW | MATH_NUMERIC | OPT | OUTPUT |
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
| ||||
mnAccumulatedYearToDate | A12OW | MATH_NUMERIC | OPT | OUTPUT |
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
| ||||
mnAccumulatedPeriod | A12OW | MATH_NUMERIC | OPT | OUTPUT |
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
| ||||
szDepreciationMethod | ADM | char | OPT | OUTPUT |
The user defined code (12/DM) that indicates the method of depreciation for the specified book. In addition to any user defined
| ||||
mnLifeMonths | ADLM | MATH_NUMERIC | OPT | OUTPUT |
The life of an asset in months or periods. The system uses months or periods only to express the life of an asset. For example, if your
| ||||
cInitialTermApportionment | ITAC | char | OPT | OUTPUT |
A code for additional depreciation information. This code is used for investment tax credit (ITC) and averaging conventions. The system
| ||||
cComputeDirection | DIR1 | char | OPT | OUTPUT |
A code that specifies the method that the system uses to calculate depreciation based on the depreciation method you specify. Valid
| ||||
jdDepreciationStartDate | DSD | JDEDATE | OPT | OUTPUT |
The date when the depreciation computations start for an asset. This date can be different from the date the asset was acquired. | ||||
mnSalvageValue | TKER | MATH_NUMERIC | OPT | OUTPUT |
This quantity is used in the Field Progress Report to make adjustments to the Original Budget quantity. The projected final quantity is equal
| ||||
mnBeginningBalance | APYC | MATH_NUMERIC | OPT | OUTPUT |
The cumulative prior year-end balance. The system uses this amount as the beginning balance for balance sheet and job cost
| ||||
mnYTDAdditions | APYN | MATH_NUMERIC | OPT | OUTPUT |
The prior year-end net postings. The system uses this number for profit and loss statement comparisons.
NOTE: Do not confuse this
| ||||
mnTransferIn | BREQ | MATH_NUMERIC | OPT | OUTPUT |
A code that specifies the ledger type with which to track amounts in the Account Balances table (F0902). Valid values are:
| ||||
mnTransferOut | BAPR | MATH_NUMERIC | OPT | OUTPUT |
This field tracks the following amounts in the Account Balances file (F0902):
Ledger type - BA/BU. Approved Budget from Budget by
| ||||
mnYTDDisposals | BORG | MATH_NUMERIC | OPT | OUTPUT |
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902). | ||||
mnAnnualRuleAmount | POU | MATH_NUMERIC | OPT | OUTPUT |
The dollar amount (or quantity) required in addition to the budget (original +actual) to complete an item. | ||||
mnDepreciationMethodPercent | ADMP | MATH_NUMERIC | OPT | OUTPUT |
A number that specifies what percentage you want the system to use when calculating depreciation. You must use whole numbers. For
|
B1200001 Access F1200 | ||||
X1200 F1202 Date Sensitive Retrieval |
F0005 User Defined Codes | ||||
F0012 Automatic Accounting Instructions Master | ||||
F0901 Account Master | ||||
F1200 Fixed Asset Constants | ||||
F1202 Asset Account Balances File |