Inventory

Inventory items refer to items that are kept at physical locations. A checkbox, if checked, makes the item an Inventory Item. Using the Locations, organisations can control where the inventory is, where it should be and that the quantities on hand match the system quantities (the quantity that should be on hand as per the transactions).

Inventory and non-inventory items have overlapping features.

Settings

General Settings

Navigation Example

Main Menu > Setup > Settings > General (tab)

See the general settings in Item Settings.

User Settings

Info

Also see the Mobile App for inventory options.

Navigation Example

Main Menu > Setup > Settings > Users (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
Inventory > View Inventory from all LocationsCheckbox. If checked, inventory from all locations can be viewed.Checked
Items & Inventory > Dependencies Actions - Access AllowedCheckbox. If checked, access is allowed.Unchecked
Items & Inventory > Inventory - Access AllowedCheckboxes for you to allocate access to the following inventory reports (views):
  • Default
  • Transactions
  • Stock Check
  • Batch Items
  • Serial Numbers
  • Accounting
  • Replenishment
  • Over/Under
  • Ageing
  • Setup
Blank
Items & Inventory > Item Summary - Access AllowedOptions are None, User, Administrator. An Administrator can use the context menu options.None
Items & Inventory > Items - Access AllowedOptions are None, User, Administrator. An Administrator can use the context menu options.None
Items & Inventory > Items - Access Allowed to TabsCheckboxes for you to allocate access to the following items tabs:
  • Image & Specs
  • Units
  • Costing & Pricing
  • Inventory
  • Estimating
  • Event
  • Accounting
  • Price History
  • Costing
  • Attachments
  • Dependencies
Not applicable
Items & Inventory > Items - Delete AllowedA checkbox. If checked, you can delete items.Unchecked
Items & Inventory > Pricing - Access AllowedCheckboxes for you to view the following pricing reports:
  • Supplier Prices
  • Selling Prices
  • Inventory Prices
  • Service Prices
Blank
Items & Inventory > Set Costing Status - Access AllowedCheckbox. If checked, access is allowed.Unchecked
Items & Inventory > Stock Check - Access AllowedOptions are:
  • None: No access to the Stock Checks.
  • Full control: Full control to create, edit and delete Stock Checks.
  • Enter count only: Has access to view and enter quantities.
Full Access

Transaction Settings

Navigation Example

Main Menu > Setup > Settings > Transactions (tab)

The following settings can be added to Transaction Types (e.g. Work Orders):

Setting Description Default
Inventory > Default: Inventory Location Transaction EstimatesNot set
Inventory > Default: Inventory Location TransactionsNot set
Tracker > Module: Issue Inventory (Select the Issue Transaction)Not set
Tracker > Module: Receive Inventory (Select the Receive Transaction)Not set
Transactions > Add to Inventory Replenishment Actions (Produce)Unchecked
Transactions > Add to Inventory Replenishment Actions (Purchase)Unchecked

Inventory Locations

  1. Items are marked as inventory items by selecting Fixed Locations or All Locations on their headers. If Fixed Location is selected, a location must be entered on the item's Inventory tab.
  2. Inventory Locations can be created from Item List Views: Menu (button) > Edit Inventory Locations.
  3. Inventory Locations can be allocated to Customers or Suppliers by right-clicking a location and selecting Edit Location.

Inventory Items

Locations can be explicitly added to an item, or they can automatically be added when the Item is linked to a valid Location on an Inventory Transaction.

When a Location is created, the following happens:

  • An Inventory Location record is inserted and linked to the selected Item.
  • A Stock Check record is created and linked to the new Location. The Stock Check is dated for the previous day.

Inventory Transactions

The following rules are applied when you select a Location on a transaction item:

  1. The Location must be allowed for the Transaction Type and Item (Category) which are linked to the Location.
  2. In a Customer Transaction, the Location must be linked to the Transaction Customer or not linked to a customer. The same applies to Supplier Transactions.
  3. If the Location is not linked to the Item, it is added.

When a new Location is automatically added, the Stock Unit Price is set according to the following rules:

  1. Select the first price from another Location linked to the Item.
  2. Select the first Cost Price linked to the Item with a matching Unit. If the price is in Foreign currency, the price is converted to Local Currency.
  3. Select the first Supplier Price linked to the Item.

How Transactions Update Inventory

Info

Reserve and Order transactions are temporary transactions which manage the Resolve of orders. They are assigned Quantities only.

  • All these transactions create a cascading record in the STOCKTRANS table which is used to calculate the Stock Quantities and Values.
  1. Order: A Purchase or Work Order is created to Order inventory.
  2. Reserve: A Sales or Work Order is created to Reserve inventory.
  3. Receive: A Goods Received, Goods Returned, Sales Return or Transfer Receive is created to receive goods.
  4. Issue: A Goods Issued, Purchase Return or Transfer Issue is created to issue goods.
  5. Goods Received: Purchased inventory is received. Provision is made to include the Landing Costs, for purposes of calculating inventory prices when the weighted-average cost method is used.
  6. Goods Issued: Inventory is Issued when a product is sold or when materials are used in production.
  7. Goods Returned: Inventory can be returned by a customer, or from a Work Order where all the materials were not used.
  8. Transfer Issued: Issues inventory that must be moved from one Location to the next. This transaction is an internal transfer of materials.
  9. Transfer Received: Receives the inventory at the new Location. This transaction is an internal transfer of materials.

How Inventory Quantities and Values Are Calculated

Info

Inventory Quantities are not stored in the database, instead, they are calculated when they are required.

  1. The Quantity in stock as at the Selected Date is calculated as follows:
    1. Get the Last Stock Check dated before the Selected Date.
    2. Get the Actual Quantity from the Last Stock Check.
    3. Add the sum of all the Receive transactions dated after the Last Stock Check but on or before the Selected Date.
    4. Deduct the sum of all the Issue transactions dated after the Last Stock Check and on or before the Selected Date.
  2. The Value of Inventory is calculated as follows:
    1. Quantity of Stock on Hand multiplied by the Stock Price as at the Selected Date.
    2. The Stock Price is extracted from the Price History table.
  3. The Available Quantity is calculated as follows: the Quantity in Stock less the Reserved quantity.

Managing Stock on Hand

  1. The Replenishment function ensures that the optimum quantity of stock is kept on hand by helping organisations calculate the Minimum and Reorder Quantities.
    1. The settings can be found on Inventory (tab) of Materials.
    2. A Replenishment Report is included in the Inventory Reports.
  2. The Stock Check function lets managers control the stock on hand.
    1. Managers can print Stock Count Sheets for their staff to physically count the stock and fill in the Quantities.
    2. The Quantities from those sheets can be entered into BOS.
    3. The Counted and System Quantities are compared, and any discrepancies are highlighted.

Report an issue with this page

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