To look up the charge information for a timesheet row when your system is set up to prove charge lookup directly from Costpoint, click the Lookup icon in the primary charge field or in the charge description field. Depending on how your system is set up, the primary charge field can be either UDT01 or UDT02.
If UDT02 and UDT01 are not linked, UDT01 is the primary charge field.
If UDT02 and UDT01 are linked, UDT02 is the primary charge field.
When you click , the Charge Lookup dialog box opens. In that dialog box, you drill down through the lookup levels until you reach the correct primary charge code, or you can set up a filter to generate a list of charges.
Once you have selected a primary charge code for the timesheet row, you then click in the other charge fields for the row. In those cases, you look up the specific codes using the Simple Lookup dialog box. If you need help doing simple lookups, see Timesheet Simple Lookups.
When you add a Costpoint charge to a timesheet, the system also checks to see if a corresponding UDT code exists in Time & Expense with ESS. If it does not, it is added automatically.
To look up the charge information for an expense report or expense authorization charge allocation when your system is set up to prove charge lookup directly from Costpoint, select either UDT01 or UDT02 in Charge Type and then click in the Charge column.
When you click , the Charge Lookup dialog box opens. In that dialog box, you drill down through the lookup levels until you reach the correct charge code, or you can set up a filter to generate a list of charges.
When you add a Costpoint charge to an expense report or expense authorization, the system also checks to see if a corresponding UDT code exists in Time & Expense with ESS. If it does not, it is added automatically.
The Charge Lookup dialog box contains one or more of these tabs:
Favorites
Projects
Accounts
MOs
Which of these tabs is available to you depends on settings for the timesheet class or for the expense class of the employee for whom you are entering the timesheet, expense report, or expense authorization. It also depends on which type of data you initiate the lookup for:
If you initiate the lookup for UDT02, the Accounts tab is not available.
If you initiate the lookup for UDT01, the Projects and MOs tabs are not available.
If you initiate the lookup for Charge Description, all tabs are available.
Each tab contains a table that displays either the results of your filter, if you applied one, or the results of your last drill-down action.
On the Projects, Accounts, and MOs tabs, you can look up charges by drilling down through a hierarchy of levels. As you drill down, Time & Expense with ESS displays your current level and the levels above it in the Charge Navigation group box. This provides two benefits:
It provides a map of how you arrived at the charges you are looking up.
Each of the levels is a link. You can quickly backtrack to a higher level by clicking the corresponding link.
Use the Favorites tab to select a charge from among the favorites that you have set up or that have been assigned to you through your employee group. When you initiate a lookup for UDT01, any favorites that include a UDT01 but no UDT02 appear in the table on this tab. When you initiate a lookup for UDT02, any favorites that include a UDT02 appear.
To select one of your favorites for the timesheet, expense report, or expense authorization, select the check box in the first column for that row. When you have done this for all of the favorites you want to select, click the Add to Timesheet button, Add to Expense Report button, or Add to Expense Authorization button.
To add a new favorite, you can do any of the following:
Display the charge on one of the other tabs in the Charge Lookup dialog box, select the check box next to it, and click Add to Favorites.
In the Timesheet screen itself, display a timesheet that includes the charge, select the check box for that timesheet row, and click the Add Line to Favorites option above the time entry table.
In the Expense Report screen or Expense Authorization screen, select an expense report or expense authorization that includes the charge in the list of charge allocations, go to the page of the wizard that shows the charge allocations, select the check box for the charge, and click the Add Line to Favorites option above the charge allocation table.
To filter your list of favorites, select the type of information you want to filter by in Filter By.
You can filter by UDT02, UDT01, or charge description.
If you want to filter your list of favorites, select the type of information you want to filter by in Filter By, enter all or part of the ID or description you want to locate in Value, and click Apply. The list of favorites is then restricted to only those that fit the filter criteria.
If you enter a partial ID or description, you can do either of the following:
To view all valid favorites for which the UDT02 ID, UDT01 ID, or description begins with a specific string of characters, enter those characters in Value. (For example, if you enter 10, the results list would include 1000 and 1010, but not 0100.)
To view all valid favorites for which the UDT02 ID, UDT01 ID, or description contains a specific string of characters in any position, enter a percent sign (%) followed by those characters in Value. (For example, if you enter %10, the results list would include 1000, 0100, 1010.)
Time & Expense with ESS may be set up to require a minimum number of characters in filter values. If you do not enter enough characters, a message prompts you to enter more. The minimum number may vary depending on your selection in Filter By.
Click Apply to display the list of favorites that meet your filter criteria.
If your list of favorites includes some that you do not use, and you do not want to delete them or you cannot delete them because they are assigned to you through your employee group, you can still remove them from the displayed list. To do that, select Hide for each of them and then click Update.
This only hides the favorite. It does not remove it. To return the favorite to the displayed list, select the Show Hidden check box below the table, clear the Hide check box for that favorite, and click Update.
If you want certain favorites to be added automatically to each new timesheet, expense report, or expense authorization you create, select the Load check box for each of them and click Update.
If you no longer want a favorite to appear automatically in new timesheets, expense reports, or expense authorizations, clear Load and click Update.
If you are using the option to generate timesheets with default hours for some employees, the system uses the percentage in Work % to determine the hours assigned to the charge codes. If your timesheet class is not set up to generate timesheets with default hours, the table does not contain a Work % column.
If you are assigned to a timesheet class for which Generate Exception-Based Timesheets is checked in the Timesheet Classes screen, you must supply a work percentage in Work % for each favorite, and the percentages for all favorites must total 100 percent. Enter the percentages as whole numbers, 0 to 100. Click Update to save your entries.
If do not check one Holiday and one Vacation check box or the total for Work Pct does not equal 100 percent, the system displays the following warning when you click Update: "If you plan to have the system generate exception-based timesheets for you, you will need to distribute 100% of your work percentage and indicate your vacation and holiday charges in this dialog."
Select the Leave check box if the charge is for scheduled leave time. Click Update to save the selection.
If your timesheet class is set up to automatically enter holiday and scheduled leave hours when loading favorites, you must have one and only one favorite designated as a leave charge. If your timesheet class is not set up to enter holiday and leave automatically when loading favorites, the table does not contain a Leave column.
Select the Holiday check box if the favorite is for holiday time. Click Update to save the selection.
If your timesheet class is set up to automatically enter holiday and scheduled leave hours when loading favorites, you must have one and only one favorite designated as a holiday charge. If your timesheet class is not set up to enter holiday and leave automatically when loading favorites, the table does not contain a Holiday column.
Charge Description displays the description assigned to the favorite.
The remaining columns in the favorites table show the other UDT codes making up the charge.
If your system is configured for Costpoint multicompanies and you are using UDT06s and UDT07s, additional columns show Costpoint company information.
If you have hidden some of your favorites using the Hide check box, you can select Show Hidden if you want to see them again.
If hidden favorites are visible, clearing Show Hidden hides them again.
If the total number of rows in the database exceeds the maximum number of rows that can be displayed in lookup dialog boxes (as specified in the General Configuration screen), the Next button is enabled. Click that button to display the next set of rows.
Use the Previous button to return to previously displayed sets of rows.
Click the Update button after making changes to Hide, Load, Work %, Holiday, or Leave to save those changes.
If you have selected the Generate Exception-Based Timesheets check box in the Timesheet Classes screen for the employee's timesheet class, and the Work % column does not equal 100% or you have not selected a holiday and vacation charge (or have selected more than one holiday and/or vacation charge), the system displays the following warning: "If you plan to have the system generate exception-based timesheets for you, you will need to distribute 100% of your work percentage and indicate your vacation and holiday charges in this dialog."
If the Generate Exception-Based Timesheets check box is not selected, you still need to specify your vacation and holiday charges. If you do not, or specify more than one, the system displays the following warning: "To ensure that holidays and vacations are properly edited and defaulted, please indicate which charge is your holiday charge and which is your vacation charge."
To select favorites for the current timesheet, select the check box next to each one in the table and then click Add to Timesheet. The Charge Lookup dialog will close.
To select a favorite for the current expense report or expense authorization, select the check box for that favorite in the table and then click Add to Expense Report or Add to Expense Authorization.
If you select a charge that is no longer authorized for the employee in Costpoint, the system displays a warning message, and that charge is not added. If you selected more than one favorite, authorized charges are added but unauthorized charges are not.
To remove one or more rows from your favorites, select the check box for each of the rows and click Delete from Favorites.
If you try to remove a favorite that you inherited from an employee group, you cannot delete it. In that case, Time & Expense with ESS displays a message to explain the situation and then checks the Hide check box for the favorite. If you then click Update, that favorite is hidden from view but is still assigned to you.
Click Close to close the Charge Lookup dialog box.
If you are looking up UDT02 charges, you can use the Projects tab to look up charges by UDT02. You can do either of the following:
Use the table to drill down to the charge.
Use the filter options to display a list of charges based on the parameters you enter under Filter.
When you locate the charge you want, select the check box in the first column for that row and click the Add to Timesheet button, Add to Expense Report button, or Add to Expense Authorization button.
To display a list of charges based on UDT02 ID or UDT02 description, select ID or Description in Filter By.
If you want to display a list of charges based on UDT02 ID or description, select the type of information you want to filter by in Filter By, enter all or part of the ID or description for which you want to locate charges in Value, and click Apply. The list of charges that fit the filter criteria appear in the table.
If you enter a partial ID or description, you can do either of the following:
To view all valid charges for UDT02s for which the ID or description begins with a specific string of characters, enter those characters in Value. (For example, if you enter 10, the results list would include 1000 and 1010, but not 0100.)
To view all valid charges for UDT02s for which the ID or description contains a specific string of characters in any position, enter a percent sign (%) followed by those characters in Value. (For example, if you enter %10, the results list would include 1000, 1010, and 0100.)
Time & Expense with ESS may be set up to require a minimum number of characters in filter values. If you do not enter enough characters, a message prompts you to enter more. The minimum number may vary depending on your selection in Filter By.
If you want to display a list of charges based on UDT02 ID or description, make a selection in Filter By, enter the search text in Value, and click Apply.
If you enter filter parameters and click Apply, the table displays a row for each of the available charges for the UDT02s selected by your filter. To add one or more of the charges to your timesheet, expense report, or expense authorization, select the check box for the row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
If you do not use a filter, the table contains a row for each sublevel or charge available at the current drill-down level. (The current drill-down level is displayed above the table.) A drill-down level has a plus sign (+) in the first table column, and a charge has a check box. To drill down to a lower level, click the plus sign for that row. To add one of the charges to your timesheet, expense report, or expense authorization, select the check box for the charge row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
You can select multiple rows if you are adding charges to a timesheet.
To add one or more of the charges to your favorites, use a filter or drill down to display the charges, select the check box for each charge row you want to add, and then click Add to Favorites.
If the total number of rows in the database exceeds the maximum number of rows that can be displayed in lookup dialog boxes (as specified in the General Configuration screen), the Next button is enabled. Click that button to display the next set of rows.
Use the Previous button to return to previously displayed sets of rows.
To add one or more of the charges displayed in the table to your timesheet, select the check box for each row you want to add and then click Add to Timesheet.
To add a charge displayed in the table to your expense report or expense authorization, select the check box for the row you want to add and then click Add to Expense Report, or Add to Expense Authorization. (For expense reports and expense authorizations, you can only add one charge at a time.)
If you select a charge that is no longer authorized for the employee in Costpoint, the system displays a warning message, and that charge is not added. If you selected more than one charge, authorized charges are added but unauthorized charges are not.
To select favorites for the current timesheet, expense report, or expense authorization, select the check box next to each one in the table and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization. The Charge Lookup dialog will close.
If you select a charge that is no longer authorized, the system displays the following warning message: Warning, you are unauthorized for one or more charges selected."
To add one or more of the charges to your favorites, use a filter or drill down to display the charges, select the check box for each row you want to add, and then click Add to Favorites.
Click Close to close the Charge Lookup dialog box.
If you are looking up UDT02 charges, you can use the MOs tab to look up charges by manufacturing order (MO). You can do either of the following:
Use the table to drill down to the charge.
Use the filter options to display a list of charges based on the parameters you enter under Filter.
When you locate the charge you want, select the check box in the first column for that row and click the Add to Timesheet button, Add to Expense Report button, or Add to Expense Authorization button.
To display a list of charges based on MO ID or MO description, select ID or Description in Filter By.
If you want to display a list of charges based on MO ID or description, select the type of information you want to filter by in Filter By, enter all or part of the ID or description for which you want to locate charges in Value, and click Apply. The list of charges that fits the filter criteria appears in the table.
If you enter a partial ID or description, you can do either of the following:
To view all valid charges for MOs for which the ID or description begins with a specific string of characters, enter those characters in Value. (For example, if you enter 10, the results list would include 1000 and 1010, but not 0100.)
To view all valid charges for MOs for which the ID or description contains a specific string of characters in any position, enter a percent sign (%) followed by those characters in Value. (For example, if you enter %10, the results list would include 1000, 1010, and 0100.)
Time & Expense with ESS may be set up to require a minimum number of characters in filter values. If you do not enter enough characters, a message prompts you to enter more. The minimum number may vary depending on your selection in Filter By.
To display a list of charges based on MO ID or description, make a selection in Filter By, enter the search text in Value, and click Apply.
If you enter filter parameters and click Apply, the table displays a row for each of the available charges for the MOs selected by your filter. To add one of the charges to your timesheet, expense report, or expense authorization, select the check box for the row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
If you do not use a filter, the table contains a row for each sublevel or charge available at the current drill-down level. (The current drill-down level is displayed above the grid.) A drill-down level has a plus sign (+) in the first table column, and a charge has a check box. To drill down to a lower level, click the plus sign for that row. To add one of the charges to your timesheet, expense report, or expense authorization, select the check box for the charge row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
You can select multiple rows if you are adding charges to a timesheet.
To add one or more of the charges to your favorites, use a filter or drill down to display the charges, select the check box for each charge row you want to add, and then click Add to Favorites.
If the total number of rows in the database exceeds the maximum number of rows that can be displayed in lookup dialog boxes (as specified in the General Configuration screen), the Next button is enabled. Click that button to display the next set of rows.
Use the Previous button to return to previously displayed sets of rows.
To add one or more of the charges displayed in the table to your timesheet, select the check box for each row you want to add and then click Add to Timesheet.
To add a charge displayed in the table to your expense report or expense authorization, select the check box for the row you want to add and then click Add to Expense Report, or Add to Expense Authorization. (For expense reports and expense authorizations, you can only add one charge at a time.)
If you select a charge that is no longer authorized for the employee in Costpoint, the system displays a warning message, and that charge is not added. If you selected more than one charge, authorized charges are added but unauthorized charges are not.
To select favorites for the current timesheet, expense report, or expense authorization, select the check box next to each one in the table and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization. The Charge Lookup dialog will close.
If you select a charge that is no longer authorized, the system displays the following warning message: "Warning, you are unauthorized for one or more charges selected."
To add one or more of the charges to your favorites, use a filter or drill down to display the charges, select the check box for each row you want to add, and then click Add to Favorites.
Click Close to close the Charge Lookup dialog box.
If you are looking up UDT01 charges, you can use the Accounts tab to look up charges for UDT01s that do not require UDT02s. You can do either of the following:
Use the table to drill down to the charge.
Use the filter options to display a list of charges based on the parameters you enter under Filter.
When you locate the charge you want, select the check box in the first column for that row and click the Add to Timesheet button, Add to Expense Report button, or Add to Expense Authorization button.
To display a list of charges based on UDT01 or UDT01 description, select ID or Description in Filter By.
If you want to display a list of charges based on UDT01 ID or UDT01 description, select the type of information you want to filter by in Filter By, enter all or part of the code or description for which you want to locate charges in Value, and click Apply. The list of charges that fit the filter criteria appears in the table.
If you enter a partial ID or description, you can do either of the following:
To view all valid charges for UDT01s for which the ID or description begins with a specific string of characters, enter those characters in Value. (For example, if you enter 10, the results list would include 1000 and 1010, but not 0100.)
To view all valid charges for UDT01s for which the ID or description contains a specific string of characters in any position, enter a percent sign (%) followed by those characters in Value. (For example, if you enter %10, the results list would include 1000, 1010, and 0100.)
Time & Expense with ESS may be set up to require a minimum number of characters in filter values. If you do not enter enough characters, a message prompts you to enter more. The minimum number may vary depending on your selection in Filter By.
If you want to display a list of charges based on UDT01 code or description, make a selection in Filter By, enter the search text in Value, and click Apply.
If you enter filter parameters and click Apply, the table displays a row for each of the available charges for the UDT01s selected by your filter. To add one of the charges to your timesheet, expense report, or expense authorization, select the check box for the row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
If you do not use a filter, the table contains a row for each sublevel or charge available at the current drill-down level. (The current drill-down level is displayed above the table.) A drill-down level has a plus sign (+) in the first table column, and a charge has a check box. To drill down to a level, click the plus sign for that row. To add one of the charges to your timesheet, expense report, or expense authorization, select the check box for the charge row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
You can select multiple rows if you are adding charges to a timesheet.
To add one or more of the charges to your favorites, use a filter or drill down to display the charges, select the check box for each charge row you want to add, and then click Add to Favorites.
If the total number of rows in the database exceeds the maximum number of rows that can be displayed in lookup dialog boxes (as specified in the General Configuration screen), the Next button is enabled. Click that button to display the next set of rows.
Use the Previous button to return to previously displayed sets of rows.
To add one or more of the charges displayed in the table to your timesheet, select the check box for each row you want to add and then click Add to Timesheet.
To add a charge displayed in the table to your expense report or expense authorization, select the check box for the row you want to add and then click Add to Expense Report, or Add to Expense Authorization. (For expense reports and expense authorizations, you can only add one charge at a time.)
If you select a charge that is no longer authorized for the employee in Costpoint, the system displays a warning message, and that charge is not added. If you selected more than one charge, authorized charges are added but unauthorized charges are not.
To add one or more of the charges displayed in the grid to your timesheet, expense report, or expense authorization, select the check box for each row you want to add and then click Add to Timesheet, Add to Expense Report, or Add to Expense Authorization.
To add one or more of the charges to your favorites, display the charges, select the check box for each row you want to add, and then click Add to Favorites.
Click Close to close the Charge Lookup dialog box.