Lost Sales F/M (SOF930)

You should enter information in the Lost Sales F/M during initial installation and setup. Thereafter, it is updated by the Daily Sales Register update. Any changes you make via this program after the system is operational may compromise data.

NOTE: Entering original information into this file is optional.

Lost sales are recorded during the Daily Sales Register update when the backordered quantity was 0, but you did not ship all the items ordered. For example, if the customer ordered 5 and the shipped quantity was 3 and the backordered quantity was 0, then the lost sales would record 2.

Lost sales information may be displayed by printing the Lost Sales Report. Records may be removed from the Lost Sales File using the optional removal at the end of the Lost Sales Report or through the delete option in this file maintenance.

Before using this program, make sure the Use Lost Sales tracking flag is selected or set to Y in the SO Static Control F/M.

Field Descriptions

Use the following fields to create lost sale reason codes for items by warehouse:

1. Warehouse

Enter the warehouse code. The entry must be a valid warehouse. The warehouse entered is where lost sales are tracked for the item in the Item field. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F2 or image\find_shg.gif to search.

2. Item

Enter the item number. Entering a valid number sets the defaults for item descriptions 1 and 2 from the Item File. Lost sales are recorded for this item and warehouse. Press F2 or image\find_shg.gif to search. Press F3 or image\ex_allft_shg.gif to default to the first record on file.

3. Reason Code

Enter the reason code for this lost sale. The entry must be a valid reason code. Press F2 or image\find_shg.gif to search. Press F3 or image\ex_allft_shg.gif to default to the first record on file.

4. Description 1

Enter item description 1. If the item is a valid item, press Enter (CR) to initially default to description 1 as set in the Item F/M for that item; otherwise press Enter (CR) to default to NOT ON FILE.

5. Description 2

Enter item description 2. If the item is a valid item, press Enter (CR) to initially default to description 2 as set in the Item F/M for that item.

6. Selling UM

Enter the selling unit of measure for the item (up to 2 characters). If the item is a valid item, press Enter (CR) to initially default to the selling unit of measure as set in the Item F/M for that item; otherwise, press Enter (CR) to default to EA (each).

7. Total Requests

Enter the number of times this item was a lost sale (0-9999). (E.g., the user may have sold the item three times, losing 4 sales each of the last two times - enter 2.) Press Enter (CR) to initially default to 0.

8. Total Units

Enter the total lost quantity of sales for this selling unit of measure for this item (0-9999999.99). (E.g., the user may have sold the item three times, losing 4 sales each of the last two times - enter 8.) Press Enter (CR) to initially default to 0.

9. Total Dollars

Enter the total value of lost sales for this item (0-99999999.99). Press Enter (CR) to initially default to 0.

See Also

For more detailed information on file maintenance programs, consult the following topics.

How to use File Maintenance programs