The Lost Sales Report program allows you to print a report of items with recorded lost sales. Lost sales are recorded when the backordered quantity was zero but the user did not ship all the items ordered.
The Lost Sales Report is only available if the Use Lost Sales flag is set to Y in the SO Static Control Record.
Report information includes the following: item number, item description, number of times the item was a lost sale (number of requests), the reason code for the lost sale, total lost quantity of sales, selling unit of measure, total dollar value of lost sales, and whether usage is updated from the lost sale for the item. Report totals include total dollar value of lost sales for all items in the selected warehouse and printed on the report. The total number of items listed is also included.
Use the following fields to print a Lost Sales Report:
1. Order
Enter the order to use to print the report. You can select from D-Date, C-Customer, I-Item, R-Reason Code, or Salesperson order. Press enter to default to C-Customer. Note: when you specify a print order, the corresponding field in the Properties section is disabled.
2. Beginning range
Enter the beginning range value (date, customer, item, reason code or salesperson depending on your selection for prompt # 1).
3. Ending range
Enter the ending range value (date, customer, item, reason code or salesperson depending on your selection for prompt # 1).
4. Warehouse
Enter the warehouse codes to printside by side for which the report is to print. The program defaults to the warehouse assigned to the terminal.
5. Item
Enter the item to restrict the print out by. Note that if you specified to print in Item order, this field is disabled.
6. Item Type
Enter the type of item to print: Stocked items, Nonstocked items, Uninventoried items.
7. Customer
Enter the customer to print for. Note that if you specified to print in Customer order, this field is disabled.
8. Ship To
If you specified a customer, you can enter the Ship To location to use for the report.
9. Slsp/Terr
Enter the salesperson or territory code for the report. Note that if you specified to print in Salesperson order, this field is disabled.
10. Beginning and Ending Date
Enter the beginning and ending invoice or credit memo dates to use for the report. Note that if you specified to print in Date order, these fields are disabled.
11. Reason Code
Enter the lost sale reason code for which to print. If all reason codes are entered (CR), subheadings with each reason code will be printed for each item. For each item, lost sales for each reason code will be printed along with the total lost sales for that item. Note that if you specified to print in reason code order, this field is disabled.
See Also