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
See the general settings in Item Settings.
User Settings
Also see the Mobile App for inventory options.
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 Locations | Checkbox. If checked, inventory from all locations can be viewed. | Checked |
| Items & Inventory > Dependencies Actions - Access Allowed | Checkbox. If checked, access is allowed. | Unchecked |
| Items & Inventory > Inventory - Access Allowed | Checkboxes for you to allocate access to the following inventory reports (views):
| Blank |
| Items & Inventory > Item Summary - Access Allowed | Options are None, User, Administrator. An Administrator can use the context menu options. | None |
| Items & Inventory > Items - Access Allowed | Options are None, User, Administrator. An Administrator can use the context menu options. | None |
| Items & Inventory > Items - Access Allowed to Tabs | Checkboxes for you to allocate access to the following items tabs:
| Not applicable |
| Items & Inventory > Items - Delete Allowed | A checkbox. If checked, you can delete items. | Unchecked |
| Items & Inventory > Pricing - Access Allowed | Checkboxes for you to view the following pricing reports:
| Blank |
| Items & Inventory > Set Costing Status - Access Allowed | Checkbox. If checked, access is allowed. | Unchecked |
| Items & Inventory > Stock Check - Access Allowed | Options are:
| Full Access |
Transaction Settings
The following settings can be added to Transaction Types (e.g. Work Orders):
| Setting | Description | Default |
|---|---|---|
| Inventory > Default: Inventory Location Transaction Estimates | Not set | |
| Inventory > Default: Inventory Location Transactions | Not 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
- 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.
- Inventory Locations can be created from Item List Views: Menu (button) > Edit Inventory Locations.
- 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:
- The Location must be allowed for the Transaction Type and Item (Category) which are linked to the Location.
- 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.
- 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:
- Select the first price from another Location linked to the Item.
- 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.
- Select the first Supplier Price linked to the Item.
How Transactions Update Inventory
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.
- Order: A Purchase or Work Order is created to Order inventory.
- Reserve: A Sales or Work Order is created to Reserve inventory.
- Receive: A Goods Received, Goods Returned, Sales Return or Transfer Receive is created to receive goods.
- Issue: A Goods Issued, Purchase Return or Transfer Issue is created to issue goods.
- 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.
- Goods Issued: Inventory is Issued when a product is sold or when materials are used in production.
- Goods Returned: Inventory can be returned by a customer, or from a Work Order where all the materials were not used.
- Transfer Issued: Issues inventory that must be moved from one Location to the next. This transaction is an internal transfer of materials.
- Transfer Received: Receives the inventory at the new Location. This transaction is an internal transfer of materials.
How Inventory Quantities and Values Are Calculated
Inventory Quantities are not stored in the database, instead, they are calculated when they are required.
- The Quantity in stock as at the Selected Date is calculated as follows:
- Get the Last Stock Check dated before the Selected Date.
- Get the Actual Quantity from the Last Stock Check.
- Add the sum of all the Receive transactions dated after the Last Stock Check but on or before the Selected Date.
- Deduct the sum of all the Issue transactions dated after the Last Stock Check and on or before the Selected Date.
- The Value of Inventory is calculated as follows:
- Quantity of Stock on Hand multiplied by the Stock Price as at the Selected Date.
- The Stock Price is extracted from the Price History table.
- The Available Quantity is calculated as follows: the Quantity in Stock less the Reserved quantity.
Managing Stock on Hand
- The Replenishment function ensures that the optimum quantity of stock is kept on hand by helping organisations calculate the Minimum and Reorder Quantities.
- The settings can be found on Inventory (tab) of Materials.
- A Replenishment Report is included in the Inventory Reports.
- The Stock Check function lets managers control the stock on hand.
- Managers can print Stock Count Sheets for their staff to physically count the stock and fill in the Quantities.
- The Quantities from those sheets can be entered into BOS.
- The Counted and System Quantities are compared, and any discrepancies are highlighted.