Sale Order Details Report

Modified on: Wed, 12 Apr, 2017 at 5:21 PM

This report shows sale order details for authorised sale orders filtered by sale order date.

Input:

Following are input for this report

From	Allow user to select a date i.e. beginning date of required report
To	Allow user to select a date i.e. closing/end date of required report
Currency	Allow user to select Currency for report
Update	Update button which refresh report results
Apply Filter	This button show option to set filter on fields used in report
Export	This button will allow user to export report data in Excel, PDF or RTF format

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.

SKU	Product SKU.
Product	The name of the product.
Order #	Sale Order Number identifying sale order.
Order Date	Sale Order Date.
Customer	Customer name.
Location	Default location selected for sale.
Status	Status of sale.
Quantity	Quantity of the product ordered (doesn't include restocked quantity.
Discount	Average Discount applied.
Tax	Tax calculated for line.
Total	Total amount invoiced with tax.
Sale	Total amount excluding tax.
Customer Tags	Comma-separated customer tags.
Unit	Product unit of measure.
Category	Product category.
Brand	Product brand.
Product Tags	Comma-separated product tags.
Family	Product family name.
Invoice Status	Status of the Invoice in sale.
Invoice Date	Invoice issue date.
Invoice #	Invoice Number identifying sale invoice.
Ship by	Date when order is to be shipped.
Country	Shipment address country.
State	Shipment address state.
City	Shipment address city.
Postcode	Shipment address postcode.
Shipping Address 1	Shipment address line 1.
Sales Representative	Name of sales representative associated with the sale.
Customer Reference	Customer Reference associated with the sale.
Product Additional Attribute 1-10	Values of product additional attributes.
Customer Additional Attribute 1-10	Values of customer additional attributes.