Compiere Time and Expense

Expense type is the initial setup before entering the expense Report. Expense Reports allow you to capture the time spent on Projects, Campaigns, or billable time.

This Module emphasis the service feature.

  • Expense Reports allow you to capture the time spent on Projects, Campaigns, or billable time.
  • They also can generate reimbursement invoices for employees or consultants as well as bill your customers for time and materials.
  • Resources are a type of product very much similar to service.
  • Resources can be used in Invoices and Projects.

Expense Types

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Expense Type

Main Menu --> Time and Expense Setup --> Expense Type

Expense type is the initial setup before entering the expense Report.

When an Expense Type is created the corresponding Product is also created. Like all Products, Expense Types must have a price to be used on an Expense Report.

Creating a New Expense Type: Below we have created a new expense type as Indirect Cost of Service Delivery.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Expense Type 2

Select the Active checkbox to indicate that this Expense Type can be used.

Select the appropriate UOM and select the ‘Invoiced’ checkbox if this Expense Type will be ‘Invoiced’ to Customers.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Expense Type 3

Select a Product Category and Tax Category. Click on the Expense Product tab to enter or update Product information for this Expense Type.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Expense Type 4

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Expense Type 5

Enter a List Price, Standard Price, and Limit Price..

RESOURCES

Resources identify services that are limited in availability. For e.g a resource may be available from Monday to Thursday from 10.00 A.M to 5.00 P.M. Services are a Product and like all other Products, they must appear on a Price List if they are to be ‘Invoiced’ to customers.

There are two steps to defining Resources. First, define a Resource Type and then the actual Resources.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resources

Main Menu --> Time and Expense Setup --> Resource Type

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resources 2

Enter the Name and the Description of the New Resource Type

select the Active checkbox so this Resource Type may be used when defining Resources

Select a Product Category and Tax Category

Select the Single Assignment only checkbox if Resources of this type cannot be booked for multiple times

If we select the Time Slot checkbox then the Slot Start and Slot End time fields display. Enter the start and end times that Resources of this type may be booked

If we select the Day Slot checkbox then the days of the week fields appear. Select the days that Resources of this type may be booked

Resource

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resource

Main Menu --> Time and Expenses --> Time and Expense Setup --> Resource

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resource 2

The Actual Resource those are booked for the project are defined in the Resource Window.

Many of the fields are similar to the product Window.

Enter a Name and Description and select the Active checkbox to indicate that this Resource may be used.

Select a Resource Type to define the time and days this Resource may be booked.

If appropriate select a User/Contact for this resource. This may be used if your Resource is a specific employee.

Enter the Warehouse/Service Point for this Resource.

Select the Available checkbox if this Resource is currently available.

To enter days that the above resource is not available, select the Unavailability tab.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resource 3

Enter the Date From and Date To and any Description for each instance of unavailability.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resource 4

Click on the Resource Product tab to define or modify specific product fields for this Resource.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Resource 5

Click on the Price Tab to define prices for this Resource.

Click on the Assignment tab to view all Assignments for this resource.

Expense Report

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Report

Main Menu --> Time and Expense --> Expense Report

Use Expense Reports to record the time spent on Projects or Campaigns, Reimbursable expenses to Employees or Consultants and billable charges to Customers.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Report 2

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Report 3

Check Invoice if the Transaction has to be invoiced.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Report 4

Click on Complete to complete the Transaction

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Report 5

Once the Expense Report is completed The processed checkbox will be Checked.

The Next Step is to Invoice the Expenses.

Create a Sale Order from the Expenses

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense

Main Menu --> Time and Expense --> Create a Sale Order from Expense

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 2

Select the respective Business Partner and the Expense Date.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 3

All the pending Sale orders for Expenses would be created.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 4

Order Management --> Sales Order --> Sale Order

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 5

Select the appropriate created Sale Order from the Search Screen. 6202 is Order NO.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 6

Click on Prepare to generate the Sale order.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 7

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 8

Click on Complete to compile the Sales Invoice.

The Final Process Invoice the Customer.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 9

Complete the Invoice and Post it to the Accounts

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create_Sales_Orders_from_Expense 10

Expense Reimbursement

Once you have completed and processed your Expense Report you should review the Reimbursable Expenses for your employees and create AP Invoices for each employee.

When an Expense Report is processed one record is created for the Business Partner entered on the Expense Report tab. If there is an existing record for that Business Partner then the lines will be updated. This allows for Expenses to be entered and processed on a weekly basis for example, but paid monthly.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_EXPENSE REIMBURSEMENT

TenthPlanet_Compiere_Garden_World_Time_and_Expense_EXPENSE REIMBURSEMENT 2

The Purchase Price list and PO Payment Term default from the Business Partner, Vendor tab if defined. They can be changed if desired.

Click on the Report Line tab to review and update the line items for these Expenses (not reimbursed).

The fields on the Report Line tab are the same as on the Expense Report Line tab. You can update the following fields: Invoice Price, Campaign, Project, Project Phase, and Project Task.

Create an AP Invoice

The Create AP Expense Invoices process will generate AP Expense Invoices for the selected Business Partners.

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create an AP Invoice

Main Menu –> Time and Expense –> Create AP Expense Invoices

TenthPlanet_Compiere_Garden_World_Time_and_Expense_Create an AP Invoice 2

Accounts Payable Invoice Generated.

compiere_upgrade

Leave a Reply

Your email address will not be published. Required fields are marked *