Use this subtask to specify the base accounts, debit allocation accounts, and variance accounts/organizations for a given cost pool. A base account/ organization combination must be attached to an allocation account/ organization combination. The Base account/organization specifies where the specific amount or hours that form the denominator of the pool reside. The allocation account/organization specifies where the allocation amounts that result from the pool calculation will reside. The allocation amount that will be transferred for each base account/organization combination is calculated as follows:
COST ACCOUNT/ORG (AMOUNT)
Rate = - - - - - - - - - - - - - - - - - - - - - - - - - - -
BASE ACCOUNTS/ORGS (AMOUNT or HOURS or UNITS)
Rate * INDIVIDUAL BASE ACCOUNT/ORG = ORG ALLOCATION AMOUNT
You can set up variance account/organization combinations at the pool level using the Default Accounts subtask, or you can use this subtask to set them up separately for each allocation account/organization. Variance account/organization combinations specify where the difference between allocation amounts at actual rates versus those at target rates will be posted.
Use this subtask when initializing a cost pool or service center. For service centers whose calculation method is manual (rather than automatic), no entry of base accounts is required here; (use the Maintain Allocation Journal screen (Projects » Cost and Revenue Processing » Cost Pool Processing & Reporting) instead). After you initialize base accounts, you will use this screen only to make changes. You can expedite the setup of your base accounts using the Base Creation Setup screen (Projects » Cost and Revenue Processing » Cost Pool Setup) and the Create Pool Links screen (Projects » Cost and Revenue Processing » Cost Pool Setup). See the documentation for those screens for more information on these processes.
This non-editable field displays the allocation group number from the main screen.
This non-editable field displays the pool number from the main screen. The adjacent field displays the name of the pool.
This non-editable field displays the fiscal year from the main screen. You can modify the data (including base/allocation/variance account/organization combinations) for a given cost pool each fiscal year.
Click the Subquery button to populate this table. You can combine multiple select statements by selecting the And/Or options, then clicking Add to update your subquery. To display the number of rows in your new result set, click the Count button. To update the Account/Organization table window, click OK. The Subquery function will close and return you to the populated Account/Organization table window.
This column displays the accounts you selected using Subquery. These accounts, in combination with the selected organizations, must be active for the Fiscal Year displayed.
This column displays organizations you selected using Subquery. These organizations, in combination with the selected accounts, must be active for the Fiscal Year displayed.
This non-editable column displays the name of the account displayed in the Account column.
This non-editable column displays the name of the organization shown in the Organization column.
To select an account/organization from the table, click the Select button while highlighting the account/organization that you want to add. The account/organization will display in the pool base account/organization table located in the right half of the screen.
To remove an account/organization from the pool base account/organization table, click the Deselect button while highlighting the account/organization that you want to delete.
Use the Select and Deselect buttons to populate this table.
Click the Select button to add accounts to this column. These accounts, with the selected base organizations, will form the base portion of the pool displayed, and must be active for the Fiscal Year displayed.
This column displays organizations linked to accounts selected in the Base Account column. These organizations, with the selected base accounts, will form the base portion of the pool displayed, and must be active for the Fiscal Year displayed.
Enter, or use to select, the allocation account. These accounts will form the account part of the recipient account/organization combination that receives the allocated amounts for each of their respective base account/organizations. All accounts selected must be active for the Fiscal Year displayed. Allocation accounts cannot include accounts that have the Project Required check box selected in the Maintain Accounts screen (Accounting » General Ledger » Accounts). The default allocation debit account from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the allocation organization. These organizations will form the organization part of the recipient account/organization combination that receives the allocated amounts for each of the respective base account/organizations. All organizations selected must be active for the Fiscal Year displayed. The default allocation debit organization from the Default Accounts subtask will initially display in this screen, where you can edit it.
This column displays the name for the base organization.
This column displays the name for the base account.
Enter, or use to select, the allocation reference 1. These reference numbers will receive the allocation portion for each of the respective base account/organizations. You should initialize Reference 1 in this screen only if reference numbers are used in data entry. The default allocation reference 1 account from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the allocation reference 2. These reference numbers will receive the allocation portion for each of the respective base account/organizations. You should initialize Reference 2 in this screen only if reference numbers are used in data entry. The default allocation reference 2 from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the cost variance account. These accounts will form the account part of the account/organization combination that is used to post the difference between actual and target rates to the Income Statement for each of the respective base account/organizations. All accounts selected must be active for the Fiscal Year displayed. Cost variance accounts cannot include accounts that have the Project Required check box selected in the Maintain Accounts screen (Accounting » General Ledger » Accounts). The default cost variance account from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the cost variance organization. These organizations will form the organization part of the account/organization combination that is used to post the difference between actual and target rates to the Income Statement for each of the respective base account/organizations. All organizations selected must be active for the Fiscal Year displayed. The default cost variance organization from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the cost variance reference 1. These reference numbers will receive the cost variance portion for each of the respective base account/organizations. You should initialize Reference 1 only if reference numbers are used in data entry. The default cost variance reference 1 from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the cost variance reference 2. These reference numbers will receive the cost variance portion for each of the respective base account/organizations. You should initialize Reference 2 only if reference numbers are used in data entry. The default cost variance reference 2 from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the receivable variance account. These accounts will form the account part of the account/organization combination that is used to post the difference between actual and target rates to the Balance Sheet (Unbilled Receivables) for each of the respective base account/organizations. All accounts selected must be active for the Fiscal Year displayed. Receivable variance accounts cannot include accounts that have the Project Required check box selected in the Maintain Accounts screen (Accounting » General Ledger » Accounts). The default receivables variance account from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the receivable variance organization. These organizations will form the organization part of the account/organization combination that is used to post the difference between actual and target rates to the Balance Sheet (Unbilled Receivables) for each of the respective base account/organizations. All organizations selected must be active for the Fiscal Year displayed. The default receivable variance organization from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the receivable variance reference 1. These reference numbers will receive the receivable variance portion for each of the respective base account/organizations. Reference 1 should be initialized only if reference numbers are used in data entry. The default receivable variance reference 1 from the Default Accounts subtask will initially display in this screen, where you can edit it.
Enter, or use to select, the receivable variance reference 2. These reference numbers will receive the receivable variance portion for each of the respective base account/organizations. Reference 2 should be initialized only if reference numbers are used in data entry. The default receivable variance reference 2 from the Default Accounts subtask will initially display in this screen, where you can edit it.