Sales reports: configurable columns

Below is a list of all the configurable columns available on the recent sales list and sales detail report, along with descriptions of each column.

Shared columns

These columns are shared between the sales list and the sales detail report.

Field name Description
Order ID The system-assigned order ID of the sales order or credit.
Invoice If invoiced, the invoice reference assigned to the sales order or credit.
Ref The customer reference of the order, typically the external reference the customer is given, generated by the sales channel.
Status The order's order status.
Date created The date the order was created.
Delivery due The delivery due date of the order.
Exchange rate If a foreign currency order, the order's exchange rate.
Price list The sales price list assigned to the order.
Assigned to The staff member the order is assigned to, if applicable.
Delivery name The delivery address details taken from the 'Addresses' tab on the order (not the contact's default delivery address!)
Delivery company
Delivery street
Delivery suburb
Delivery city
Delivery state
Delivery postcode
Delivery country
Delivery telephone
Delivery email
Delivery mobile
Order season The season assigned to the order.
Lead source ID The lead source assigned to the order.
Channel The channel assigned to the order.
Project The project assigned to the order.
Warehouse The warehouse assigned to the order.

Sales list-specific columns

These columns are only available to be added to the sales list.

Field name Description
Allocation status The allocation icon displaying whether the order is unallocated, part-allocated, fully allocated, or if no allocation is required.
Inventory status The fulfillment icon displaying whether the order is unfulfilled, part-fulfilled, fully fullfilled or if no fulfillment is needed.
Shipping status The shipping icon displaying whether the order is unshipped, part-shipped, fully shipped or if no shipment is needed.
Contact The contact name and company assigned to the order. This is taken from the first address on the order's addresses tab.
Order type Whether the order is a sales order or sales credit.
Parent order If the order was cloned from another, the order ID of the original order is listed here.
Tax date The order's tax date (invoice date).
Payment due The order's payment due date.
Total The order total in the order currency.
Paid The paid amount of the order in the order currency.
Net The order value without tax in the order currency.
Tax The order tax amount in the order currency.
Base currency total The order total in base currency.
Base currency net The order value without tax in base currency.
Base currency tax The order tax amount in base currency.
Tax status The tax status of the order, if using the Avalara integration.
Payment status The order's payment status, out of: unpaid, part-paid, fully paid or no payment required.
Settlement discount The percentage settlement discount assigned to an order.
Settlement discount days The settlement period of an order.
Cost price list The cost price list assigned to the order.
Ship method The shipping method assigned to an order.
PCF_* The value of the relevant sales custom field.

Sales detail-specific columns

These columns are only available to be added to the sales detail report.

Field name Description
Order row SKU The SKU of the product on the order row. This may differ from the SKU on the product record, if a price list SKU is being used.
Options The option values assigned to the product, if any.
Quantity The quantity of the product on the row.
Currency The order currency.
Billing name The billing address details taken from the 'Addresses' tab on the order (not the contact's default billing address!)
Billing company
Billing street
Billing suburb
Billing city
Billing state
Billing postcode
Billing country
Billing telephone
Billing email
Billing mobile
Contact name The address details taken from the 'Addresses' tab on the order (not the contact's default address!)
Customer company
Billing street
Suburb
City
State
Postcode
Country
Telephone
Email address
Mobile
Product ID The product ID of the product on the row.
SKU The SKU of the product on the order row, taken from the product record.
Order list price The price of the product on the sales price list assigned to the order.
Item net The price of one unit of the product, without tax, in the order currency.
Item gross The price of one unit of the product, including tax, in the order currency.
Item tax The tax amount of one unit of the product in the order currency.
Cost price

The cost price of one unit of the product on the row (always in base currency).

Before shipping, the unit cost is taken from the price of the product on the cost price list assigned to the sale. After shipping, the actual unit cost is used.

Row cost

The total cost of the row (always in base currency).

Before shipping, the cost of the items is taken from their price on the cost price list assigned to the sale. After shipping, the actual cost price is used.

Base currency item net The price of one unit of the product, without tax, in the base currency.
Base currency item gross The price of one unit of the product, including tax, in the base currency.
Base currency item tax The tax amount of one unit of the product in the base currency.
Row net The total value of the row, without tax, in the order currency.
Row tax The total tax value of the row in the order currency.
Row gross The total value of the row, including tax, in the order currency.
Base currency row net The total value of the row, without tax, in the base currency.
Base currency row tax The total tax value of the row in the base currency.
Base currency row gross The total value of the row, including tax, in the base currency.
Item tax class The tax code assigned to the row.
Brand The product's brand, taken from the product record.
Product type The product's type, taken from the product record.
Reporting category The product's reporting category, taken from the product record
Reporting subcategory The product's reporting subcategory, taken from the product record
Reporting season The product's reporting season, taken from the product record
Primary supplier The product's primary supplier, taken from the product record
PCF_* The value of the relevant product custom field.
Have more questions? Submit a request