Admin Line Item Report
The condition options are a combinatorial filtering mechanism which means that choosing multiple conditions applies to the entire result set. If you select an order type and a company, the report will only return those line items which meet both criteria.
Conditions:
- Order ID: This condition searches for the existence of the criteria in the entire property. For example: ID = “1234”, Condition = “23” will return the Order with ID = “1234.”
- Order Type: The list of order types.
- Order Status: The list of order statuses.
- Payment Method: The list of payment methods.
- Company: The list of all buyer companies.
- Category: The list of all categories for the selected company. To view the list of categories, click “load options…”
- Product: The list of all products. If a company has been selected, the list is narrowed to only include products for that company. To view the list of products, click “load options…”
- Cost Center: The list of all cost centers for the selected company. To view the list of cost centers, click “load options…”
- User: The list of all users for the selected company. To view the list of users, click “load options…”
- Ship Address: The list of all shipping addresses for the selected company. To view the list of shipping addresses, click “load options…”
- Subtotal On: A list of display columns for which a subtotal can be calculated.
- Date Range: Based on the order submitted date.
- Time Span: A list of set date ranges.
If you select a company, the following additional conditions will appear:
“Display Columns” is a list of all columns that comprise the Product Report. The list is provided to allow for the narrowing of a report to show the desired columns of information. The list is multiple-selection enabled (hold the Ctrl key down as you select with your mouse). The Conditions criteria will still apply if the column is not selected for display.
The Preview button returns the result of the report to a tabled grid in the lower portion of the page. It is intended for a quick inspection of report accuracy.
The Download button returns the result of the report in a comma delimited format (csv) which is fully supported in Microsoft Excel, as well as all other major spreadsheet applications. You will be prompted by your browser to save or open the file. The file is always named by the default value of "Report.csv." Once saved to your local computer, your spreadsheet program should open the file normally with each column separated as intended. If the file does not delimit by the comma, consult your software's documentation regarding the use of comma delimited files.
The Save button stores the entire Conditions and Display Columns selection, along with the provided Report Name, to your Saved Reports list.
The Cancel button reverses all of your selected properties and returns you to the Saved Reports list.