Functional Description
Purpose
This function is used to:
Calculates the total amount for the accounts of greater level of detail. The amounts are returned in
Debits and Credits Separatly
The UBE R76C9412 calls this function.
Setup Notes and Prerequisites
This business function was copy from B0900044 (Accumulate Accounts of Greater LOD).
Special Logic
This new function returns the account balance discriminated in Debits and Credits.
Modifications:
The UBE R76C9412 builds the work file F76CUI01. This function uses that work file instead using the
file F0901 to calculate the amounts.
New Parameters: AmountDeb. AmountCrd
This function must calls the function "AccountBalanceDebitAndCredit" (B76C0004) instead of calling
the function "Account Balance Calculate" (B0900008)
Technical Specifications
Parameters:
szBusiness Unit[13]Business UnitI Required
szObject[7]Object accountI Required
szSubsidiary[9]Subsidiary I Required
szAccountID[9]Short IDI Required
szCompany[6]CompanyI Required
szLedgerType[3]Ledger TypeI Required
cSubledger[9]SubledgerI Required * = All
Subledger
cSubledgerTypeSubledgerTypeI Required
szCurrencyCurrencyI Required* = All
Currency
jdThruDateEnd dateI Required
cIncludeUnpostedI Required
0 = Posted Only
cBalanceTypeBalance type flagI Required
0 = Prior
Period,
1 = Current
Balance
2 = This
Period
cLevelOfDetailLevel Of DetailI Required
mnAmountDebitAmount DebitO
mnAmountCreditAmountCreditO
szCategoryCodeCategory Code I Required
Allowed Values:
21, 22, 23
Related Tables
F76CUI03Account Cat. Code Work File
Colombia
Related Business Functions
B76C0004Account Balance Debit And Credit
B76C0008F42565 - Recalculate Sales Taxes Colombia
^
D76C0016 - Accumulate Accounts of Greater LOD - COL - 09 - 76C
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
szObject | 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
| ||||
szSubsidiary | SUB | char | NONE | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szAccountId | 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. | ||||
szCompany | 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
| ||||
szLedgerType | 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
| ||||
szSubledger | 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
| ||||
cSubledgerType | 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
| ||||
szCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
jdThruDate | SDTE | JDEDATE | NONE | NONE |
A date that indicates when the allocation becomes inactive. When the G/L date is less than this date, or when you leave this field blank,the
| ||||
cIncludeUnposted | POST | char | NONE | NONE |
A code the system uses to determine whether a transaction is available for the post process. Valid codes
| ||||
cBalanceType | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cLevelOfDetail | LOD | char | NONE | NONE |
The Level of Display field contains a number or letter identifying the level at which menus and processing options are displayed. The
| ||||
mnPriorPeriodAmount | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnDebitAmount | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnCreditAmount | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnCurrentPeriodAmount | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
szCategoryCode | R021 | char | OPT | NONE |
Category code 21 is associated with the Account Master file (F0901). This is a user defined code (system 09, type 21) for use in flex
| ||||
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
| ||||
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
| ||||
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
|
B76C0004 Account Balance Debit and Credit - COL -09 - 76C |
F0901 Account Master | ||||
F76CUI01 Account Master - Work File - COL - 76C |