Functional Description
Purpose
Return the account balance as of the end of the second quarter. The sign of the balance can be
adjusted using the reverse sign parameter. If a 'Y' is passed for BalanceAudit, records will be written to
the balance audit work table (F83UI001). This function is called by the smart field Second Quarter
(FINRPTQ2).
Setup Notes and Prerequisites
This function is designed to run on the event column inclusion in a tabular UBE.
Valid Values for ReverseSign are:
0 = Do not reverse any signs.
1 = Reverse signs for P&L accounts.
2 = Reverse signs for Balance Sheet accounts.
To fully implement Balance Audit, you must call the application P83001 from the section properties of
a tabular UBE. If this step is not taken, the system values used as the key to the F83UI0001 will not
be populated and the results of Balance Auditor will be unpredictable.
Special Logic
The balance is calculated as of the fiscal year entered in the processing options or from the
Financial Reporting Date if the processing options are blank. This date is a baseline date that may be
adjusted through the use of fiscal year offset. For example, with a fiscal year of 5 and a +1 in the fiscal
year offset the account budget will be returned as of fiscal year 6. In fiscal year offset you may
supply blank for the current fiscal year, a specific year, or an offset to the current year (+1).
This function does not filter records based upon anything other than fiscal year. To select data on a
basis other than fiscal year, use column level data selection or report level data selection.
Technical Specification
Call GetCompanyInfo.
Determine target fiscal year based upon the current values returned by GetCompanyInfo and the
offsets to fiscal year.
If the fiscal year of the current record does not match the target fiscal year return a zero.
If the fiscal year matches the target fiscal year accumulate periods four, five and six.
If reverse signs is not equal to zero, reverse the signs based upon AAI ranges.
If balance audit is equal to yes, call UpdateBalanceAuditWorkfile.
Return the end of quarter two amount.
^
D83000Q2 - Q2 - End of Quarter 2
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnReturnAmount | AA | MATH_NUMERIC | NONE | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
szLTFiscalYearOffset | FYOF | char | NONE | NONE |
The fiscal year on which you want to base this column. Do one of the following actions: leave the field blank to use the current period, enter
| ||||
mnPOPeriodNumber | PN | MATH_NUMERIC | NONE | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
szBCCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnBCFiscalYear | 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
| ||||
mnBCAmountBucket04 | AN04 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnBCAmountBucket05 | AN05 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnBCAmountBucket06 | AN06 | MATH_NUMERIC | NONE | NONE |
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
szBCAccountID | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
szBCLedgerType | LT | char | NONE | NONE |
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
| ||||
szBCSubledger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cBCSubledgerType | SBLT | char | NONE | 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
| ||||
szBCCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szBCCurrencyCodeDenom | CRCX | char | NONE | NONE |
A code that indicates the currency in which an amount is denominated. | ||||
cSLBalanceAudit | BAUDIT | char | NONE | NONE |
Enter a Y to use the Balance Auditor. Default is not to use Balance Auditor. | ||||
szSLProgramId | 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
| ||||
szSLVersionId | VRID | char | NONE | NONE |
mnSLBalanceAuditSectionNumber | BASECN | MATH_NUMERIC | NONE | NONE |
The ID number of a report section or batch process that caused the system to generate balance audit information. | ||||
mnSLBalanceAuditColumnNumber | BACOLN | MATH_NUMERIC | NONE | NONE |
The column number from a report. | ||||
mnSLBalanceAuditRowNumber | BAROWN | MATH_NUMERIC | NONE | NONE |
The row number from a report. | ||||
szPOFiscalYear | FYOW | char | NONE | NONE |
A four-digit number that identifies the fiscal year. You can enter a number in this field or leave the field blank to indicate the current fiscal
| ||||
mnReverseSign | OWREVS | MATH_NUMERIC | NONE | NONE |
Use this processing option to reverse the sign of amounts printed on reports. Valid values are:
0 = Do not reverse any signs.
1= Reverse
| ||||
szBCObjectAccount | OBJ | char | NONE | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szBCSubsidiary | SUB | char | NONE | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. |
B83AUDIT Update Balance Audit Work File - (Financial Reporting) | ||||
B83GETCO Get Company Information - (Financial Reporting) |
None |