Changing stock levels and values
Overview
You can make direct adjustments to stock level directly from My Inventory screen.
My Inventory stock control fields explained:
- The stock level fields will be visible on My Inventory screen only if you have selected location in Show Location.
- If you have multiple locations, you can review and change stock levels for each location by clicking + next to the stock item record. This will display a sub grid with stock levels for each location.
- Level column - shows current stock level for the selected location. This is physical stock before processing any outstanding open orders.
- Stock Value - is dynamically calculated value that automatically keeps track of the cost of your stock. This is worked out from single unit cost i.e. Stock Value / Stock Level. When you acquire new stock through a purchase order the system will increase the stock value based on the value specified in the purchase order. When you sell or make any adjustments to the stock the system automatically recalculates your actual stock value based on the unit cost. Note that Unit Cost is not a simply a Purchase Price value. Unit value is calculated based on the actual cost of stock rather than fixed value. For example if you purchased 10 Mailing Bags today for $0.10 each your stock value will be $1.00, making each unit cost $0.10. So when you sold one, the stock value will be changed to $0.90. If you then purchased another 10 Mailing Bags but paid $0.15 for each, your stock value becomes $2.40 ($0.90 + 10 * $0.15) where each unit costs around $0.12, ($2.40 / 19). In other words stock value is calculated based on mean averaged value of all units.
- Minimum Level - threshold which indicates the minimum stock level which will cause the system to prompt you to reorder stock.
- Due - number of items due to be delivered from the supplier.
- Available - (read only) number of items available. This is calculated field showing stock level minus number of items in open orders.
- Not Tracked flag - not tracked switch allows you to instruct the system to disregard any stock tracking functions for this item. This is also used to tell the system to calculate stock level dynamically when this stock item is part of a composition (i.e. the stock level for this item will be calculated from stock level of child items). When Not Tracked is set (Red) the minimum level is set to -1. To set or unset Not Tracked double click on the cell.
To make adjustments to the stock level
- find the product you want to make adjustment in the My Inventory grid,
- double click on the Stock Level cell (or start typing in the cell)
- To apply the changes hit enter – DO NOT click away from the cell – it will result in the error.
