Stock & Warehouse
The Stock & Warehouse module supports multiple warehouse locations including treating vehicles as mobile warehouses. Within
each warehouse, multiple stock holding locations are supported down to pallet space or even bin location. A key benefit of using
our online accounting solution is that stock levels are available in close to real-time for sales staff using mobile computing devices who
deal face-to-face with customers.
This Inventory Management system provides you with total visibility over your inventory levels enabling you to match demand to
inventory and thus optimising stock levels.
Unique Features
This module is tightly integrated with handheld devices used in the warehouse which supports many unique features including:
- Vehicles can be treated as mobile warehouses and stock levels on them can be queried.
- Multiple warehouses supported - stock can be queried in any individual warehouse or across all warehouses.
- Stock reorder levels can be warehouse specific.
- Any structure or layout of warehouse can be supported - each storage location can be individually defined.
- Barcodes can be applied to storage locations to make it easier for warehouse operators to record stock movements
- Suggested pick lists will always select oldest stock first
- A variety of asset related activity is supported (see below)
The remainder of this page contains further information on the features and functions of the stock and warehouse module.
Stock Movements
Many types of stock movement are supported including:
- Receipt - goods received from a supplier - the items received are matched against a supplier order (if available) and will subsequently be matched against the supplier invoice
- Issue - stock dispatched to customers either directly, through company owned vehicles, or through third party hauliers/couriers
- Internal - movement of stock between two locations within a warehouse
- Customer Returns - stock returned by customers
- Supplier Returns - stock returned to suppliers
The most stock movements occur as a result of either a customer order or a supplier purchase order. Each type of movement
will be examined in more detail below.
Stock Ordering (Supplier Purchase Order)
A purchase order can be created at any time. It may be triggered by a minimum stock threshold being reached or by a decision
to order more stock.
Apart from specifying a supplier and the date on which the order is required, the information recorded on a purchase order for each product is as follows:
- Product code - while you order using your own product code, the supplier product mapping is applied by the system so that suppliers receive orders using their product codes
- Quantities required - quantity of each product required
- Unit price - unit price for each product
- Discount - discount on the unit price (if appropriate)
- Line total - unit price less discount multiplied by the quantity
- VAT code - VAT rate appropriate to each product line
As well as the line level information captured on the purchase order, purchase order totals are captured as well including:
- Discount - order discount if available (this can be based on order value)
- Subtotal - the total of all lines excluding VAT
- Other charges - this caters for items such as carriage and insurance
- Total Ex VAT - total of the order including all charges and excluding VAT
- Total Inc VAT - total value of the order including VAT
The date the order was created is automatically recorded by the system along with the name of the Operator that created the order.
A Purchase Order Number is also automatically assigned to the order by the system.
Stock Receipts (Goods Received Notes - GRN)
The list of outstanding supplier purchase orders is automatically assigned to all handheld devices in the warehouse on the
date on which the stock is due to be received. This allows any Operator to record the receipt of stock from a supplier.
To record stock received into the warehouse, the Operator simply selects the appropriate purchase order and records the
stock items received. The information recorded for each product received is as follows:
- Product code - the product received
- Product description - description of the product received
- Quantity received - the quantity of the product received
- Put away location(s) - the location(s) in the warehouse in which the product was placed
Any discrepancies between the expected quantity and the quantity actually received are highlighted to the Warehouse Operator
providing an opportunity to verify the exact quantities received to minimise receiving errors.
When all items have been received, the GRN (Goods Received Note) updates the stock levels within the warehouse.
Stock Issue (Dispatch)
Stock is dispatched in response to any of the following:
- Customer order - order is picked and is dispatched via own vehicle/haulier/customer collection
- Stock replenishment order - an internal order received from a van sales driver or another warehouse
Stock is dispatched using picking lists which contain the following information:
- Destination - this can be a customer name and address or a warehouse/van
- Dispatch method - indicates whether the items are being delivered or collected
- Date required - date and time by which the pick needs to be completed
- Product code - code that identifies the product to be dispatched
- Product description - description of the product to be dispatched
- Quantity - quantity of each product to be dispatched
- Location(s) - the location(s) from which products should be picked for dispatch - oldest stock is always suggested first
As handheld computers are integral to the operation of the warehouse, the following functionality is provided to help
manage them:
- Assign pick - assign a pick list to a handheld
- Reassign pick - remove a pick list from one handheld and assign it to another
- View pick status - view the status of all picking activity for a specific warehouse and a specific date
- Cancel pick - cancel picks that no longer have to be undertaken
Stock Movement (Internal)
Stock may need to be moved internally from one location to another for reasons such as bringing frequently used stock from
the back of the warehouse closer to the dispatch area.
- Customer order - order is picked and is dispatched via own vehicle/haulier/customer collection
- Stock replenishment order - an internal order received from a van sales driver or another warehouse
Stock is dispatched using picking lists which contain the following information:
- Destination - this can be a customer name and address or a warehouse/van
- Dispatch method - indicates whether the items are being delivered or collected
- Date required - date and time by which the pick needs to be completed
- Product code - code that identifies the product to be dispatched
- Product description - description of the product to be dispatched
- Quantity - quantity of each product to be dispatched
- Location(s) - the location(s) from which products should be picked for dispatch - oldest stock is always suggested first
As handheld computers are integral to the operation of the warehouse, the following functionality is provided to help
manage them:
- Assign pick - assign a pick list to a handheld
- Reassign pick - remove a pick list from one handheld and assign it to another
- View pick status - view the status of all picking activity for a specific warehouse and a specific date
- Cancel pick - cancel picks that no longer have to be undertaken
Customer Returns
Products returned by customers can be placed in stock if they are fit for resale, in which case they may be sold to other customers, or they can be
written off as defective/s;poilage.
When writing off stock, the reason for the write-off must be specified allowing for subsequent analysis of the root causes for write-offs.
Supplier Returns
Products or assets may need to be returned to suppliers for credit or repair.
The process of returning items to a supplier operates as follows:
- Create return order - an RMA number often needs to be obtained from a supplier before items can be returned
- Create return - handhelds are used to record the items returned and to match them against the return order that was created
- Credit or repair - if the supplier is going to credit the items returned, the credit note received is matched against the return
- Receive replacement - in some cases replacement stock will be provided, or int he case of an asset, it may be repaired and returned
The receipt of a credit, replacement stock, or repaired equipment matches the supplier return order and completes the returns process.
Other Functions
There are a variety of other stock functions available, especially those that relate to asset management. These include:
- Stock take - undertake a 'blind' stock count and compare it against the system calculated values - stock can be adjusted for discrepancies
- Scrap assets - when assets have reached the end of their useful life, they can be scrapped but tehir history remains
- Renumber assets - the serial numnber on assets can be changed - the system will retrieve details of the asset using any of its previous serial numbers
- Reconfigure assets - assets may be converted from one model to another
Reports
Examples of the reports that can be generated from information processed through this module include:
- Stock level - this shows the stock/inventory level for one or more warehouses
- Stock location - this shows the stock/inventory level for one or more warehouses
- Scrapped assets - lists all assets that were scrapped
- Assets in the warehouse - lists all assets in one or more warehouses