Product Sales Inquiry

Menu Path: Customer Service Images\bluerarw.gif Inquiries Images\bluerarw.gif Sales Images\bluerarw.gif Product Sales Inquiry

Purpose

View sales for a specific product based on an invoice date range.

Overview

Use Product Sales Inquiry to display sales for a specific product based on an invoice date range. You can display sales by invoice or a summary of sales for individual customers. You can filter the inquiry by product or product category.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Product Sales Inquiry window.

Show Data

Click this button to display sales information on the Results tab, based on the criteria selected on the Select tab.

Order Relationship Inquiry

Click this button to display Order Relationship Inquiry, which allows you to view the relationship between orders, pick demands, and invoices. You must select an invoice on the Results tab before you click this button.

Credit Inquiry

Click this button to display Customer Aging and Credit Inquiry, which allows you to view aging and credit information for the customer for a selected invoice. You must select an invoice on the Results tab before you click this button.

Ribbon Filters Tab Buttons

Button

Description

Modify My Additional Filters

Click this button to display Screen Additional Filters Maintenance, which allows you to set up additional filters for the Product Sales Inquiry window.

Select Tab Fields and Buttons

Field or Button

Description

All Products

Select this check box to display sales for all products. This check box is selected by default.

Product Code

Enter a product code for which to display sales, or click the Lookup button to select a product code. This field is only enabled if you clear the All Products check box.

Name (Product)

Enter a product name for which to display sales, or click the Lookup button to select a product name. This field is only enabled if you clear the All Products check box.

All Categories

Select this check box to display sales for all product categories. This check box is selected by default.

Category Code

Enter a product category for which to display sales, or click the Lookup button to select a product category. This field is only enabled if you clear the All Categories check box.

All Subcategories

Select this check box to display sales for all product subcategories. This check box is selected by default and only enabled if you enter a product category in the Category Code field for which subcategories exist.

Subcategory Code

Enter a product subcategory code for which to display sales, or click the Lookup button to select a product subcategory code. This field is only enabled if you clear the All Subcategories check box.

Name (Subcategory)

Enter a product subcategory name for which to display sales, or click the Lookup button to select a product subcategory name. This field is only enabled if you clear the All Subcategories check box.

Range

Select whether to display sales for a range of dates or periods. The Date radio button is selected by default.

From Date (Range 1)

Enter a date for which to display sales, or click the drop-down arrow to select a date. If you want to display sales for a range of dates, enter the first date in the range.

To Date (Range 1)

Enter the last date in a range of dates for which you want to display sales, or click the drop-down arrow to select a date. If you want to display sales for a single date, you can leave this field blank.

From Period (Range 1)

Click the Lookup buttons to select a period and year, that is, the first period and year in a range of periods and years for which to display sales. This field is only available if the Period radio button is selected.

To Period (Range 1)

Click the Lookup buttons to select a period and year, that is, the last period and year in a range of periods and years for which to display sales. This field is only available if the Period radio button is selected.

Range 2

Select this check box if you want to compare data for two ranges of dates.

From Date (Range 2)

Enter the first date in a second range of dates for which you want to display sales, or click the drop-down arrow to select a date. This field is only enabled if the Range 2 check box is selected.

To Date (Range 2)

Enter the last date in a second range of dates for which you want to display sales, or click the drop-down arrow to select a date. This field is only enabled if the Range 2 check box is selected.

From Period (Range 2)

Click the Lookup buttons to select a period and year, that is, the first period and year in a second range of periods and years for which to display sales. This field is only available if the Period radio button is selected, and is only enabled if you select the Range 2 check box.

To Period (Range 2)

Click the Lookup buttons to select a period and year, that is, the last period and year in a second range of periods and years for which to display sales. This field is only available if the Period radio button is selected, and is only enabled if you select the Range 2 check box.

Customer/Billing Customer

Select whether to display sales information for customers or billing customers.

All Customers/All Billing Customers

Select this check box to display sales information for all customers or billing customers. This check box is selected by default.

Customer Code/Billing Customer Code

Enter a customer code for which to display sales, or click the Lookup button to select a customer code. This field is only enabled if you clear the All Customers or All Billing Customers check box.

Name (Customer/Billing Customer)

Enter a customer name for which to display sales, or click the Lookup button to select a customer name. This field is only enabled if you clear the All Customers or All Billing Customers check box.

All Shipping Locations

Select this check box to display sales information for all shipping locations. This check box is selected by default.

Location (Shipping)

Enter a shipping location prefix or name for which to display sales, or click the Lookup buttons to select a shipping location prefix or name. This field is only enabled if you clear the All Shipping Locations check box. For more information on shipping locations, see Sales Location / Shipping Location.

All Sales Locations

Select this check box to display sales information for all sales locations. This check box is selected by default.

Location (Sales)

Enter a sales location prefix or name for which to display sales, or click the Lookup buttons to select a sales location prefix or name. This field is only enabled if you clear the All Sales Locations check box. For more information on sales locations, see Sales Location / Shipping Location.

All Sales Teams

Select this check box to display sales information for all sales teams. This check box is selected by default.

Sales Team ID

Enter a sales team ID for which to display sales, or click the Lookup button to select a sales team ID.

Note The Lookup window that appears when you click the Lookup button only displays sales teams marked as active in Sales Team Maintenance.

This field is only enabled if you clear the All Sales Teams check box.

All Sales Representatives

Select this check box to display sales information for all sales representatives. This check box is selected by default.

Sales Representative ID

Enter a sales representative ID for which to display sales, or click the Lookup button to select a sales representative ID. This field is only enabled if you clear the All Sales Representatives check box.

Mode

Select a method for displaying sales information on the Results tab. Select Invoice to display invoices on the Results tab, or select Customer to display sales for customers on the Results tab. If you select Customer, you can double-click a customer on the Results tab to display invoices for that customer in a second Product Sales Inquiry window.

Costing

Select a cost type option. You can select the sales cost, accounting cost, or commission cost. For more information, see Product Location Maintenance.

Status

Select whether to display invoices that were posted to the general ledger, only unposted invoices, or both posted and unposted invoices.

Currency

Click the Lookup button to select the currency for the Results tab. The currency defaults to the default general ledger currency.

Include Cost of Products Returned and Not Restocked

Select this check box to include costs associated with returns that are not re-salable (and not put back into inventory).

Note Additional filters may appear in the My Additional Filters section if filters are set up in Screen Additional Filters Maintenance, or set up and loaded from an additional filters template in Additional Filters Template Maintenance.

Additional Customer Filters Tab Fields and Buttons

This tab may include additional customer filters if filters are set up in Screen Additional Filters Maintenance, or set up and loaded from an additional filters template in Additional Filters Template Maintenance.

Additional Product Filters Tab Fields and Buttons

This tab may include additional product filters if filters are set up in Screen Additional Filters Maintenance, or set up and loaded from an additional filters template in Additional Filters Template Maintenance.

Results Tab Fields and Buttons

Field or Button

Description

Invoices/Customers

This grid displays sales information for the criteria specified on the Select tab. Each row displays information for an invoice or a customer based on whether you selected the Invoice or Customer radio button on the Select tab. Double-click an invoice to display Invoice Inquiry, which allows you to view detail information for the invoice. If you selected the Customer radio button on the Select tab, double-click a customer in the grid to display invoices for that customer in a second copy of the Product Sales Inquiry window.

R1 Total Sales

This field displays the range 1 total sales, calculated as the sum of the total sales values in the R1 Total Sales column in the Invoices or Customers grid.

R1 Margin

This field displays the range 1 total gross margin, calculated as the sum of the margin values in the R1 Margin column in the Invoices or Customers grid.

R1 Margin %

This field displays the range 1 margin percentage, calculated as the range 1 total margin divided by the range 1 total sales.

R1 Total Net Units

This field displays the range 1 total net units sold, calculated as the sum of the units sold values in the R1 Net Units column in the Invoices or Customers grid.

R2 Total Sales

This field displays the range 2 total sales, calculated as the sum of the total sales values in the R2 Total Sales column in the Invoices or Customers grid.

R2 Margin

This field displays the range 2 total gross margin, calculated as the sum of the margin values in the R2 Margin column in the Invoices or Customers grid.

R2 Margin %

This field displays the range 2 margin percentage, calculated as the range 2 total margin divided by the range 2 total sales.

R2 Total Net Units

This field displays the range 2 total net units sold, calculated as the sum of the units sold values in the R2 Net Units column in the Invoices or Customers grid.