Defining Account Type Options

This section provides an overview of account type options and discusses how to assign signs and calculation rules for account types.

Page Used to Define Account Type Options

Page Name	Definition Name	Navigation	Usage
Account Type Options	BP_ACCT_TYP_OPT	select Planning and Budgeting, then select Planning and Budgeting Setup, then select Define Parameters, then select Account Type Options	Define mathematical signs for monetary amounts by account type that are used in Planning and Budgeting and determine budget data analysis and reporting calculation rules.

Understanding Account Type Options

Use account type options to specify how the system handles the mathematical operator that is associated with certain ledger amounts during the data staging and export processes. You can also specify the rules that the system uses for data analysis and reporting calculations.

For example, if your organization stores monetary values for the Revenue account type as negative numbers in the ledger but you want to view revenues as positive numbers during line item budgeting and analysis, you can specify that the system reverse the sign for revenues during the data staging process. The system reverses the sign again when you export the budgeting data from the model back to the budget ledger tables to ensure that the signs are consistent within the ledger for the account type.

Note: For analysis purposes—processes that you run from the Variance Analysis and Version Analysis pages—you can specify the calculation rules that are used for account types. For example, to view a net total of accounts that include both revenue and expense accounts, define the calculation rules that the system uses to deduct expenses from revenues to calculate a net total.

The Version Analysis, Scenario Comparison, Summary of Methods, and Budget Comparison Structured Query Report (SQR) reports use the add or deduct indicator for account types when displaying amounts on reports.

Account Type Options Page

Use the Account Type Options page (BP_ACCT_TYP_OPT) to define mathematical signs for monetary amounts by account type that are used in Planning and Budgeting and determine budget data analysis and reporting calculation rules.

Navigation

select Planning and Budgeting, then select Planning and Budgeting Setup, then select Define Parameters, then select Account Type Options

Image: Account Type Options page

This example illustrates the fields and controls on the Account Type Options page. You can find definitions for the fields and controls later on this page.

Define the options by account type for a Standard Budget Type or Control Budget Type, depending on the budgeting type that you use.

Note: Use the Standard Budget Type grid to set up account type options for both the Standard Budget type and the Project Budget Ledger budget type.

Flip Sign

Select to reverse the sign that is associated with the account type data. Use this functionality to avoid the confusion of viewing negative numbers when you are budgeting.

The system multiples ledger amounts by –1 and references this selection when you:

Stage data (BP_STAGE).
Export budgeting data to the budget ledger or General Ledger staging table (BP_EXP).
View any planning target setup pages or the Planning Target page accessed through the Line Item Details page.

When you select the Flip Sign check box and save data in the ledger with a negative sign, the system changes the sign to positive during the data staging process for use in the planning model. When you export the budgeting data, the system changes the sign back to negative.

When you save the account type data as a positive number in the ledger and you select this check box, the same values appear as negative numbers throughout the budgeting process. If you clear this check box, the same numbers appear as positive numbers just as they exist in the ledger.

Note: Any existing position-related or job-related data from PeopleSoft Human Resources or another system does not reference the flip sign during data stage, or export processes.

Any existing asset-related data from PeopleSoft Asset Management or another system does not reference the flip sign during data stage process.

Analysis Calculation

Select how the system calculates values for the account type during analysis and reporting, and within the Line item grid on the Line Item Details page. Values are Add and Deduct.

The system references your selection when you use the following pages:

Variance Analysis
Version Analysis
Line Item Details

For the following SQR reports, the system references this selection when you view by account:

Version Analysis (BPS1001 SQR)
Scenario Comparison (BPS1002 SQR)
Summary of Methods (BPS1004 SQR)
Budget Comparison (BPS1005 SQR)

See Understanding Predefined Reports.