Summary
The Lost Customer Ship-To screen tells StockIQ that a customer ship-to has stopped buying every item from you, for example because it has closed. StockIQ then removes that ship-to's past sales of all items from the demand history the forecast is built on.
It is accessible by clicking Admin > System Configuration > Lost Customer Ship-To, under Customers > Ship-To Demand Mapping. You need the Edit Customer Mappings permission to see it.
To remove demand for only some items, use the Lost Item-Customer screen (a whole customer) or the Lost Item Customer Ship-To screen (one ship-to).
IMPORTANT: This screen removes sales that have already happened. It cannot lower the forecast for future months only, starting on a date you choose.
Grid Columns
To add a record, click the + icon at the right-hand side of the grid, fill in the new line, and click Save.
IMPORTANT: Records are applied during StockIQ's next refresh, so you will not see a change in the forecast until after it runs.
- Customer Ship To- The ship-to that has stopped buying from you. Other ship-tos of the same customer are not affected.
- Date Effective- The day StockIQ starts applying the record. Until then, the record does nothing. If left blank, it applies right away.
- Date Expires- The day StockIQ stops applying the record. This is not commonly used.
- Start Date- The earliest sales StockIQ removes. Sales before this date are kept. If left blank, StockIQ removes sales from the beginning of the history. This is not commonly used.
- End Date- The latest sales StockIQ removes. Sales after this date are kept. If left blank, StockIQ removes sales up to today. This is not commonly used.
- Note- Any note to help you remember why you added the record.
How the dates work together
Date Effective and Date Expires control when the record is switched on. Start Date and End Date control which past sales are removed while it is on. Because only past sales can be removed, a Start Date in the future removes nothing, and the forecast does not change.
Customers who stop buying on a future date
If a ship-to will stop buying on a future date and you need the forecast to show the drop now, see Planning for a customer who stops buying on a future date in the Lost Item-Customer article. The same steps apply here.
Checking that a record is working
For each item-site where it removes sales, the record creates an event named Lost Customer Ship-To <ship-to name>, customer <customer name> in the Lost Customer event group. Look for it on the Event Editor screen after the next refresh. If there is no event, the record didn't remove anything.