Archive for Invoicing

Grouping Expenses on an Invoice

Wednesday, March 9th, 2011

Did you know you can create a Custom expense item to combine expense items on an invoice?

The accounting structure for handling expense items in many companies is quite detailed, and may even go down to the individual meal per day (breakfast, lunch, dinner) depending on their internal travel policies.   Tracking internal expenses to this level does not necessarily mean you need to display all of this detail on your customer invoices from OpenAir.   OpenAir supports the idea of grouping expenses together for a more general category name on the invoice.
This feature is a standard option available on the Invoice Layout of OpenAir.  If you navigate to the Administration -> Application Settings -> Invoice Layouts area of the system and select a layout, scroll down the form to see

When you click on Create, a form will pop-up to allow the designation of an expense item group.

Define the group name and the expense items that belong to that group.  The Group Name is what will appear on the invoice instead of the individual expense items.  The only limitation to this feature is that you MUST have more than one expense item in the group (i.e. you can’t use this as a rename of a single expense item).

Typical groupings that we’ve seen are:

  • Transportation (example above) combining all transit related expense items
  • Meals combining personal, business, lunch/dinner/breakfast breakdowns
  • Lodging combining values such as hotel, stay with friend, etc.

Since this setup is unique to a single invoice layout, you can setup invoice layouts that would be unique to customer reporting needs, or just clean up your information display!

Categories : weekly tips

Take Control of Standard Field Names

Wednesday, March 2nd, 2011

Did you know you can customize invoice terminology per invoice layout?

  As with many systems, the convenience of templates for documents like Invoices comes with the tradeoff of accepting the field names and column titles setup in the template.  OpenAir takes it one step further, however, by allowing you to override the field names with whatever you would like, including converting to another language (other than standard English).

The renaming feature is only available by contacting OpenAir Support and requesting enablement of the internal switch:  Customize invoice terminology per layout.

Invoice Layout form (Administration –> Application Settings –> Invoice Settings –> Invoice Layouts) before the switch:

Invoice Layout form (Administration –> Application Settings –> Invoice Settings –> Invoice Layouts) after the switch:

What you will immediately notice is that almost every field on the invoice is listed in the terminology options with a copy of the same value in the override text field.   For any value you would like to change, type over the text field and Save the form.

The terminology override supports foreign language characters as well so you can use this feature to convert your English invoices to other common languages such as Spanish, German, French, Dutch, etc.   The override is UNIQUE to the invoice layout.  If you need invoices to reflect a variety of languages, you would setup a new layout for each language and ideally adopt a naming convention so it is clear which terminology is leveraged on the invoice layout.  Example:  Dutch T&M Layout, Spanish Fixed Fee layout, etc.

So don’t feel like you are locked into standard wording – take control today!

Categories : weekly tips

Time Entry Tab – Part 2: Vendor Tracking

Wednesday, February 2nd, 2011

Ever wish you could reference the vendor invoice status for your T&M subcontractors and reconcile payment status?

Last week we pointed out the feature in the Timesheet module called the Time Entry tab to view individual time entries by user, project, even task. You can extend this feature to include a 2 types of fields that can be controlled by the ‘run an action’ checkbox functionality found in many of the OpenAir modules: Reconciled (a dropdown custom field) and Notes (a text custom field).

Setup the custom fields as follows (both are not required – you may choose to do one):

  1. Create a drop down custom field on the Time Entry item (Administration —> Global Settings —> Custom Field)
    • The field name must be oa_time_entry_reconciled but the description and display name can be whatever is desired.
    • Populate the value list with the desired values for status tracking.
    • It is recommended to check ‘Hide on data entry forms’ to prevent timesheets users from populating on the notes form in timesheets.
  2. Create a text field on the Time Entry item
    • The field name must be oa_time_entry_reconciled_notes
    • Default size of 25 is fine – just realize the width of the column in the list view will be adjusted to as wide as the longest value.
    • It is recommended to check ‘Hide on data entry forms’ to prevent timesheets users from populating on the notes form in timesheets

Now the Run an Action checkbox functionality is available for you to note when invoices are received, paid or in review, reconcile hours between the invoice and the OpenAir timesheets, and add notes such as the vendor invoice number, the check number issued for payment, or even short notes.

You can also control who has the ability to perform the Run an Action functionality at the individual user level. To add this control, you must setup a checkbox custom field on the user record to indicate the user is able to perform the Run an Action or reconciliation activity.

  1. The field name must be oa_time_entry_can_reconile but the description and display name can be whatever is desired.
  2. For each user that should have access to the Run an Action feature in the Time Entry tab, check the custom field on the User Demographic record. Administrator roles automatically have access to this functionality.

OpenAir time entry detail reports are also available to report on this information besides the look-up capabilities provided within the Time Entry Tab.

Categories : weekly tips

OpenAir Expert Webinar Series: Advanced Invoicing

Thursday, November 18th, 2010

In this webinar recording you will learn more about

  • Invoice number increments
  • Expense groups
  • Expense insert layout
  • Prefix, billing codes

…and more!

NOTE: All of our past webinars can be viewed on our webinar page.