Sale Order Details Report

This report shows details of sale orders. This detailed view breaks down purchase orders by product, showing product quantity, product cost and total product cost per order. The output can be customised to show product details, order/invoice status and more. 


NOTE: This report does not include service items, non-inventory items or gift cards. 


Prerequisite


Table of Contents


Data from this report can be exported in Excel, PDF or RTF format. 



Input:

Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range. This report pulls entries based on the Sale Order date. 
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 



Output:

The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report. 


Fields
SKUProduct SKU
ProductName of the product
Order #
Sale Order number
Order Date
Sale Order date
Invoice #
Sale Invoice number
Invoice DateSale Invoice date
Invoice StatusStatus of the invoice (e.g. Authorised, Paid)
NotesNotes field of the sale document header
YearSale Order year
QuarterSale Order quarter
MonthSale Order month
Sales RepresentativeCompany sales representative responsible for the Sale Order
Customer Customer name
Customer Reference
Customer Reference from the sale document header
Customer TagsTags associated with the customer
Brand
Product Brand
Category
Product Category
Family
Product Family
Product TagsTags associated with the product
UnitProduct unit of measurement
LocationLocation selected for the sale
StatusStatus of the sale
Shipment DateShipment date for the Sale Order
Ship ByRequired by date from the sale document header
Shipping Address 1Shipping address line 1
CityShipping address city
StateShipping address state
Country
Shipping address country
PostcodeShipping address postcode
Customer Additional Attribute 1-10Values of additional customer attributes
Product Additional Attribute 1-10Values of additional product attributes
Data Headers
QuantityQuantity of the product ordered (doesn't include restocked quantity)
Discount% Discount applied to the line
SaleSale total for the order line (after discount has been applied)
Tax Tax for the order line
TotalTotal = Sale + Tax

NOTE: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields. 


FAQs

[back to top]


Why aren't additional costs captured on the Sales Order Details and Sales By Product Details reports?

Sales Order Details and Sales by Product Details Report does not show additional charges because the report focuses on product lines and order details found in the document header. Try using instead the Profit by Sales Rep report, this includes additional charges because it is needed to know the profit total and currently this is how the system is designed for the reports. 


 How can we get a report that shows sales by state by customer address rather than by shipping address?

Unfortunately, we don't have a report that shows customer address, our sales reports are based on the shipping address.


I need to show the Order Line Comment on the sale order details report. I saw in your Purchase Order Details Report, there is a comment field to show the line comment. I need the line comment to be shown on the sale order details report as sometimes we note the modification on the comments, or the actual code of a misc item.

As of now the there is no field available in the Sale order details report or any other sale reports to show the order line comment. However, as a workaround, you may use the Header area's reference field to show on Reports or you may also use additional attributes to define your sales, and these additional attributes will be shown in the additional attributes column in the report. However, if you feel this feature is important, you can raise a feature request on our Feature Request Forum.


The report is not showing orders for service items. 

For service sales please check the Sales by product details report, this contains both service and stock items.


Can you please tell me why a sale order is missing from this report?

Usually, this is an issue with the date filters. This report pulls sales according to their order date. Double-check that the reporting period covers the sale order date. 



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.