The Worksheet is the weekly container for holding time and expenses entered by Employees. As Employees enter time and expense sheets during the course of a week, the Worksheet organizes those entries. When the next week arrives, a new Worksheet is created and Employee time and expense entries are contained there. Typically, Worksheets are approved on a weekly basis.
To review an already-existing Worksheet, select the EDIT option on the main Worksheets workbench. The following screen will appear:
For more information on using Worksheets to help manage projects, please see the eBook Managing Projects with xTuple.
When reviewing a Worksheet, you are presented with the following options:
Displays the system-generated number of the Worksheet.
Displays the date for the week contained by the Worksheet. The date is set manually when creating a new Worksheet.
Displays the Site associated with the work. The Site is chosen manually when creating a new Worksheet.
Displays the name of the Employee associated with the Worksheet. The Employee is entered manually when creating a new Worksheet.
Select to automatically print the Worksheet whenever it is saved.
The following buttons are unique to this screen:
Select to add a new time or expense entry to the Worksheet.
To enter notes related to a Worksheet, select the "Notes" tab. The following screen will appear:
The "Notes" tab provides a text area where you can add miscellaneous notes related to the Worksheet.
To associate Documents with a Worksheet, select the "Documents" tab. The following screen will appear:
When associating documents, you are presented with the following options:
Select to create a new document and associate it with the current record. You may create the following document types:
Select to create a new Image association.
Select to create a new Fixed Asset association.
Select to create a new Maintenance Order association.
Select to create a new Incident and associate it.
Select to create a new Project and associate it.
Select to create a new Opportunity and associate it.
Select to create a new To-Do and associate it.
Enables you to edit associated documents. The edit screen is the same as that for creating a new document—except that when editing, the fields will contain document information. Double-clicking on a document will also bring you to the editing screen.
Highlight a document and then select this button to reach a read-only view of the "Edit" screen
Select to associate already-existing documents. The following document types may be attached: Contact, Account, Customer, Employee, File, Image, Incident, Item, Opportunity, Project, Purchase Order, Sales Order, Vendor, Web Site, Work Order.
Highlight a document and then select this button to remove the association.
To associate already-existing documents, select the ATTACH button. The following screen will appear:
When associating already-existing documents, you are presented with the following options:
Indicate how the document is related to the current record. The following relationship options are available: Related to, Parent of, Child of, Duplicate of.
Specify the kind of document you want to associate. The following document types may be attached: Contact, Account, Customer, Employee, File, Image, Incident, Item, Opportunity, Project, Purchase Order, Sales Order, Vendor, Web Site, Work Order. When associating Files, you will also be given the option to save the File to the database.
There is no file size restriction when saving Files to the database. However, excessively large files could cause storage and performance issues.
Use the lookup field to identify the specific document you want to attach. The data entry options will vary depending on the document type you select.
The Worksheet Item screen is where Employees record their actual time or expenses related to a Project. To add a time or expense entry, select the NEW button on the Worksheet screen. The following screen will appear:
When adding a time or expense entry, you are presented with the following options:
Displays the system-generated number of the Worksheet.
Displays the line number assigned to the time or expense entry.
Displays the date for the parent Worksheet.
Enter the number of the Project associated with the entry. This is a required field. Depending on how the Project is configured, many of the other fields in the entry (e.g., Customer and Item numbers) will be filled out automatically from the Project information.
Select a Task from the list of Project Tasks to associate with the entry. This is a required field.
Enter the date the work was performed or the expense was incurred.
Specify whether the entry is a time or expense type entry.
Enter the number of the Customer associated with the entry. This field may be filled automatically from the Project information, depending on how the Project is configured. The Customer is needed for billable entries, so the system knows who to invoice for the time and/or expense.
Enter the Customer Purchase Order number, if any.
Enter an Item Number to associate with the entry, if one is not already linked from the specified Project Task. This is a required field. The Item Number is needed to map an Expense Account to the Task, which is required for subsequent General Ledger transactions. Only Reference Items which have been configured specifically to work with time and expense entries (on the "Project" tab of the Item master) may be selected.
Displays the name of the Employee indicated on the parent Worksheet.
For time entries, enter the number of hours worked on the specified Task.
For expense entries, enter the quantity of expenses incurred. For example, if mileage is being reimbursed, enter the number of miles. For hotel stays, enter the number of days.
Select if the work performed or the expense incurred is billable to the specified Customer. If not selected, time entries will be booked to overhead and expense entries will be reimbursable.
For billable time entries, enter the rate to be billed to the Customer. Depending on how the Project is configured, this information may be filled in automatically for you.
For expense entries, enter the per unit cost of the expense item. For example, enter $0.25 per mile for mileage reimbursements or $125 per night for hotel costs.
Displays the total billable amount for time entries and the total reimbursement amount for expense entries.
For time entries, displays the Employee's hourly rate (or cost), as distinguished from the billable rate charged to the Customer.
For time entries, displays the total cost for the Employee's time spent on the task, based on the Employee's hourly rate.
For expense entries, select if the item has already been paid for, making it ineligible for reimbursement.
When viewing the summary for a time and expense entry, you are presented with the following information:
Displays the following information related to the selected Project Task:
Displays the total hours budgeted for the Task.
Displays the actual hours logged against the Task.
Displays the total expenses budgeted for the Task.
Displays the actual expenses logged against the Task.
Displays the following information for the Employee associated with the Worksheet:
Displays the number of hours entered for the Employee on the given work date.
Displays the Employee's total hours on the parent Worksheet.
The following buttons are unique to this screen:
Select to view the previous time or expense entry. If none exists, this button will be disabled.
Select to view the next time or expense entry. If none exists, this button will be disabled.
To enter notes related to a time or expense entry, select the "Notes" tab. The following screen will appear:
The "Notes" tab provides a text area where you can add miscellaneous notes related to the time or expense entry.