Skip to content

8 Handy Tips for Company Summary Invoice reporting in OpenAir

  1. There is no filtering on charge stage with any Invoice summary value out of the box.
  2. All charges (no matter what charge stage) by default are included in all out of the box values: Invoices – All.
  3. Out of the box there is only one option for anything on an invoice: Invoices – Invoiced.
  4. The charge stage to filter for open/billed is [no charge stage].
  5. There is no way to filter on open or billed separately. (Use Invoices – Invoiced for “billed”).
  6. There are two specific isolations for types of Invoice options out of the box: Fees and Expenses.  “Fees” include time, flat and other charges.  There is no product option.  This is as designed since most users do not have the Purchase module.  You will need to create a custom option if this is desired. Reminder: these values are any charge stage.
  7. Any charge type isolation for invoiced charges needs a separate custom calculation.  For example: invoiced products, invoiced expenses.
  8. When creating custom calculations, use the out of the box metric and multiply it by 1 (charge).  Use the filters to isolate the values. See screen shots below.

 

using the out of the box metric and filters to isolate values in the OpenAir company summary invoice report

 

 

About Us:  Our mission is to enable and empower Professional Services Organizations to become profitable, scalable, and efficient through change management, technology deployment, and skill set training with a Customer First approach.

Scroll To Top