Sales Order Entry - Shopping List - Past Sales overview

Sales > Entry > Order

Use this page to specify a date range and other criteria to create a Shopping List that displays products that were previously purchased by the customer, ship to, and warehouse on the order.

Past sales activities are based on SM Setup Extended – Warehouse/Product Totals records.

To use the past sales feature, these options must be selected:

  • Update Sales Manager in Customer Setup-Ordering
  • Sales Manager in Product Warehouse Product Setup-General
  • Sales by Customer,by Product,by Whse (SMSEW) in SA Administrator Options-Sales History-Levels
  • Yes for Update Sales Manager? in the Sales Entry Invoice Processing Report

The monthly sales volume for each product is displayed, based on the range that you specify.

Direct ship products are not included in the Shopping List unless you are creating a Direct Order (DO). You can only order Direct Ship products as a DO. If a product had a status of Stock on a past sale but now has a status of Direct Ship, the history of past sales is not removed but the product is not included in the list.

You can expand the Past Sales list to include products that were sold from other warehouses and to other ship tos. To make this information available, the appropriate value must be selected in the OE Shopping List Past Sales field in SA Administrator Options-Documents-Sales Orders-Entry Settings. You must then select All Warehouses? and All Ship Tos? when you create the list.

Note: If you receive a timeout error when searching for a large number of past sales, you can activate batch call processing for the Past Sales search.

When you select Use Advanced Polling Interface Logic for Designated Service Interface Calls in SA Administrator Options-System-General, you can select the Shopping List Populate - shoppinglistpopulate service interface call from the Available Advanced Polling Calls list. With this service interface call selected, when you select Past Sales in Sales Order Entry-Shopping List, a batch process is initiated when you specify the criteria and click Search that runs outside of the normal Service Interface calls which must complete within a system timeout limitation of 1 minute. Batch call processing allows the past sales search process to complete without timeout errors.