F0916RetrievePrevStmntEndBal

F0916 Retrieve Prev Stmnt End Bal

Minor Business Rule

Object Name: B0900088

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
If the current bank statement is in-sequence with the existing bank statements and the previous bank
statement is reconciled, this business function will retrieve the previous bank statement's ending
balance. This business function requires the following input parameters: G/L Bank Account, current
statement date, and current statement number.

Setup Notes and Prerequisites
The business function contains a parameter named cExcludeCurrentStmnt.  This parameter is used only
by the Bank Statement Journal (R09170) to avoid any edits (in-sequence and reconciliation) from being
performed on the  bank statement in the process of being reconciled.

Technical Specifications

• Determine if previous bank statement exists
• Sequence the bank statements (by statement date and number) in descending order
• Select the most recent bank statement for the specified bank account.
• If bank statement exists and the entered bank statement is not in sequence

• Set an error and return

• Else If a previous bank statement does not exist

• Set a warning stating the a previous statement does not exist

• If previous bank statement is not reconciled

• Set an error and return

• If no errors are found

• Return previous bank statement's ending balance

•
^

Data Structure

D0900088 - F0916 Retrieve Prev Stmnt End Bal

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szGlBankAccount	GLBA	char	NONE	NONE
Special Input Expected This required input parameter receives the bank account number (GLBA) that the business function will use to retrieve the previous bank statement. ^
jdStatementDate	STMD	JDEDATE	NONE	NONE
Special Input Expected This required input parameter receives the bank statement date of the CURRENT statement being entered/processed. ^
szBankStatementNumber	STBA	char	NONE	NONE
Special Input Expected This required input parameter receives the bank statement number of the CURRENT statement being entered/processed. ^
mnEndingBalance	ENBL	MATH_NUMERIC	NONE	NONE
Special Output Returned This output parameter returns the previous statement's ending balance if the current statement is in sequence and if the previous statement is reconciled. ^
cNonSeqStmntError	EV06	char	NONE	NONE
Special Output Returned This output parameter returns a value of '1' if the current bank statement being entered/processed is not in sequence. ^
cPrevStmntNotRecon	EV07	char	NONE	NONE
Special Output Returned This output parameter returns a value of '1' if the previous bank statement is not reconciled. ^
cExcludeCurrentStmnt	EV09	char	NONE	NONE
Special Input Expected This input parameter will be used by the business function to determine if the current statement being entered/processed should be excluded from the edits. This will be used by the Bank Statement Journal UBE (R09170) to avoid any sequence and reconciliation edits from being performed on the current bank statement being reconciled. Significant Data Values '1' - Do not perform in-sequence and reconciliation edits on the current bank statement being entered/processed. ^
cPrevStmntDoesNotExist	EV11	char	NONE	NONE
Special Output Returned This output parameter returns a value of '1' a previous bank statement does not exist for the specified bank account. ^

Related Functions

None

Related Tables

F0916 Bank Statement Header