ManualDoc:T255
These are the steps that must be followed in order to create an inventory count:
1. The Header section identifies the "Physical Inventory" process and lists its main parameters.
All fields are pre-filled in automatically when a new record is created.
Some of the fields to note are:
- Name: This field is used to reference the physical movement not only in warehouse reports but also on general ledger, therefore it is important to use a significant name.
- Movement Date: This is the date when the movement is created and it is defaulted to the current date. This date is also used in the posting record of the Physical Inventory document to the general ledger, if any. It can always be changed, but the user should keep in mind that is not possible to register physical inventories in the past (the "Process Inventory Count" always takes the current date and not the Movement Date to update the stock). The Movement Date should be the current date unless the user can ensure that no warehouse transactions have been processed in the meanwhile.
- Warehouse: warehouse in which the physical inventory takes place. Defaulted to the session value from the top navigation User Preferences menu.
2. There are 2 ways of entering lines into the physical inventory document:
- Automatically, by creating a list of the products available in the warehouse and storage bins defined in the physical inventory header, that fulfill the filtering conditions specified by the Create Inventory Count List button.
- Manually, line by line for certain products. This is used whenever only some products need updating.
Create Inventory Count List process can be executed more than once for the same physical inventory. Although lines are created automatically by using the Create Inventory Count List process, this lines can later on be updated manually. Create Inventory Count List filter dialog has the following parameters:
The fields to note are:
- Storage Bin: Only products on this storage bin will be filtered.
- Product Category: Only products beloging to a given product category will be filtered, otherwise all products will be shown.
- Inventory quantity: Includes or excludes products on physical inventory depending on actual quantities. The options available are:
- empty - all product on physical inventory will be shown regardless its quantity
- 0 - only products on physical inventory having 0 quantity in stock will be shown.
- <0 - only products on physical inventory having a positive quantity in stock will be shown.
- >0 - only products on physical inventory having a negative quantity in stock will be shown.
- not 0 - only products on physical inventory having a quantity in stock different to 0 will be shown.
- Set Book Quantity to Zero: this checkbox sets the Quantity Count field on the count list to zero. When the checkbox is not selected, the Quantity Count is defaulted to the same value as the Book Quantity (On Hand Quantity) of the product.
- First option is used for blind physical inventories where people who is counting items on the warehouse doesn’t need to know the expected quantities.
- First option is used to allow the user to enter the "real" quantity count on the warehouse and storage bin. Once the inventory count is processed, the book quantity shown by the system will be updated to the quantity count entered by the user.
- ABC: Pareto Product classification.
![]() | Starting from 23Q3 Physical inventory lines can be exported to a CSV file in order to help with the counting process |
In Physical Inventory window there is a button Export CSV that allow to the user export the Physical Inventory lines to a CSV, in order to help with the counting process. The CSV file can be imported afterwards with the updated quantities.
Export CSV process has the following options:
- Create Inventory Count list automatically: this flag is only shown when the Inventory Type is Total. If check the Physical Inventory lines are generated automatically for all products regardless of the stock they have.
- Blind Count: In a blind count the warehouse users don't know the theoretical quantity on hand. So Book Quantity and Quantity Count are exported in blank.
![]() | Starting from 23Q4 Physical inventory lines can be imported from a CSV file in order to help with the counting process |
A new button in the toolbar to import the CSV file will be available. In order to manage the roles that have access to this process, the button will be enabled or disabled depending on a new preference “Show Import Store Stock Button”. When the user taps on this button a dialog is displayed in order to upload the file
In this dialog the user should add the file and select the desire option in Import Mode and Import Error Handling.
In case stock in openbravo, but when the counting process is done, there is no stock. There are some options for the user, the user will be select one when import the csv file:
- Delete lines
- Set Quantity count to 0
- Set Quantity count equal to original Book quantity
- Do not modify the line