Sales Details Overview
The A/R Sales Details report provides a comprehensive, invoice-level breakdown of Accounts Receivable sales activity within Inspired ERP. This report is commonly used by accounting, finance, and operations teams to analyze invoiced sales, open balances, paid invoices, applied credits, and overall payment status across customers and accounting periods.
Each record in the Sales Details report represents one order detail line, making it ideal for detailed sales analysis, auditing revenue, reconciling invoices, and exporting data for reporting or review.
To View the Sales Details Report:
1. Navigate to Reports → Sales → Sales Details page. This opens the Sales Details report with a full set of filtering and subtotal options available at the top of the page.
2. You are now viewing all of the sales details (one record per order detail line) across all customers. From here, filters can be applied to narrow results by period, date range, item, service, description, or subtotal grouping.
To Limit by Period:
1. Enter a period in YYMM format and click the Search Button. This allows you to review sales activity for a specific accounting period.
Example:Period 10 of 2024 -> YYMM = 2410

To Limit by Date:
1. Enter either a From Date, To Date or both a From and To Date and click the Search Button. This option is useful when reviewing sales activity for a specific timeframe that does not align exactly with an accounting period.
To Limit by Item Number:
1. Enter the Item Number and click the Search Button. This filter allows you to analyze sales details for a specific product or inventory item across customers and invoices.
To Limit by Service:
1. Enter the Service and click on the Search Button. This option is commonly used to review billable services, storage charges, handling fees, or other service-based sales activity.
To Limit by Description:
1. Enter a description and click the Search Button. Filtering by description helps locate sales detail lines based on text entered on invoices or order lines.
To Generate Subtotals:
Example 1: Subtotal by Service
1. Select the appropriate option from the Subtotal By Drop Down.

2. Enter either a Period or a From/To Date (Required).
3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
Note:For the service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's transactions.

4. Click on Download Table to download an Excel Spreadsheet of the current table.

Example 2: Subtotal by Address ID
1. Enter a Customer name (Required).

2. Select the appropriate option from the Subtotal By Drop Down.

3. Enter either a Period or a From/To Date (Required).
4. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
Note:For the address ID subtotal selection, entries will be shown by address ID in descending date order with a subtotal at the end of each address ID's transactions.

5. Click on Download Table to download an Excel Spreadsheet of the current table.
Example 3: Subtotal by Item
1. Select the appropriate option from the Subtotal By Drop Down.

2. Enter either a Period or a From/To Date (Required).

3. Click on the
Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
Note:For the item subtotal selection, entries will be shown by item in descending date order with a subtotal at the end of each item's transactions.

4. Click on Download Table to download an Excel Spreadsheet of the current table.

Example 4: Subtotal by Item Class
1. Select the appropriate option from the Subtotal By Drop Down.

2. Enter either a Period or a From/To Date (Required).

3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
Note:For the item class subtotal selection, entries will be shown by item class in descending date order with a subtotal at the end of each item class's transactions.

4. Click on Download Table to download an Excel Spreadsheet of the current table.

Example 4: Subtotal by Order Salesman
1. Select the appropriate option from the Subtotal By Drop Down.

2. Enter either a Period or a From/To Date (Required).

3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
Note:For the order salesman subtotal selection, entries will be shown by order salesman in descending date order with a subtotal at the end of each order salesman's transactions.

4. Click on Download Table to download an Excel Spreadsheet of the current table.