AccountBalanceDebitAndCredit

Account Balance Debit and Credit - COL -09 - 76C

Minor Business Rule

Object Name: B76C0004

Parent DLL: CLOC

Location: Client/Server

Language: C

Functional Description

Purpose
This business function is used to calculate the total amount of debits and the total amount of
credits for a period.
The values are retrieved from the file F0911.

Setup Notes and Prerequisites

Special Logic
This function returns the account balance discriminated in Debits and Credits. The file F0911 is read
to get the amount (glaa), this amount is discriminated in debits or credits.
The account balance calculated is only for the period that is enter as parameter.

Technical Specifications
Parameters:
szAccountId[9]Short IDIRequired
szCompany[6]CompanyIRequired
szLedgerType[3]Ledger TypeIRequired
jdThruDateAs Of DateIRequired
szSubledger[9]SubledgerI* = All Subledgers
cSubledgerTypeSubledger TypeI
szCurrency[4]CurrencyI* =All currencies
cIncludeUnpostedPosted FlagI0 =Posted only ;
1 =Inlcude Unposted
mnAmountDebDebitsO
mnAmountCrdCreditsO
mnAmountTotal amountO
cBalanceTypeBalance type flagI2 = Period Only

Related Tables
F0911Account Ledger

^

Data Structure

D76C0004 - Account Balance Debit and Credit - COL - 09 - 76C

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
jdThruDate	EDOWLD	JDEDATE	NONE	NONE
The ending date for the period that you want to review. If you leave this field blank, the system uses the ending date of the current period specified for the company.
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 address book number. If you enter a subledger, you must also specify the subledger type.
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 editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
szCurrency	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
cIncludeUnposted	INCOW	char	NONE	NONE
A checked box indicates unposted general ledger records will be added into the account balance amount displayed.
mnAmountDeb	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 minus sign (-) either before or after the amount.
mnAmountCrd	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 minus sign (-) either before or after the amount.
mnAmount	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 minus sign (-) either before or after the amount.
cBalanceType	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szLedgerType	VL01	char	NONE	NONE
The list of selection values associated with a data selection item in the Dream Writer. This list is generated by the use of the VALUES keyword in data selection setup. Elements 1 and 2 are also used to contain the upper and lower value for the keyword RANGE used by the data selection in the Dream Writer.

Related Functions

None

Related Tables

F0902 Account Balances
F0911 Account Ledger