Inventory Terms and Information
QuickEasy BOS has a scalable inventory system. As the system is developed or features are requested, the Inventory module will be expanded to provide more complex inventory management tools.
The inventory system relies on Entities, Items and Transactions to work. This page explains the terms, how everything fits together and the related settings.
Inventory Terms
These terms align with common ERP and inventory management terminology.
| Term | Description |
|---|---|
| Bin | A subdivision within an inventory location (e.g. a shelf or container). Not available yet, but might be added in the future. |
| Cycle Count | A periodic physical count of a subset of inventory to verify stock accuracy, as best practice for auditing. May trigger the need for Stock Adjustments. |
| Inventory | The total collection of goods, materials or products a business holds for sale, use or production. Includes all items that represent tangible objects and are stored at physical locations. |
| Inventory Location | The location where the stock is stored, managed or tracked from. Locations are a type of entity and can be nested (e.g. a Factory location nested under the Printing Dept. department). |
| Inventory Valuation | The monetary value of inventory. Relevant for financial reporting. Multiplies the Quantity on Hand by the stock item’s Unit Price. The Unit Price is calculated using methods such as FIFO, LIFO or Average Cost. In QuickEasy BOS, the Unit Price is the item’s Stock Price at the location: entered manually, or kept up to date as a moving weighted average (see Item Prices Explained). If no stock price is entered, the cost price is used. |
| Issue | The process of removing stock from an inventory location, typically for sale, use or transfer. Decreases Quantity on Hand. Logged as a transaction. |
| Multi-Location Inventory | A system where stock is distributed and tracked across multiple inventory locations. In QuickEasy BOS, multiple inventory locations are managed as follows:
|
| Quantity on Hand | The current quantity of a Stock Item that is available at a specific Inventory Location. A core metric, tracked per location in the stock table. |
| Receive | The process of adding stock to an inventory location, typically from a supplier or production. Increases Quantity on Hand. Recorded as a transaction. |
| Reorder Point | The stock level at which more stock must be ordered to avoid running out of stock. Generally triggered when stock levels fall below the Minimum Quantity on Hand. |
| Safety Stock | Extra stock held to mitigate the risk of stockouts due to demand variability or supply delays. Should be considered when setting the Minimum Quantity on Hand. |
| Stock | The quantity of a specific item or product available at a given location at a specific point in time. A subset of inventory. Stock is linked to a location, which is set up as an entity. |
| Stock Adjustments | A manual change to the Quantity on Hand to correct discrepancies (e.g. theft, damage, miscount). Recorded as a transaction with a reason code. |
| Stock Item | An individual product, material or stock keeping unit (SKU) that is tracked within the inventory system. The item is part of the physical stock, which is usually recorded. |
| Stock Keeping Unit (SKU) | A unique identifier for each distinct stock item (e.g. it differs by attributes such as size and colour). Links the stock item to a product catalogue. |
| Stock Level | The measured quantity of a stock item at a location. Often includes minimum and maximum thresholds. Used to manage stock ordering. |
| Stock Movement | The transfer (addition or removal) of a stock item within or between inventory locations. Tracked in a transactions table. |
| Stock Price | The value of one unit of a stock item at an inventory location (base unit, local currency). Used to value the stock, and to price the items on Transaction Types with Pricing = Stock Price. |
| Stockout | When the Quantity on Hand of a stock item reaches zero at a location. Avoided with good inventory management. |
| Warehouse | An Inventory Location that stores large quantities of stock. Currently, QuickEasy BOS does not distinguish between the types of locations. They are all treated as warehouses. |
| Weighted Average | A Stock Price worked out from the Goods Received: each Goods Received with a price moves the average towards its cost, in proportion to the quantity received. Used when the General Setting Inventory > Auto Update Stock Price (Weighted Average) is checked. |
Stock vs Inventory
| Stock | Inventory |
|---|---|
| A specific tangible item at an identifiable location (e.g. 50 widgets at Warehouse A). | A broad concept that represents the entire system or collection of goods (e.g. 1 000 widgets and gadgets across all warehouses). |
Stock Item vs Stock Keeping Unit (SKU)
| Stock Item | SKU |
|---|---|
| The physical object being tracked. | The digital identifier for that item in QuickEasy BOS. |
Settings
The following settings affect how inventory is handled. Except for the decimal quantities and the weighted average, all the settings must be set before a transaction updates inventory. If you change a setting, restart QuickEasy BOS to update the transaction columns and fields.
| Setting | Navigation | Description |
|---|---|---|
| Inventory > Auto Update Stock Price (Weighted Average) | Main Menu > Setup > Settings | A checkbox (unchecked by default). If checked, the Stock Price of every stock item and location is worked out from its first movement, then kept up to date as a moving weighted average. If unchecked again, the Stock Prices stay as they are and are no longer updated. It can be checked at any time, even on a database that already has stock transactions. See Item Prices Explained. |
| Inventory > Decimals in Stock Quantities | Main Menu > Setup > Settings | Select 0 to 4 decimal places. |
| Locations | Main Menu > Entities | Create entities of the type Location for each of your Inventory Locations. |
| Transaction Settings | Main Menu > Setup > Transaction Types > Edit Transaction Type > Settings (tab) | Select a default Inventory Location. Select the Resolve to use (e.g. Produce, Issue, Receive). Inventory > Default – From Inventory Location and Inventory > Default – To Inventory Location set the From and To locations of a new transaction. They apply to inventory transfers (when Inventory > Enable Transfer Issue is checked). |
| Transaction Statuses | Main Menu > Setup > Transaction Types > Edit Transaction Type > Status (tab) | The Inventory column must be checked for at least one status. |
| Items | Main Menu > Setup > Items | A location must be added on the item’s Inventory tab. |
Inventory Reporting Table
- Inventory values are not stored; they are retrieved from an Inventory Reporting Table when required.
- Inventory values are added to an Inventory Report if these conditions are met:
- Transaction Header:
- The Header must have a status for which the checkbox in the Inventory column is checked (that is, an Inventory Status).
- The transaction must not be in the Recycle Bin.
- Transaction Item:
- Location must have a value (that is, a location must be selected).
- The selected Location (Entity) must be in an Active Status.
- The Resolve option must be one of these:
- Issue
- Receive
- Reserve
- On Order
- Adjust
- Transaction Header:
- Goods Received and stock adjustment entries are valued excluding VAT, at the entry’s price as entered (after discount, in local currency), not rounded to the entry’s total (for example, 5 at 2.48686 is 12.43 / 5 = 2.486). Rebuild Inventory Report (Items, Actions button) corrects older rows that were valued including VAT, as does saving the transaction again.
- With the General Setting Auto Update Stock Price (Weighted Average) checked, issues, negative adjustments and Goods Received without a price are valued at the weighted average Stock Price. A backdated or cancelled transaction revalues the later issues in the Inventory Report (see Item Prices Explained).
Database Functions
- InvSelectLocationQty
- InvSelectItemQty