Knowledge Center

Knowledge Center > Reporting > Data Exports > Invoices Query

Invoices Query

Overview

The Invoices query lets you export a report with a group of your customers or all of your customers. This article explains how to create the Invoices query including the data source objects and fields required for export. This report reproduces the data provided by the Invoices Report that was deprecated as of R182.

Data Source Selections

Navigation: Reporting > Data Sources

In the Data Source drop-down, choose Invoice.

See Generate a Data Source Export for general instructions on how to create a data source export

Objects and Fields

The following table describes the objects and their fields used in the Invoice query:

Object Fields

Invoice

  • Amount
  • Created Date
  • Posted Date
  • Source ID
  • Status
  • Target Date

Account

  • Account Number
  • Currency
  • Name

Filters

The following are recommended filter fields to refine your search. If you want to view all customers with any status,  a filter is not required.

Set your filters (NameStatusCreated Date, and Updated Date) to help you define what you want to see and retrieve in your reports.

  • Name: Enter the customer name to export data based on an individual customer account.
  • Status: Select a status type from the list to filter by status (Draft, Active, or Canceled).

Time Frame

The following are recommended date filters.

  • Created Date: The date the customer accounts were created. The minimum number of days that you can run a report for is two days. For example, if you set your date filter to be 1/1/2014 through 1/2/2014, your report will show customer accounts created on 1/1/2014 and 1/2/2014.
  • Updated Date: The last date that the customer account was modified.

Format

Select to export as a CSV or CSV ZIP

 

Last modified
11:31, 9 Aug 2016

Tags

Classifications

(not set)