Toolbox

Main Page

Upload file

What links here

Recent changes

Help

Google Search

Participate

Warehouse Management

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.

Back to User Guide

1 Introduction
2 Inventory Accuracy
- 2.1 Configuration
- 2.2 Execution
3 Relationship with other application areas
4 Application Menu
5 Advanced

Introduction

In Openbravo most of the warehouse movements are created automatically based on the transactions of Sales and Procurement processes. However, operating a warehouse also involves several manual activities, such as physical inventory, goods movements and their tracking and inventory valuation. These activities are executed in Warehouse Management application area and are gathered in an Inventory Accuracy business flow which is described below.

Inventory Accuracy

Main sub-processes of the Inventory Accuracy business flow are:

Physical Inventory. This is a process where a business physically counts individual items in stock at a particular point in time and updates their inventory count within the system (if needed). It represents an opportunity to correct any inaccuracies in the records. Here are several reasons to conduct a physical inventory:
- To initiate the stock
- To verify the physical amount, condition, and location of inventory items
- To identify, document, and add items to its inventory list that are on-hand and meet qualifying criteria, but are not currently shown as part of the inventory
- To ensure that legitimately transferred or disposed items are no longer carried on the inventory listing
- To identify any missing or damaged items that need to be located, repaired, or replaced.

Goods movement. Transfers inventory between storage bins or warehouses. Possible reasons for goods movement are:
- Goods received at warehouse from another party or warehouse.
- Inventory movement due to conversion of goods.

Goods Tracking. Displays all of the different movement types that happen in warehouse to verify the history, location, or application of an item by means of documented recorded identification.

Inventory valuation. Allows a company to provide a monetary value for items that make up their inventory.

Configuration

Warehouse and Storage Bins need to be created and configured before performing the business flow.

In addition to this Product Costing should be configured in the Product and Product Costing tabs of the Product window.

Note: It is not required to do any additional setup for the Warehouse Management application area if Food & Beverage (F&B) sample client shipped with Openbravo by default is going to be used to explore it. The sample data set already contains the roles, warehouses, products pre-configured.

Execution

In Warehouse Management main Inventory Accuracy operations are executed as follows.

Physical Inventory Warehouse Staff:

Starts with the products classifications and runs Pareto Product Report which distributes products into three classes (A, B or C) according to their cost percentage in the warehouse. Based on the classification the frequency of counting cycle can be decided (e.g. A products are counted weekly, B products monthly and C products yearly). The ABC classification is then populated to the Org. Specific tab of the Product window by clicking the Update ABC button.
- Note. The classification is based on the average cost of the product. That is why products to be included in the report needs to have Cost Type field set to Average and the Generate Average Costs process has to be run prior.
After this procedure Warehouse Staff in Physical Inventory window creates physical inventory document by selecting Warehouse where to execute this activity and pressing Create Inventory Count List button. They define criteria for the products to be included in the count-list (for example ABC classification) and it results in the list of products with their current quantities that is brought to the warehouse and verified against physical inventory.
In order to update Openbravo stock if differences are found first Warehouse Staff selects the Physical Inventory that was previously created. Then in the Lines tab finds required products and updates the Quantity Count field with a new values. After that finishes inventory count by clicking the Process Inventory Count button which updates inventory and triggers document posting (if configured).

To execute Goods Movement Warehouse Staff:

In the Goods Movements window lists products to be moved with source and destination information and the respective quantity and then Processes the document which updates all product quantities listed under Lines tab in the warehouse and triggers document posting (if configured).

For Goods Tracking Warehouse Staff uses:

Stock Report that gives a stock level of all products (that have inventory different from zero) and their location (warehouse and storage bin) grouped by product category.
Goods Transaction window that offers a read only view with extensive filtering capabilities that shows all inventory transactions.
Product Movements Report shows all receipts, shipments, moves and physical inventories grouped by Transaction Type and Business Partner.
Material Transaction Report lists all documents (shipments or receipts) grouped by Business Partner.

Inventory Valuation is done with a help of Valued Stock Report.

Relationship with other application areas

Warehouse Management has a connection with other application areas:

Procurement Management as goods received change stock quantity and its value.
Sales Management as shipment changes stock quantity and its value.
Production Management because raw materials are taken out of warehouse and produced goods are sent back to the stock during production process.

Application Menu

Please find below detailed description of all windows and reports of the Warehouse Management application area.

Transactions

Analysis Tools

Setup

Warehouse and Storage Bins

Advanced