View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

Physical Inventory

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 button.png   Back to Warehouse Management


Contents

Introduction

Physical Inventory window allows to execute goods count process in Openbravo.


Header

Goods count process requires to create an inventory count to check or to update stock quantities.

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.

WS255.png

All fields are pre-filled in automatically when a new record is created.

Some of the fields to note are:

2. There are 2 ways of entering lines into the physical inventory document:

  1. 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.
  2. 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:

CreateInventoryCountList.png

The fields to note are:

Bulbgraph.png   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.

PhysicalInventoryHeader.png

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.


ExportCsv.png

Lines

Lines tab allows to add or to edit individual products to be included in the inventory count list.

Lines tab represents the inventory count list of a given warehouse.

PhysicalInventoryLines.png

Some relevant fields to note are:

The process buttons are:

Accounting

Accounting information related to the physical inventory

A physical inventory can only be post to the ledger in case there is a difference between "Quantity count" and "Book Quantity" for a product. Otherwise there will not be anything to post to the ledger.

For instance a product which "Quantity count" is 6700 units at a given date, while "Book Quantity" in Openbravo is 6000 units.
That physical inventory can be posted after processed, if the cost of the product has been calculated.


Physical Inventory posting creates the following accounting entries if inventory increases:

Account Debit Credit
Product Asset (Quantity Count - Book Quantity) * Cost of the Product
Warehouse Differences (Quantity Count - Book Quantity) * Cost of the Product


Physical Inventory posting creates the following accounting entries if inventory decreases:

Account Debit Credit
Warehouse Differences (Quantity Count - Book Quantity) * Cost of the Product
Product Asset (Quantity Count - Book Quantity) * Cost of the Product

For more details please review the accounting article.



Full list of Physical Inventory window fields and their descriptions is available in the Physical Inventory Screen Reference.

Back button.png   Back to Warehouse Management

Retrieved from "http://wiki.openbravo.com/wiki/Physical_Inventory"

This page has been accessed 30,068 times. This page was last modified on 23 July 2014, at 10:57. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.