Collapse AllExpand All

15. Lost Sales Reporting

Lost sales reporting is another feature found in the xWD package. The lost sales reports can be found under Sales > Reporting > Lost Sales. The characteristics infrastructure drives the reporting on lost sales opportunities. This means that to capture lost sales information, you need to define a characteristic for lost sales. To define a characteristic, navigate to Sales > Setup > Characteristics. The following screenshot illustrates the process for entering a new characteristic:

Characteristic for lost sales

When entering a new characteristic for lost sales, follow these steps:

  1. Assign a Name that can be found later.

  2. Select List under Type and mark the check box: Include in searches

  3. Select item in the May be used on field.

  4. On the Options tab, add as many valid lost sale reasons as you want to track.

For an item to appear on the lost sales report, it needs to have been canceled (i.e., removed) from a sales order. Let's see the process flow for canceling an item from a sales order. First, you need to open an existing sales order with an item you want to cancel. From the Sales Order Line Items tab, select an item you want to cancel and open it for editing:

Sales Order

Once you are editing the sales order item, select the CANCEL ITEM button:

Sales Order Item

When you cancel the item, you will be presented with a prompt for lost sales tracking, as shown below:

Lost Sale

Select your lost sale reason from the available list. To view the reporting for this lost sales activity, navigate to Sales > Reports > Lost Sales, as shown below:

Lost Sales

The lost sale with the selected reason code attached is now visible.