AccumulateBalForAndPriorYear

Accumulate Balance Forward and Prior Year Postings

Minor Business Rule

Object Name: B0900050

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This business function returns the prior year net postings and the balance forward amount for a
specified account, thru date, ledger type, subledger, and currency code. It also can accumulate the
amounts for all subledgers and currencies.

Setup Notes and Prerequisites
To roll up the amounts for all the subledgers of an account pass in an '*' in the subledger input
parameter. To roll up the amounts for all currency codes for an account, pass in an '*' in the currency
code input parameter.

Technical Specification
• Get fiscal year and century for specified thru date
• Setup the key for the F0902
• Retrieve and accumulate all prior year net postings and balance forward amounts that pertain to
input parameters

Data Structure

D0900050 - Accumulate Balance Forward and Prior Year Postings

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

szAccountID AID char NONE NONE

Special Input Expected
This required input parameter receives the account ID to be used to retrieve the amounts.
^

szCompany CO char NONE NONE

Special Input Expected
This required input parameter receives the company of the account passed in parameter #1.  It is used
to retrieve the fiscal year and century.
^

szLedgerType LT char NONE NONE

Special Input Expected
This required input parameter receives the ledger type to be used to retrieve the amounts.
^

jdThruDate DGJ JDEDATE NONE NONE

Special Input Expected
This required parameter receives the date to be used as the ending date for the amounts to be
retrieved.
^

szSubledger SBL char NONE NONE

Special Input Expected
The input parameter receives the subledger to be used when retrieving the amounts.

Significant Data Values
'*'  Amounts returned will include records with any
      subledger.

^

cSubledgerType SBLT char NONE NONE

Special Input Expected
This input parameter receives the subledger type for the subledger entered for parameter #4.  If
subledger is an '*' or blank this parameter should be blank.

^

szCurrencyCode CRCD char NONE NONE

Special Input Expected
This input parameter receives the currency code to be used when retrieving the amounts.

Significant Data Values
'*'  Amounts returned will include records with any
      currency code.

^

mnBalanceForward APYC MATH_NUMERIC NONE NONE

Special Output Returned
This output parameter returns the accumulated balance forward amount.

mnPriorYearNetPostings APYN MATH_NUMERIC NONE NONE

Special Output Returned
This output parameter returns the accumulated prior year net postings.

^

Related Functions

X0903 Fiscal Date Edits +

Related Tables

F0902 Account Balances

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szAccountID	AID	char	NONE	NONE
Special Input Expected This required input parameter receives the account ID to be used to retrieve the amounts. ^
szCompany	CO	char	NONE	NONE
Special Input Expected This required input parameter receives the company of the account passed in parameter #1. It is used to retrieve the fiscal year and century. ^
szLedgerType	LT	char	NONE	NONE
Special Input Expected This required input parameter receives the ledger type to be used to retrieve the amounts. ^
jdThruDate	DGJ	JDEDATE	NONE	NONE
Special Input Expected This required parameter receives the date to be used as the ending date for the amounts to be retrieved. ^
szSubledger	SBL	char	NONE	NONE
Special Input Expected The input parameter receives the subledger to be used when retrieving the amounts. Significant Data Values '*' Amounts returned will include records with any subledger. ^
cSubledgerType	SBLT	char	NONE	NONE
Special Input Expected This input parameter receives the subledger type for the subledger entered for parameter #4. If subledger is an '*' or blank this parameter should be blank. ^
szCurrencyCode	CRCD	char	NONE	NONE
Special Input Expected This input parameter receives the currency code to be used when retrieving the amounts. Significant Data Values '*' Amounts returned will include records with any currency code. ^
mnBalanceForward	APYC	MATH_NUMERIC	NONE	NONE
Special Output Returned This output parameter returns the accumulated balance forward amount.
mnPriorYearNetPostings	APYN	MATH_NUMERIC	NONE	NONE
Special Output Returned This output parameter returns the accumulated prior year net postings. ^