SpreadBudget

Spread Annual Budget to Periods

Major Business Rule

Object Name: B1400007

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose

This function receives the amount passed in and spreads it to the fourteen period amounts that are
returned as parameters.  The business function determines the number of period to spread to by looking
at the account's company information.  The manner in which the amount is spread is determined by the
budget pattern code that is passed in as a parameter.

Setup Notes and Prerequisites

When spreading the amounts the business function will use the rounding increment and rounding method
parameters to resolve any rounding issues, and when the annual budget amount is not an even multiple
of the rounding increment the balancing method.

Technical Specification

Determine the type of spread to perform.
If the budget pattern code is equal to do not spread
If the ledger type is set to do not spread
Perform an even spread
Else
return without spreading
If the budget pattern code is not equal to do not spread and the budget pattern code is not blank
Perform a spread according the budget pattern code
Else If even spread
Perform an even spread
Else If budget pattern code is blank
Perform spread according to blank budget pattern code
If spread failed
Perform even spread ^
^

Data Structure

D1400451 - Spread Annual Budget to Periods

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szAccountId	AID	char	NONE	NONE
Special Input Expected This input parameter receives the account ID for the account pertaining to the spread to be performed. ^
mnCentury	CTRY	MATH_NUMERIC	NONE	NONE
Special Input Expected This input parameter receives the century for the spread to be performed. ^
mnFiscalYear	FY	MATH_NUMERIC	NONE	NONE
Special Input Expected This input parameter receives the fiscal year for the spread to be performed. ^
szFiscalQtr	FQ	char	NONE	NONE
Special Input Expected This input parameter receives the fiscal quarter for the spread to be performed. ^
szLedgerType	LT	char	NONE	NONE
Special Input Expected This input parameter receives the ledger type for the spread to be performed. ^
szSubledger	SBL	char	NONE	NONE
Special Input Expected This input parameter receives the subledger for the spread to be performed. ^
cSubledgerType	SBLT	char	NONE	NONE
Special Input Expected This input parameter receives the subledger type for the spread to be performed. ^
szCurrencyCode	CRCD	char	NONE	NONE
Special Input Expected This input parameter receives the currency code for the spread to be performed. ^
mnAmount1	AN01	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #1. ^
mnAmount2	AN02	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #2. ^
mnAmount3	AN03	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #3. ^
mnAmount4	AN04	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #4. ^
mnAmount5	AN05	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #5. ^
mnAmount6	AN06	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #6. ^
mnAmount7	AN07	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #7. ^
mnAmount8	AN08	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #8. ^
mnAmount9	AN09	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #9. ^
mnAmount10	AN10	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #10. ^
mnAmount11	AN11	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #11. ^
mnAmount12	AN12	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #12. ^
mnAmount13	AN13	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #13. ^
mnAmount14	AN14	MATH_NUMERIC	NONE	NONE
Special Input Expected This output parameter returns the spread amount for period #14. ^
mnMath01	MATH01	MATH_NUMERIC	NONE	NONE
Special Input Expected This required input parameter receives the annual budget amount to spread. ^
szBudgetPatternCode	BPC	char	NONE	NONE
A unique three-character code that identifies a seasonal pattern. The system uses this code to calculate budget amounts for an accounting period. For example: DNS Do not spread annual budget among the months. You cannot set up or change this code, defined as part of the system. Blank Spread annual budget evenly across all months. (Blank works this way unless your company changes it to mean otherwise.) *** Represents a blank value. SUM Spread according to percentages shown below. WIN Spread according to percentages shown below. SUM (Summer) Jan. 0% Feb. 2% .... 48% .... 50% Dec. 0% TOTAL - 100% WIN (Winter) Jan. 30% Feb. 30% ... 0% ... 0% Dec. 40% TOTAL - 100%
szCompany	CO	char	NONE	NONE
Special Input Expected This required input parameter receives the company for the spread to be performed. ^
mnIncrm	MATH02	MATH_NUMERIC	NONE	NONE
Special Input Expected This required input parameter receives the rounding increment for the spread to be performed. The result of rounding will be exactly divisible by this value. Example: 10 - Round to the nearest 10 1 - Round to the the nearest 1 ' ' - Round to the smallest currency unit ^
cBal	EV02	char	NONE	NONE
Special Input Expected This required input parameter receives the balancing method for the spread to be performed. This method will be used when an annual budget amount is not an even multiple of the specified rounding increment. Significant Data Values ' ' - Do not force the the total of the rounded period amounts to equal the annual budget amount. '1' - Force a balanced spread by rounding the annual budget amount prior to the spread. '2'- Force a balanced spread by NOT rounding the last calculated period amount. ^
cRound	EV04	char	NONE	NONE
Special Input Expected This required input parameter receives the rounding method for the spread to be performed. Significant Data Values ' ' - Round up or down to nearest increment. '1' - Round up to next increment. '2' - Round down to previous increment. ^

Related Functions

None

Related Tables

F0010 Company Constants
F0025 Ledger Type Master File
F0902 Account Balances
F1401 Budget Patterns