The detail tab is the second of the two Path File Maintenance tabs. This tab serves several functions:
· Allows you to assign profit centers to a consolidation path.
· Establish the various levels within the path by assigning each profit center to a parent profit center.
· Specify the Allocate From and To General Ledger accounts.
· Specify the Allocation weight for distributing overhead to a profit center.
ExecuTrak automatically displays the Consolidation Path you specified on the header tab. Enter the following information to add a profit center to the path.
When assigning profit centers to a consolidation path, you must work from the top most level in the hierarchy (company wide profit center) down to the lowest level in the hierarchy. This method of assigning profit centers is necessary because in order to assign a parent profit center, it must be part of the consolidation path.
Profit Center Edit Box--Specify the profit center to add to this consolidation path. Enter the profit center number or use the search procedure to display a list of available profit centers that match the criteria in the Profit Center Code and/or Description Edit boxes. In Add mode, Available profit centers include only those not assigned to this consolidation path. In Edit mode, available profit centers include only those assigned to this consolidation path. When you enter a valid profit center, ExecuTrak automatically displays the profit center description.
To add a new profit center, click the AddProfitCenterbutton on the toolbar or right click the ProfitCenteror Description edit boxes and select AddProfitCenterfrom the popup menu. You can also select AddProfitCenterfrom the Options menu.
Profit Center Search Button--Press this button to activate the search procedure and display a list of available profit centers that match the criteria in the Profit Center Code and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available profit centers. In Add mode, available profit centers include only those not previously assigned to this consolidation path. In Edit mode, available profit centers include only those assigned to this consolidation path. This button orders the list by profit center number.
Profit Center Description Edit Box--When you enter a valid number in the profit center edit box, ExecuTrak automatically displays the profit center description. If you don't remember a profit center number, you can use this field to locate the profit center by description. Enter the profit center description or use the search procedure to display a list of available profit centers that match the criteria in the Profit Center Code and/or Description edit boxes. In Add mode, available profit centers include only those not assigned to this consolidation path. In Edit mode, available profit centers include only those assigned to this consolidation path.
To add a new profit center, click the AddProfitCenterbutton on the toolbar or right click the ProfitCenteror Description edit boxes and select AddProfitCenterfrom the popup menu. You can also select AddProfitCenterfrom the Options menu.
Profit Center Description Search Button--Press this button to activate the search procedure and display a list of available profit centers that match the criteria in the Profit Center Code and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available profit centers. In Add mode, available profit centers include only those not previously assigned to this consolidation path. In Edit mode, available profit centers include only those assigned to this consolidation path. This button orders the list by profit center description.
Parent Profit Center Edit Box--Specify the profit center to serve as the parent to the profit center you specified in the previous field. In Edit mode, ExecuTrak automatically displays the previously assigned parent profit center but allows you to change it. In Add mode, enter the profit center number or use the search procedure to display a list of available profit centers that match the criteria in the Parent Profit Center Code and/or Description edit boxes. Available profit centers include only those assigned to this consolidation path. When you enter a valid profit center number, ExecuTrak automatically displays the profit center description.
To add a new profit center, click the {bmcAdvf0002.BMP} (Add Profit Center) button on the toolbar or right click the Profit Center or Description edit boxes and select Add Profit Center from the popup menu. You can also select AddProfitCenterfrom the Options menu.
Parent Profit Center Search Button--Press this button to activate the search procedure and display a list of available profit centers that match the criteria in the Parent Profit Center Code and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available profit centers. Available profit centers include only those previously assigned to this consolidation path. This button orders the list by profit center description.
Parent Profit Center Description Edit Box--In Edit mode, ExecuTrak automatically displays the parent profit center when you enter a valid profit center. You can change the parent if necessary. In Add mode, ExecuTrak displays the parent description when you enter a valid parent profit center code. If you don't remember a profit center number, you can use this field to locate the profit center by description. Enter the profit center description or use the search procedure to display a list of available profit centers that match the criteria in the Parent Profit Center Code and/or description edit boxes.
To add a new profit center, click the AddProfitCenterbutton on the toolbar or right click the ProfitCenteror Description edit boxes and select AddProfitCenterfrom the popup menu. You can also select AddProfitCenterfrom the Options menu.
Parent Profit Center Description Search Button--Press this button to activate the search procedure and display a list of available profit centers that match the criteria in the Parent Profit Center Code and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available profit centers. Available profit centers include only those previously assigned to this consolidation path. This button orders the list by profit center description.
Allocate From GL Account Edit Box--Identify the general ledger account to credit for overhead distribution for this profit center. Enter the account number or use the search procedure to display a list of available general ledger accounts that match the criteria in the Allocate From GL Account Number and/or Description edit boxes. When you enter a valid account number, ExecuTrak automatically displays the account description.
To add a new general ledger account, click the Add General Ledger Account button on the toolbar or right click the Allocate From/To GL Account or Description edit boxes and select Add General Ledger Account from the popup menu. You can also select Add GL Account from the Options menu.
Allocate From GL Account Search Button--Press this button to activate the search procedure and display a list of general ledger accounts that match the criteria in the Allocate From GL Account Number and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available GL accounts for the identified profit center. This button orders the list by account number.
Allocate From GL Account Description Edit Box--When you enter a valid number in the Allocate From GL Account Number edit box, ExecuTrak automatically displays the account description. If you don't remember an account number, you can use this field to locate the account by description. Enter the account description or use the search procedure to display a list of GL accounts that match the criteria in the Allocate From GL Account Number and/or Description edit boxes.
To add a new general ledger account, click the Add General Ledger Account button on the toolbar or right click the Allocate From/To Gl Account or Description edit boxes and select Add General Ledger Account from the popup menu. You can also select Add GL Account from the Options menu.
Allocate From GL Account Description Search Button--Press this button to activate the search procedure and display a list of general ledger accounts that match the criteria in the Allocate From GL Account Number and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available GL accounts for the identified profit center. This button orders the list by account description.
Allocate To GL Account Edit Box--Identify the general ledger account to debit for overhead distribution. Use different account numbers for the different levels in the consolidation path. This will help ensure an adequate audit trail. Enter the account number or use the search procedure to display a list of general ledger accounts that match the criteria in the Allocate To GL Account Number and/or Description edit boxes. When you enter a valid account number, ExecuTrak automatically displays the account description.
To add a new general ledger account, click the Add General Ledger Account button on the toolbar or right click the Allocate From/To Gl Account or Description edit boxes and select Add General Ledger Account from the popup menu. You can also select Add GL Account from the Options menu.
Allocate To GL Account Search Button--Press this button to activate the search procedure and display a list of general ledger accounts that match the criteria in the Allocate From GL Account Number and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available GL accounts for the identified profit center. This button orders the list by account number.
Allocate To GL Account Description Edit Box--When you enter a valid number in the Allocate to GL Account Number edit box, ExecuTrak automatically displays the account description. If you don't remember an account number, you can use this field to locate the account by description. Enter the account description or use the search procedure to display a list of GL accounts that match the criteria in the Allocate To GL Account Number and/or Description edit boxes.
To add a new general ledger account, click the Add General Ledger Account button on the toolbar or right click the Allocate From/To GL Account or Description edit boxes and select Add General Ledger Account from the popup menu. You can also select Add GL Account from the Options menu.
Allocate To GL Account Description Search Button--Press this button to activate the search procedure and display a list of general ledger accounts that match the criteria in the Allocate To GL Account Number and/or Description edit boxes. If you enter no criteria in the edit boxes and press this button, the list displays all available GL accounts for the identified profit center. This button orders the list by account description.
Allocation Weight Edit Box--The allocation weight tells the system what percentage will be distributed to each ProfitCenter below a designated "Parent" profit center.
With the direct method of distributing overhead, the Allocation weight determines the percentage of overhead distributed to each profit center. ExecuTrak will take one level at a time and total the allocation weights entered for all profit centers at that level. In order to compute the percentage of allocation that each profit center will receive, the system takes the allocation weight entered for each individual profit center on that level and divides it by the total of the allocation weights for that level. Review the following examples.
Continue Allocation Radio Buttons--Select one of the two following radio buttons.
· Yes Radio Button--You will normally select the Yes radio button. When you select "Yes," the system allows overhead to be distributed from the profit center.
· No Radio Button--Select the No radio button to prevent overhead from being distributed from this profit center. This selection does not prevent overhead from being distributed to the profit center.
Miscellaneous Amount 1 Edit Box--An entry in this field is optional and used only for your information. The Advanced Financial Reporting Paths report will print the Miscellaneous Amount 1 if you specify in the criteria for it to print. You can enter up to 16 digits in this field.
Miscellaneous Text 1 Edit Box--An entry in this field is optional and used only for your information. The Advanced Financial Reporting Paths report will print the Miscellaneous Text 1 if you specify in the criteria for it to print. You can enter up to 30 alpha-numeric characters.
Miscellaneous Amount 2 Edit Box--An entry in this field is optional and used only for your information. You can enter up to 16 digits in this field.
Miscellaneous Text 2 Edit Box--An entry in this field is optional and used only for your information. You can enter up to 30 alpha-numeric characters.
Continuous Add/Edit Mode Check Box-- Select this check box to Add or Edit multiple profit centers for this consolidation path.