Source / Basis
Select this tab.
The following fields appear in the Source Specifications area of the form.
- Data Selection
Enter the version of the Select F0902 Source/Basis program (R09123B) to use to select source data from the F0006, F0901, and F0902 tables.
- Rate Factor
Enter a number that identifies the index or rate for calculations. The system multiplies the source amounts by this factor to calculate the amounts to distribute. You can specify a positive or negative number and a maximum of eight decimal positions. If you specify more than eight decimal positions, the system rounds to eight positions.
If you specify a large whole number and many decimal positions, the system might not be able to display the entire number. Even though all decimal positions might not be displayed, the system stores up to eight positions correctly in the table.
Note: For annual budgets, you can enter 0 (zero) to remove all balances and start over.- Ledger Type
Enter a valid ledger type for the source records. If you leave this field blank, the system uses AA.
- Include Unit Ledger and Unit of Measure
Select the Include Unit Ledger check box to calculate units for the destination and offset journal entries. If you select this check box, you must enter a value from UDC table 00/UM in the Unit of Measure field.
- Period Basis
Select the date on which the allocation is based. Values for account balance-based allocations are:
Inception-to-date: The basis is the cumulative balance through the end of the month that you specify in the Special Period field. Inception-to-date allocations include prior month corrections and all postings from prior years.
Month-to-date: The basis is the net posting balance for the current month (fiscal period). Month-to-date allocations do not include prior month corrections in the allocation base.
Month-to-date – Different FY: The basis is the net posting balance for the current month (fiscal period) but the companies can be in different fiscal years, as long as the current fiscal year of the companies is one less, one more, or the same as the current fiscal year of the allocation company.
User specified date: The basis is the cumulative balance between and inclusive of the from and through dates as specified by the user. User-specified date includes the balances of months greater than or equal to the from date and less than or equal to the thru date specified in the processing options of the Compute Advanced Variable Numerator program (R09123).
Year-to-date: The basis is the period-end balance. For profit and loss accounts, this is the sum of all net postings for the year through the end of the month that you specify. For balance sheet accounts, this is the cumulative balance through the end of the month that you specify in the Special Period field. Year-to-date allocations include prior month corrections in the allocation base.
- Special Period/Year
The Special Period/Year fields appear only if the period basis is inception-to-date, month-to-date, or year-to-date.
Enter numbers to identify the general ledger period and year to use for based-on amounts. If you leave this field blank, the system uses the current period of the allocation company.
The Special Period/Year fields are hidden if the period basis is:
Month to Date – Different FY. The system uses the current period and current fiscal year of the selected companies. The current fiscal year of the selected companies should be the same, a year less, or a year more than the current fiscal year of the allocation company.
User Specified Date. The system uses the periods and years specified in the processing options for the Compute Advanced Variable Numerator Allocations program (R09123).
The following fields appear in the Basis Specifications area of the form.
- Data Selection
Enter the version of the Select F0902 Source/Basis program (R09123B) to use to select basis data and amounts from the F0006, F0901, and F0902 tables.
- Ratio
Enter the code from UDC table 09/RT that specifies the basis ratio to use for calculating the allocation. Values are:
00–50: Category codes 01–50
51: Business Unit
52: Related Business Unit
53: Business Unit Type
Codes 54–56: Burdening Transactions.
See Setting Up the Specifications for a Burdening-Based Allocation.
- Ledger Type
Enter a valid ledger type for the source records.
- Period Basis
Specify the date on which the allocation is based. Values are:
Inception-to-date: The basis is the cumulative balance through the end of the month that you specify in the Special Period field. Inception-to-date allocations include prior month corrections and all postings from prior years.
Month-to-date: The basis is the net posting balance for the month (fiscal period). Month-to-date allocations do not include prior month corrections in the allocation base.
Month-to-date – Different FY: The basis is the net posting balance for the current month (fiscal period) but the companies can be in different fiscal years, as long as the current fiscal year of the companies is one less, one more, or the same as the current fiscal year of the allocation company.
User specified date: The basis is the cumulative balance between and inclusive of the from and thru dates as specified by the user. User specified date includes the balances of months greater or equal to the from date and less than or equal to the thru date specified in the processing options of the Compute Advanced Variable Numerator program (R09123).
Year-to-date: The basis is the period-end balance. For profit and loss accounts, this is the sum of all net postings for the year through the end of the month that you specify. For balance sheet accounts, this is the cumulative balance through the end of the month that you specify in the Special Period field. Year-to-date allocations include prior month corrections in the allocation base.
- Special Period/Year
Enter numbers to identify the general ledger period and year to use for based-on amounts. If you leave this field blank, the system uses the current period of the company that you specified.