This table walks you through a Point of Sale Store Lifecycle and how inventory buckets are impacted as different transactions are happening in-store.
Actions and Inventory Buckets
| Action | On Hand | Allocated | Available | In Transit | On Order | Floor Demo | Not For Sale | Returned Item | Safety Stock | Comment 1 | Comment 2 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Incoming ASN | + | In Transit Does not go neg | In Transit, Reduce the Full amount of the line item Qty on the ASN even if it is Short or over | ||||||||
| Receiving | + | + | - | ||||||||
| Adjustment (Neg) | - | - | |||||||||
| Adjustment (Pos) | + | + | |||||||||
| Adjustment Batch Deleted | No action Required | ||||||||||
| STS Transfer Pack | + | - | |||||||||
| STS Transfer Ship | - | - | |||||||||
| STS Transfer Ship to Destination Store | + | ||||||||||
| STS Transfer Delete Batch | - | + | |||||||||
| RTV | - | - | - | If QTY in Ret, do not reduce Avail | |||||||
| BOPIS Created | + | - | |||||||||
| BOPIS Sold | - | - | |||||||||
| BOPIS Canceled | - | + | |||||||||
| BOFIS Created | + | - | |||||||||
| BOFIS Shipped | - | - | |||||||||
| BOFIS Canceled | - | + | |||||||||
| Cycle Count (Overlay flag on) | Actual Count | Actual Count | All other Inv Buckets are "0" | ||||||||
| Inventory Full Feeds | Actual Count | Recalculate | |||||||||
| Delta Feeds | Actual Count | Recalculate | |||||||||
| Returns (Back to Stock) | + | + | |||||||||
| Returns (Back to Return) | + | - | + | ||||||||
| Returns (Not For Sale) | + | - | + | ||||||||
| ADJ - Floor Demo (Pos) | - | + | |||||||||
| ADJ - Floor Demo (Neg) | + | - | |||||||||
| ADJ - Not for Sale (Pos) | - | + | |||||||||
| ADJ - Not for Sale (Neg) | + | - | |||||||||
| ADJ - Safety Stock (Pos) | - | + | This Qty Could be sent from the Retailer | ||||||||
| ADJ - Safety Stock (Neg) | + | - | This Qty Could be sent from the Retailer | ||||||||
| On Order is Actual from Inv File | Actual Qty |
For StoreInventory snapshots, the default columns and their corresponding buckets are:
- Quantity - Available
- QuantityOnOrder - On Order
- AllocatedQuantity - Allocated
- QuantityOnHand - On Hand
- QuantityInTransit - In Transit
- NotForSaleQuantity - Not For Sale
- ReturnedItemsQuantity - Returned Items
- FloorDemoQuantity - Floor Demo
- SafetyStock - Safety Stock