Articles in this section

Inventory Revenue Report

  • Updated
Follow

Overview

As a "revenue" report, this should be enabled for Invoices. If enabled for Quotes, you will see a "budgeted revenue" report. While this is often identical for many Users, if any Prices or Costs were changed on the Invoice, they will not be reflected when the report is generated for Quotes.

Parameters

Start Date: the start of the date range by which the Start Date is filtered.

End Date: the end of the date range by which Start Date is filtered.

Inventory Group: limits results by the selected Inventory Group and its children.

Multiple Status Options: limits results by the Status Options selected in the Definition Level Reports section of the Reports tab of the Project Element for which this report is enabled.

Output*

Inventory Group: The full Inventory Group hierarchy for the item

Inventory Item: The Item Name as entered

Invoice Name: The Element's Name

Invoice Number: The Element's Number

Client: The Contact selected as the Client for the Element

Status: The current Status held by the Element

Account Manager: The Contact/User selected as the Responsible Person for the Element

Start Date: The Start Date of the Element

End Date: The End Date of the Element

Rental Quantity Owned: The allocated quantity at the time the report was created

Quantity Rented: The line item Quantity for the Element

Time: The line item Time Quantity

Rental Rate Used: The Pricing Model (aka Rate) used for the line item

Quoted Rate Before Discount: The Price Each for the line item

Standard Discount: The Standard Discount used if any

Quoted Rate After Discount: The Price Extended for the line item.

  • Calculated as (p - d) / (q * t)
  • Where is p the Price before Discount, d is the total Discount for the line (including Standard Discount, Line Item Discount, and distributed Total Block Discount), q is the Quantity, and t is the Time (unless t is 0, then 1 is used).

Purchase Cost Per Unit: The Purchase Cost for the Inventory Model

Purchase Cost for Total Owned: The total Purchase Cost for all quantities owned

  • Calculated as q * c
  • Where q is the Quantity owned and c is the Purchase Cost for the Inventory Model

Purchase Cost Total on Show: The total Purchase Cost for the line item's Quantity.

  • Calculated as q * c
  • Where q is the line item Quantity and c is the Purchase Cost for the Inventory Model

Quoted Revenue Before Discount: The total Price before Discount for the line item

  • Calculations vary by Pricing Model
  • Typically, the Price Ext. column in the UI before Discounts are applied.
  • Often q * t * p
  • Where q is the line item Quantity, t is the Time, and p is the Price Each

Actual Revenue: The total Price after Discounts.

  • Calculated as p - d
  • Where p is the Price before Discount (as calculated above) and d is the total Discount for the line (including Standard Discount, Line Item Discount, and distributed Total Block Discount).

% of Cost Recovered Before Discount: The percentage of the total Cost of the item received as revenue as it would have been before Discounts.

  • When c is not 0, calculated as p / c * 100
  • Where p is the total Price before Discount (as calculated above for Quoted Revenue Before Discount) and c is the total Purchase Cost for the line item's Quantity (as calculated above for Purchase Cost Total on Show)
  • When c is 0, the result is "n/a"

% of Cost Recovered After Discount: The percentage of the total Cost of the item received as revenue after Discounts.

  • When c is not 0, calculated as p / c * 100
  • Where p is the total Price after Discounts (as calculated above for Actual Revenue) and c is the total Purchase Cost for the line item's Quantity (as calculated above for Purchase Cost Total on Show)
  • When c is 0, the result is "n/a"

 

 

* Note that all column names use our default terms. In some reports, column header names are dynamic and may not be identical to those listed.

 

Related articles