Amount Type: Defines the types of values to include in a row or column. General Ledger provides numerous amount types, such as actual, end-of-day, average-to-date, budget, or encumbrance; or calculated amounts, such as variances, for single or multiple periods. The amount type is typically assigned to column definitions.
Notes:
If you enter a budget, encumbrance, or variance amount type, you should enter a Control Value to assign budgets and encumbrance types to the report definition.
Amount Type, Period Offset, Control Value, and Currency must all share the same column or row.
If you assign an amount type to a row or column, you must also assign an offset.
Suggestion: Use the amount type, YTD-Actual (FY End) to report on fiscal year-end actual balances. Calculate the offset in relation to your accounting calendar and enter the offset value in the Balance Control Region (for example, -12 for a 12 period calendar). Label the column directly (for example, June-1999) instead of using the Period of Interest (&POI) token. Re-use this column set definition indefinitely. Update the column label when your fiscal year changes.
Currency: To report translated account balances for a specific currency, enter the currency. If you want to report on amounts entered in a foreign currency rather than translated amounts, enter a control value number. Then when you define your report, assign the currency and a currency type of Entered to that control value number.
The currency you enter when you define or request a report serves as the default currency for columns without a currency in the column set definition.
Suggestion: For column sets, if you assign a different currency to each of your columns, put the currency code in each column heading so you can correctly identify the currencies on your report.
Control Value: Used to include budgets, encumbrance types, and currencies in a report.
Offset: Enter the relative Offset if you want to report on a period or effective date before or after your runtime period or effective date. If your specified Amount Type refers to a period, such as PTD-Actual, then the Offset will be in number of periods. However, if your specified Amount Type refers to days, such as PATD, then the Offset will be in number of days.
FSG determines the amounts to display based on the offset and the period or effective date you enter at runtime. For example, enter 0 (zero) to display amounts for the runtime effective date or enter -1 to display amounts one day before the runtime effective date.
Note: You must specify offsets at the same level (row or column) at which you specified amount types and control value numbers.
Notes:
If you enter a budget, encumbrance, or variance amount type, you should enter a Control Value to assign budgets and encumbrance types to the report definition.
Amount Type, Period Offset, Control Value, and Currency must all share the same column or row.
If you assign an amount type to a row or column, you must also assign an offset.
Suggestion: Use the amount type, YTD-Actual (FY End) to report on fiscal year-end actual balances. Calculate the offset in relation to your accounting calendar and enter the offset value in the Balance Control Region (for example, -12 for a 12 period calendar). Label the column directly (for example, June-1999) instead of using the Period of Interest (&POI) token. Re-use this column set definition indefinitely. Update the column label when your fiscal year changes.
Currency: To report translated account balances for a specific currency, enter the currency. If you want to report on amounts entered in a foreign currency rather than translated amounts, enter a control value number. Then when you define your report, assign the currency and a currency type of Entered to that control value number.
The currency you enter when you define or request a report serves as the default currency for columns without a currency in the column set definition.
Suggestion: For column sets, if you assign a different currency to each of your columns, put the currency code in each column heading so you can correctly identify the currencies on your report.
Control Value: Used to include budgets, encumbrance types, and currencies in a report.
Offset: Enter the relative Offset if you want to report on a period or effective date before or after your runtime period or effective date. If your specified Amount Type refers to a period, such as PTD-Actual, then the Offset will be in number of periods. However, if your specified Amount Type refers to days, such as PATD, then the Offset will be in number of days.
FSG determines the amounts to display based on the offset and the period or effective date you enter at runtime. For example, enter 0 (zero) to display amounts for the runtime effective date or enter -1 to display amounts one day before the runtime effective date.
Note: You must specify offsets at the same level (row or column) at which you specified amount types and control value numbers.
Comments
Post a Comment