Skip to content

Sales Detail Report

Action: SALEDETL

This report shows sales transactions broken down into various groupings that are user selectable. The report will have one detail line per style/size/color/width, per store. It may be utilized to see how sales of certain styles/size combinations compare from store to store in multi-store configurations.

The report totals net sales for the Sale transactions selected as of the date the report is ran and DOES NOT take in effect the dates of when adjustments were made to those sales. For example, running the Sales Detail report for a past month includes the adjustments made in the current month to that sale transaction because the report analyzes the NET selling price for the item regardless when the adjustments were made to the sale transaction. As a result the totals of this report cannot be compared to other sales reports, like sales by category that are date sensitive for both the sale transaction and the adjustment transaction.

For example, assume you sell these items: * Sept 20, sale of style 123 * Oct 2, adjustment to sale of style 123 * Oct 3, sale of style 456

If you run the Sales by Category report for Oct, you'll see the adjustment to 123 and the sale of 456 since they both occurred in Oct.

If you run the Sales Detail report for Oct, you'll only see the sales of dress 456, because the sale happened in Oct. You won't see that adjustment to dress 123 since it comes from the sale which occurred in Sept. ​ Also, if the net retail is zero on the Sales by Detail report, it means that you had net zero sales for that style in that time period. For example, a sale that was mark-downed or canceled.

Criteria

Select transactions...Only sales that fall within the date range specified will print. You must enter a date range. The date range can mean one of two things, depending on your selection:

  • Sold between xxx and yyy: Print items that were sold between the dates specified, regardless of when (or if) the revenue has been realized.
  • Revenue realized between xxx and yyy: Only print items where the revenue has been realized within the date range specified. On the cash accounting method, these options are identical.

Limit to category/sub-category...You can limit the report to a specific category and sub-category.

Limit to vendor...You can limit the report to a specific vendor, if you like.

Limit to stores...This option is available with the optional multi-store module. It will limit sales to the entered stores. Multiple store IDs may be entered separated by a comma.

Only show items where the revenue has been realized?...This will only show items where the revenue has been realized during the date range specified. Include rental transactions...If checked, the report will include rental transactions under the category RENTAL. RENTAL is a system defined category and cannot be directly used on retail inventory. This option is only available with TPS/TPOS

Show items...You can choose what types of sales to include: * Sold from Stock * Special Order * Stock and Special Order

Sort...You can choose how the report should be sorted and broken down. If the first sort order is chosen, then the report will first be grouped and sub-totaled by vendor, then by category/sub-category, and finally by style/size/color/width/store, with separate records for each store. If the second sort is selected, the report will be grouped by category/Sub-cat (not by vendor) then by style/size/color/width/store.

  • Vendor/Category/Sub-cat/Style
  • Category/Sub-cat/Style
  • Style