Minimum Version Required: 23.07
Steps
How to Manage Oversold Products
Using Universal Search, navigate to the Oversold Products dashboard
Apply filters to view information for specific Locations, Suppliers, Products, On Premise, Customer Type and Dates then click Save & Refresh
Sections in the Oversold Products status panel:
- Oversold Product: Products that have been Oversold and not back-ordered/backfilled. Click a Product for a detailed view of all invoices contributing to its Oversold status
- Available for Backfill - Products that have previously been Oversold and Backordered that can be Backfilled with new inventory
- Not Available -Products that have previously been Oversold and Backordered but cannot yet be backfilled
Click a Product in the status panel to display information and the invoices the Oversold product is on
Using the Oversold Product Tools, determine the best process to manage the Product on Invoices:
- Invoice All: Fill the ordered quantity for all invoices for the product, regardless of inventory levels
- Auto-Backfill: Fill orders with available inventory for each invoice for the selected product. (NOTE: The first available item is allotted to the Customer with the most weekly sales)
- Auto-Reduce: Reduce the Oversold product evenly among each Invoice. (NOTE: The Customer Invoice with the most weekly sales will be reduced first)
- Backorder All: Backorder all invoice transactions for the selected products, regardless of inventory levels
- Swap Product: To replace the selected product, select a new product from the drop-down and click SWAP ALL to apply the swap
Click Save & Refresh
Repeat Steps 4-6 until all Oversold products listed have been addressed
Fields And Definitions
On Floor: The value from the on floor inventory value.
Pre-Sales: This value has been pulled from the pre-sales inventory.
Allocated Available: This is the value from allocated on the inventory table.
Non-Allocated Available: = On Floor - Pre-Sales - Allocated Available
Auto-Reduce All: This will reduce the oversold amount one invoice at a time for all products that are oversold. The system will cut one from the customer that ordered the most, then one from the customer that ordered the second most, and so on. This process will repeat until the product is no longer oversold. The cut product will be backordered.
Auto-Backfill All: This fill orders with available inventory for each invoice for all products that are available for backfill. The customer that ordered the most product will get the first available item, the customer that ordered the second most will get the next available, and so on. This cycle will repeat until all available inventory is filled on orders
Invoice All: Fill the ordered quantity for all invoices for the product, regardless of inventory levels.
Auto-Backfill: Fill orders with available inventory for each invoice for the selected product. (NOTE: The first available item is allotted to the Customer with the most weekly sales)
Auto-Reduce: Reduce the Oversold product evenly among each Invoice. (NOTE: The Customer Invoice with the most weekly sales will be reduced first)
Backorder All: Backorder all invoice transactions for the selected products, regardless of inventory levels
Swap Product: To replace the selected product, select a new product from the drop-down and click SWAP ALL to apply the swap
Best Practices
Best Practice is to process oversold product before palletizing load sheets. This will prevent out of stock items from being palletized.