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

Info

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:

  • A Location Entity can be created for each location.
  • Stock Movement Transactions can be created to record moving stock from one location to another.
  • The locations are selected on the transactions when stock is issued, received or returned.
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 QuantitiesMain Menu > Setup > SettingsSelect 0 to 4 decimal places.
LocationsMain Menu > EntitiesCreate entities of the type Location for each of your Inventory Locations.
Transaction SettingsMain 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 StatusesMain Menu > Setup > Transaction Types > Edit Transaction Type > Status (tab)The Inventory column must be checked for at least one status.
ItemsMain Menu > Setup > ItemsA 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
  • 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

Report an issue with this page

For more useful feedback, select the text on the page you are reporting on, then click Feedback again — or continue without selecting anything.