Menu Path: Purchasing Inquiries Distribution Resource Planning Point of Sale Inquiry
Review point-of-sale and other product activity data for mass merchant stores.
Use Point of Sale Inquiry to review point of sales sell through for DRP purchase planning. For point of sale set up information, see Point of Sale Region Maintenance.
For information on importing point of sale data, see EDI Product Activity Import.
Button |
Description |
Exit |
Click this button to close the Point of Sale Inquiry window. |
Show Data |
Click this button to refresh data on the View tab. |
Graph |
Click this button to graph data on the Graph tab based on the selected rows in the Store Specific grid on the View tab. When you click this button, the Graph Based On dialog box appears, and allows you to select the data you want to graph. This button is only available if the View tab is selected. |
Field or Button |
Description |
Select this check box to display point of sale information for all products. This check box is selected by default. |
|
Enter a product code for which to display point of sale information, or click the Lookup button to select a product code. This field is only enabled if you clear the All Products check box. |
|
Enter a product name for which to display point of sale information, or click the Lookup button to select a product name. This field is only enabled if you clear the All Products check box. |
|
Select this check box to display point of sale information for all product categories. This check box is selected by default. |
|
Enter a product category for which to display point of sale information, or click the Lookup button to select a product category. This field is only enabled if you clear the All Categories check box. |
|
Enter a product category name for which to display point of sale information, or click the Lookup button to select a product category name. This field is only enabled if you clear the All Categories check box. |
|
Select this check box to display point of sale information 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. |
|
Enter a product subcategory code for which to display point of sale information, or click the Lookup button to select a product subcategory code. This field is only enabled if you clear the All Subcategories check box. |
|
Enter a product subcategory name for which to display point of sale information, or click the Lookup button to select a product subcategory name. This field is only enabled if you clear the All Subcategories check box. |
|
Select this check box to display point of sale information for all forecast groups. This check box is selected by default. |
|
Enter a forecast group for which to display point of sale information, or click the Lookup button to select a forecast group. This field is only enabled if you clear the All Forecast Groups check box. |
|
Enter a forecast group name for which to display point of sale information, or click the Lookup button to select a forecast group name. This field is only enabled if you clear the All Forecast Groups check box. |
|
Select this check box to display point of sale information for all shipping locations. This check box is selected by default. |
|
Enter a shipping location prefix for which to display point of sale information, or click the Lookup button to select a shipping location prefix. This field is only enabled if you clear the All Shipping Locations check box. |
|
Enter a shipping location name for which to display point of sale information, or click the Lookup button to select a shipping location name. This field is only enabled if you clear the All Shipping Locations check box. |
|
Select this check box to display point of sale information for all point of sale regions. This check box is selected by default. |
|
Enter a region ID for which to display point of sale information, or click the Lookup button to select a region ID. This field is only enabled if you clear the All Regions check box. Point of sale regions are set up in Point of Sale Region Maintenance. |
|
Enter a region name for which to display point of sale information, or click the Lookup button to select a region name. This field is only enabled if you clear the All Regions check box. Point of sale regions are set up in Point of Sale Region Maintenance. |
|
Select this check box to display point of sale information for all customers. This check box is selected by default. |
|
Enter a customer code for which to display point of sale information, or click the Lookup button to select a customer code. This field is only enabled if you clear the All Customers check box. |
|
Enter a customer name for which to display point of sale information, or click the Lookup button to select a customer name. This field is only enabled if you clear the All Customers check box. |
|
Select this check box to display point of sale information for all stores for the specified customer. This check box is selected by default, and is only enabled if you clear the All Customers check box. |
|
Enter a store ID, or click the Lookup button to select a store ID. This field is only enabled if you clear the All Stores check box. Note Store information is imported using EDI Product Activity Import. Stores can be linked to customer ship-to addresses using the Store ID field. If linked, then you can click the Lookup button to display the list of stores for the selected customer. If not linked, you can still enter a store ID directly (without validation). |
|
Select whether to display point of sale information for months, weeks, or days. |
|
Enter the number of past and future months, weeks, or days for which to display point of sale information. The selected Time Bucket option controls whether these fields are months, weeks, or days. Enter a negative sign to display a number of months, weeks, or days before the current month. |
|
Select this check box to display quantities sold. |
|
Select this check box to display quantities on hand. |
|
Select this check box to display quantities in transit. |
|
Select this check box to display on order quantities. |
|
Select this check box to display received quantities. |
|
Select this check box to display adjustment quantities. |
|
Select this check box to display returned quantities. |
|
Select this check box to display damaged quantities. |
|
Select this check box to display transferred quantities. |
|
Select this check box to display forecast quantities. |
|
Click the Lookup button to select a primary method for sorting data. You can sort by the following:
|
|
Click the Lookup button to select a secondary method for sorting data. If Forecast Group is selected in the Primary field, you can sort by the following:
If Category is selected in the Primary field, you can sort by the following:
If Product Line is selected in the Primary field, you can sort by the following:
If Product Code is selected in the Primary field, you can only sort by Forecast Group/Region/Store ID. |
Field or Button |
Description |
This grid displays store-specific point of sale information. Select a product to view totals for it in the Forecast Group Totals and Totals grids. The time bucket columns display based on the number of months entered in the Time Range section on the Selection tab. You can select more than one row in this grid, and then click the Graph button in the ribbon to create a line graph of the data. Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid. |
|
This grid displays a subtotal by forecast group for the product selected in the Store Specific grid. For each check box selected in the Quantity Types section on the Selection tab (e.g., On Hand, Sold, etc), a separate row displays for a forecast group subtotal. The time bucket columns display based on the number of months entered in the Time Range section on the Selection tab. Note The Customer Code and Store ID columns are empty in this grid because they do not have meaning in this context. |
|
This grid displays the grand total for the product selected in the Store Specific grid. For each check box selected in the Quantity Types section on the Selection tab (e.g., On Hand, Sold, etc), a separate row displays for the product grand total. The time bucket columns display based on the number of months entered in the Time Range section on the Selection tab. Note The Customer Code and Store ID columns are empty in this grid because they do not have meaning in this context. |
Field or Button |
Description |
This grid displays store-specific point of sale information. Select a product to view totals for it in the Forecast Group Totals and Totals grids. The time bucket columns display based on the number of months entered in the Time Range section on the Selection tab. You can select more than one row in this grid, and then click the Graph button in the ribbon to create a line graph of the data. Note This grid is cached to improve performance. You cannot sort, filter, group, graph, or summarize data in this grid. |