Use this subtask to link the cost, hours, units, burden, cost of money, and fee information to each of the billing lines. In order for the billing program to know how to summarize the detail data, you must identify the account(s) and, optionally, the organization(s) that belong to each line.
This field displays the selected billing format code from the main screen. The description displays in the untitled field to the right.
This non-editable field displays the selected line type that was entered on the main screen.
This non-editable field displays the selected group heading that was entered on the main screen.
This non-editable field displays the selected line heading that was entered on the main screen
In filling in the lines for this subtask, keep in mind that the less data you enter on a row, the more data will be included on the related line on the bill. For example, if you want a line on the bill to include all direct labor, fill in the direct labor account number(s), leave everything else blank, and set the Fee? field to "No." Refer to the Processing Information section for more details.
Enter, or use to select, the general ledger account number(s) that should be linked to this line on the bill. If you leave this column blank but fill in other columns on a row, all accounts will be used for that row.
If you fill out the Account column only, the program will summarize the costs or hours or units that relate to that account. Note that if you do not select an Organization for an Account, you cannot select one for the same Account for the remaining lines.
See the Processing Information section for more information on how this field works in combination with other fields on this screen.
Enter, or use to select, the organization(s) that should be linked to the selected account(s) for this line on the bill. You can also leave this field blank to specify all organizations, if other columns on the row are filled. Note that if you do not select an Organization for an Account, you cannot select one for the same Account for the remaining lines.
See the Processing Information section for more information on how this field works in combination with other fields on this screen.
Enter, or use to select, a fiscal year to link to the selected billing line. This field is used in combination with the Pool and COM Pool? fields to specify burden and cost of money amounts. If you enter a fiscal year, you must update the format at the beginning of each year to include the Pool and COM amounts for the new fiscal year. If you leave the Fiscal Year blank, all fiscal years will be included.
See the Processing Information section for more information on how this field works in combination with other fields on this screen.
Enter the number of the pool whose burden and/or cost of money is to be included for this line. This field is used in combination with the Fiscal Year and COM Pool? fields.
See the Processing Information section for more information on how this field works in combination with other fields on this screen.
Enter Y (Yes) or N (No) to indicate whether or not facilities capital cost of money should be calculated for the specified account, org, etc. This field is used in combination with the Pool and Fiscal Year fields.
See the Processing Information section for more information on how this field works in combination with other fields on this screen.
Enter Y (Yes) or N (No) to indicate whether or not fee should be calculated for the specified Account, Organization, etc. See the Processing Information section for more information on how this field works in combination with other fields on this screen.
The fields in this table window work with each other to link cost, hours, units, burden, cost of money, and fee information to each of the billing lines from the main screen. As mentioned above, this subtask uses a "less is more" approach; the less information you provide on a given line in this table window, the more billing data that line represents. For example, if you fill in the Account field, but leave Organization and all other fields blank, all organizations' costs (or hours or units) for the specified account will be summed for the selected billing line. If you fill in both the Account and Organization fields, only the selected account/org combination's cost/hours/units will be included. The following field combinations will provide the following outcomes on your bill:
If you fill out the account and enter Y in the Fee? field, the program will calculate and print the fee related to the cost of the account.
If you fill out the account, fiscal year, and pool, the program will compute and print the pool burden that relates to that account for that fiscal year and pool.
If you fill out the account, fiscal year, and pool, and enter Y in the Com Pool? field, the program will calculate and print only the cost of money burden related to that account, pool, and fiscal year.
If you fill out the account, fiscal year, and pool, and enter Y in the Fee? field, the program will compute and print only the fee on the burden related to that account and pool and fiscal year.
If you fill out the Account and Organization columns only, the program will retrieve the cost (or hours or units) from that account/organization combination.
If you fill out the Account, Organization, Fiscal Year, and Pool, the program will retrieve the pool burden amount that relates to that account and organization for that fiscal year and pool.
If you fill out the Account, Organization, Fiscal Year, and Pool, and enter Y in the Com Pool? field then the program will retrieve only the cost of money burden related to that account, organization, pool, and fiscal year.
If you fill out the Account, Organization, Fiscal Year, and Pool, and enter Y in the Fee? field, the program will calculate only the fee on the burden related to that account, organization, pool, and fiscal year.
If you fill out the Account and Organization, and enter Y in the Fee? field, the program will locate the fee related to the cost of the account and organization.
If you fill out only the Fiscal Year and Pool, the program will calculate and print all account/organization burden for that pool for that fiscal year. Note that if you do not identify the account/organization for a fiscal year and pool on one line, you cannot identify an account/organization for that same pool on any other lines.
If you fill out only the Fiscal Year and Pool, and enter Y in the Com Pool? Field, the program will retrieve only the cost of money related to that pool and fiscal year for all accounts and organizations. Note that if you do not identify the account/organization for a fiscal year and pool on one line, you cannot identify an account/organization for that same pool on any other lines.
If you fill out the Fiscal Year and Pool, and enter Y in the Fee? field, the program will calculate only the fee related to that pool and fiscal year for all accounts and organizations. Note that if you do not identify the account/organization for a fiscal year and pool on one line, you cannot identify an account/organization for that same pool on any other lines.
If you charge an account that is NOT mapped to the billing format, a line will appear on your bill labeled "Other. A quick way to identify what makes up the "Other" line is to highlight the "Other" line in the Edit Standard Bills screen ("Other" will be display in the Group Description and Line Description fields) and open the Detail subtask. All transactions that make up the "Other" line will be shown in this subtask, and you can then analyze which changes need to be made to the format. The amounts included in the "Other" line may not have been linked properly to a line in the Accounts subtask.
For a line to include all direct labor: Fill in the direct labor account number, leave everything else blank, and select N in the Fee? field.
If you want a line which includes only direct labor for only organization "1.1": Fill in the direct labor account, fill in organization "1.1," leave the pool information blank, and select N in the Fee? field.
For a line including all direct labor, plus burden: Fill in the first row with the direct labor account, leave the rest of the row blank, and set Fee to N. Then, fill in the next row of the table with the direct labor account, fill in the Fiscal Year, Pool, and COM ? fields, and select N in the Fee? field.
To add a line with all direct labor, plus burden, plus fee: Start with the same two rows as in the previous example, and add another two rows. On the first additional row, fill in the account, leave the rest of the fields blank, and set Fee to Y. On the second additional row fill in the Account, Fiscal Year, Pool, and COM ? fields, and select Y in the Fee? field.
Changes to this screen update the BILL_FRMT_LN_ACCT table.