RefreshReconcile

Refresh Reconcile

Major Business Rule

Object Name: B0900006

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This business function reconciles the Account Ledger (F0911) File. It retrieves the Account Ledger
(F0911) records and updates the Account Ledger File for Reconciliation(F0911R). It then updates the
Account Reconciliation Header File (F0911R1).

Technical Specification
• Validates the account passed in.
• Verifies if the account in the Reconcilable Range by looking at the AAI's.
• Retrieves all the Account Ledger (F0911) records for the account currently processing.
• Deletes the records in the Account Ledger File for Reconciliation(F0911R) pertaining to the current
account.
• Updates the Account Ledger File for Reconciliation(F0911R)file from the Account Ledger File (F0911).
• Also updates the Account Reconciliation Header File (F0911r1).
• The Account Reconciliation Header File is updated for every ledger type.

Data Structure

D0900371 - Refresh Reconcile

Special Input Expected

Special Output Returned

Significant Data Values

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

jdStartDate DSE JDEDATE NONE NONE

Special Input Expected
Start Date indicates the From Date for the Account Ledger Records which are going to be selected.

^

jdEndDate DEE JDEDATE NONE NONE

Special Input Expected

End Date indicates the Through Date for the Account Ledger Records which are going to be selected.

^

cAETypeFlag EV01 char NONE NONE

Special Input Expected
This flag indicates that the automatic entries would be includes.

Significant Data Values
1 - not include Automatic Entries
anything else includes Automatic Entries.

cUnreconciledOnlyFlag EV02 char NONE NONE

Special Input Expected
This flag indicates if both reconciled and unreconciled are included in the selection of the Account
Ledger Records.

Significant Data Values
1 - Unreconciled items only
anything else - Reconciled items

^

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
can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

nIndexLastRange EVENT1 integer NONE NONE

FUTURE USE

^

idPointer GENLNG ID NONE NONE

FUTURE USE

^

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.

cInRange EV02 char NONE NONE

Special Output Returned
Return Value indicating the results of the function.
Significant Data Values
1 - No record selected
2 - Account not within the AAI range
3 - Account within the AAI range

^

Related Functions

B0000006 Concatenate Object Subsidiary

B0400009 Get Account Company

B0900008 Return Account Balance

B9800100 Get Audit Information

XX0901 Validate Account Number

Related Tables

F0012 Automatic Accounting Instructions Master

F0901 Account Master

F0911 Account Ledger

F0911R WF - Account Ledger Reconciliation

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
jdStartDate	DSE	JDEDATE	NONE	NONE
Special Input Expected Start Date indicates the From Date for the Account Ledger Records which are going to be selected. ^
jdEndDate	DEE	JDEDATE	NONE	NONE
Special Input Expected End Date indicates the Through Date for the Account Ledger Records which are going to be selected. ^
cAETypeFlag	EV01	char	NONE	NONE
Special Input Expected This flag indicates that the automatic entries would be includes. Significant Data Values 1 - not include Automatic Entries anything else includes Automatic Entries.
cUnreconciledOnlyFlag	EV02	char	NONE	NONE
Special Input Expected This flag indicates if both reconciled and unreconciled are included in the selection of the Account Ledger Records. Significant Data Values 1 - Unreconciled items only anything else - Reconciled items ^
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 can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
nIndexLastRange	EVENT1	integer	NONE	NONE
FUTURE USE ^
idPointer	GENLNG	ID	NONE	NONE
FUTURE USE ^
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.
cInRange	EV02	char	NONE	NONE
Special Output Returned Return Value indicating the results of the function. Significant Data Values 1 - No record selected 2 - Account not within the AAI range 3 - Account within the AAI range ^

B0000006 Concatenate Object Subsidiary
B0400009 Get Account Company
B0900008 Return Account Balance
B9800100 Get Audit Information
XX0901 Validate Account Number

F0012 Automatic Accounting Instructions Master
F0901 Account Master
F0911 Account Ledger
F0911R WF - Account Ledger Reconciliation