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. |