Sheet View - List

See Also

Navigation

 

The following information provides details on the options on the Sheet View list screen.

 

Filters

 

The key fields are grouped at the top of the screen, setting the criteria for the data being entered or reviewed. Depending on security permissions granted to an employee or vendor, they can edit/delete/approve/print their time entries. When reviewing time entries, all key fields are important. In addition, you can select the number of rows to be displayed at a time in the grid. A security setting for Time Entry enables project and employee managers to see records for only those employees that the user is manager for. Thus, time data can be viewed at on the "workgroup" basis, so that projects or employees can be selected on the basis on their Manager designation.

 

View By:
Time Entry can be viewed by Employee, Vendor or Project. Select any option from the drop down menu in this field. If you choose Employee/Vendor, time can be entered for one employee or vendor on multiple projects. If you choose Project, time can be entered for many employees or vendors on one project. Typically, time is entered by an employee in "View By: Employee" mode. However, when project managers or supervisors review time records, they would review them on project basis using "View By: Project" mode. This field affects the records being displayed in the grid below.

 

A security setting for Time Entry enables project and employee managers to see records for only those employees that the user is manager for. Thus, time data can be viewed on the "workgroup" basis, so that projects or employees can be selected on the basis on their Manager designation.

Project/Employee/Vendor:
(required)
Depending on what is selected in the View By field, Employee/Vendor/Project is displayed. You can select the desired Employee ID, Vendor ID or Project ID from the list provided by clicking the drop-down arrow. An employee or vendor who is permitted to access the time entry screens only, upon login as a Web Suite user, will find this field pre-filled. In addition, this field is unavailable and non-editable.


In case the "Budgeted Employee Only" or "Budgeted Activity Only" is checked in Project screen, only the budgeted employees or budgeted activities will appear in the drop-down list.

 

Click the Filters.. link to display the relevant Filter screen wherein filters can be applied to the respective drop-downs for selective viewing. This would depend on the option selected in the View By field. On the Project/Employee Filter screen, select the check box for the Project/Employee (or Vendor) records that you want to display in the drop-downs on the Sheet View.

Period:

The period field provides Day, Week, Biweekly, Month, Bimonthly, Year, This Fiscal Year, Last Fiscal Year, All and other options. They determine the range of time entries that are displayed in the grid. They do not restrict the dates you will assign to the time entries.

 

A timekeeper typically reviews his activities for a period of time, perhaps corresponding to the last one or two time sheets. A vendor can review a week, a month or all. A project manager or supervisor typically reviews time by project or by employee for a given time frame. The next field, Period Including, works in combination with the Period field to determine what range of time entries are displayed in the grid. In case of All option, all the time entries of the selected employee/project/vendor are displayed in the grid, irrespective of the date in the Period Including field.

Period Including:

Period Including defaults to the system date of your computer, however, you can make a time entry for any date. Enter any date within the period you want to display. You can select the date from the drop-down or the
Calendar on the right (by selecting the Change Period Including Date option). If the period you have selected is "month", and the Period Including is "February 28, 2014", you will view the time entries for the month of February 2014.  Again, neither the Period nor the Period including fields restrict the dates you will assign to the time entries.

 

More Filters:

Make a selection from this drop-down list to display selective time entries, say those which are submitted, approved, unapproved, billable, billed, those associated with vendor bills, etc. Click Refresh to apply the selected filters.

 

Refresh :

Clicked, the grid will be filled with time entries based on the selections made in the previous fields.

 

Quick Entry

 

Use the fields in this section to add a time entry.

 

Date:

Specify the date of the time entry.

 

Project:

Select the name of the project for which the time entry is being created.

 

Activity:

Select the activity code associated with the time entry.

 

Description:

Enter descriptive detail or comment for the new time card.

 

Hours:

Enter the number of hours used to complete the tasks.

 

B (Billable Flag):

This check box indicates whether the time entry is billable or not.

 

A (Approval Flag):

If this check box is selected, the time entry is approved for invoicing. Approved time entries are included in Billing Review's project labor totals and Time Entry Details screen.

 

Add :

Click to save the time entry details.

 

Erase :

Click to clear time details without saving them.

 

Search Item :

This enables you to search for a particular record in the grid. You can search for a record using full or partial ID, name or any other text field. Web Suite displays the matching records in a drop-down list based on what you type in the search text box. The items displayed get narrowed down as you keep on typing. For example, you might want to search for a record whose ID starts with letter A. As you type letter A, all IDs beginning with letter A are displayed in the drop-down. As you keep on typing more letters it displays more relevant results. Click to jump to the desired record in the grid.

 

Sheet View Grid

 

Sheet View grid is your guide to time entries. It is a series of rows and columns. Each row is a separate time record. In the grid, you can view the previous time entries and can also edit or delete them.

 

Click the column headings to sort the columns in the grid. The number of records displayed in the grid will depend on the selection made in the Rows list box.

 

Entries displayed on the grid cannot be edited in the grid but rather in the data entry section of Sheet View-Details screen. Select the record by marking the check box against the time record. You can also select all the records in the grid at once by marking the topmost check box.

Grid details are carried from the Sheet View screen. Click image\Edit_Icon.gif to open the Sheet View screen where you can edit the selected time record. Click image\DeleteIcon.gif against the time record you want to delete.

 

Date:

Displays the date of each time entry.

 

  Time entry date is not stored as UTC (Universal Coordinated Time) and hence is not agnostic to location.

 

Employee/Project:

Depending upon what you selected in the View By field, this column displays either the Employee ID or Project ID for a time entry.

 

Project Name:

This is the name of a project against which a time entry is being recorded.

 

Activity:

Displays the Activity ID of a performed task.

 

Description:

Descriptive detail for an activity code selected for a task.

 

Hours:

The amount of time in which the tasks was completed.

 

B:

This column indicates whether the time entry is billable or not. The billable status is brought from Activity but if the project is non-billable, those with Overhead or Marketing contract types, the billable status will be changed from billable to non-billable.

 

A:

Shows that the time entry is approved for invoicing. Approved time entries are included in Billing Review's project labor totals and Time Entry Details screen. After being approved, an entry cannot be modified except with the proper security permissions.

 

M:

Indicates whether a memo exists for the time entry or not.

 

VB:

This column indicates whether a time record is related to a vendor bill or not. Records which are associated with vendor bills display . Double-click this icon to open the Vendor Bills screen.

 

Created On:

This field gets automatically filled with the system date saved in the UTC format when a new time entry is recorded. It also includes a time-stamp, which represents your local time.

 

The Date and Created On dates can differ.

 

The Created On date can be used to sort the grid based on the date when the time entry was created or recorded, and not necessarily for which date it was recorded. It allows you to calculate the lag time or average delay in entering time by employees. You can also view this information in the Time Entry Delay Analysis report.

 

This feature is available in Web Suite Enterprise edition only.

 

Edit :

Click to edit a time entry.

 

Delete :

Click to delete a time entry.

 

Sheet View Button Panel

 

Rows:

The number of rows displayed on the page. Select the page size from the drop-down list. The page currently displayed is shown at the bottom left side of the grid.

 

Help:

Opens the Web Suite Help for Sheet View section.

 

Copy/Paste:

Allows you to copy and paste selected entries in the time entry grid. These options get activated after you select a row. A maximum of 50 time entries can be copied at once.

 

Paste Special:

You have the option to copy the selected time entry and paste it with some modifications using the Paste Special screen.

 

Print:
Opens the Time Entry Report. In View By: Employee mode, the Employee Time Records report is generated while in View By: Project mode, the Project Time Records report is generated. You can view and print the report and then Close
the page.

 

Options:

 

Filters (On/Off):

Turns on/off all filters set in the Filter screens. Select the check box to apply filters to the drop-downs.

 

Automatically Set Start Time:

Select this option to have Web Suite automatically fill the start time of an entry. By default, the start time will be the stop time of the previous entry but for the same date.

 

Show Totals:

Select the check box to view the below mentioned fields. Based on the selection made in the key fields, their value varies accordingly.

 

  1. The Show Totals option gets disabled on checking Do Not Show Totals rule in Global Settings-Time tab.

Change:

Select to modify multiple time records simultaneously.

 

Find:

Opens the Web Suite Find screen to search for time and expense related or any other data.

  

Submit:

Opens the Submit-Approve screen from which a user selects the person who is responsible for approving their time entries. Entries must be approved (also called posted) before they are available for billing. After selecting entries to submit to a particular reviewer, click the Submit button, select the person to review the entries, then click the OK button.

 

While chargeable time entries are commonly submitted to the project manager, your company policy will determine to whom you submit billable and non-billable entries. Web Suite enables you to submit entries to the Client Manager, Project Manager, My (Employee) Supervisor, or to a person selected from a drop-down list.

 

A review can reject one of your time entries. You will be notified and should correct the entry and re-submit it as soon as possible.

 

Approval can be turned on by the Web Suite Supervisor, all time entries are automatically approved when they are saved.

 

Approve:

Click to approve the selected time entries. Multiple time entries can be selected using either Shift or Ctrl keys. Approving an entry approves it for invoicing.

 

New:

Click, opens the Sheet View screen which allows you to record a new time entry.

 

Close:
Closes the Sheet View screen and takes you back to the home page of Web Suite. It is important that you exit using this button and then log out. Do not close your browser directly as that leaves your connection open on the server for up to 20 minutes and can impact the server performance.

See Also