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.