View source | Discuss this page | Page history | Printable version   


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 Coworking:Master Data Management



Product master data window is the place where you can easily organize and centralize the key data of the items of any type you might manage as part of the organization processes and/or activities.

Organizations deal with a variety of different items may be required by an organization for the performance of its daily activities.

It is possible to load Product information into Openbravo en masse using the Import Data module, or one by one using the Product window.

This section describes how to set up Products individually.


Product window allows the creation of items such as products, raw materials, resources, services, etc.

The information required to create a Product in Openbravo is determined by the nature of the Product, its Product Type.

There are four product types available:

Product types do not confer different accounting treatments. In other words, all product types account same way while being purchased, stocked or sold.
All of them use the ledger accounts defined in the Accounting tab of the Product window.


Additional key data to fill in are:

These values are used when an invoice is created for a product having an expense plan and/or a revenue plan.
Same way, these values are also used when an invoice is created from another document (for example: the Generated Invoices process that creates invoices from sales orders). Same way these values can be modified on a transaction by transaction basis.
To learn more visit the How to manage deferred revenue and expenses article.
Bulbgraph.png   This feature is available starting from 3.0PR17Q2.



Note: If stocked is not checked and BOM is checked, the product price should be 0. Because in that special case, the product price is the sum of the prices of the bill of materials components it consists of. If promotion wanted to create, 'Discounts and Promotions' should be used.


Product can be marked as Is Generic. This means that variants of this product will be created based on some characteristics such as colour, size, etc. The definition of these characteristics takes place in the generic product so it can be said that a generic product is like a template where newly variants will inherit all the attributes (taxes, prices, image) of this product. Because of this a generic product cannot be used for transactions but its variants.

Bulbgraph.png   Note:Products that are marked as generic cannot be used in transactions operations such as sales orders, purchase orders, goods receipts, etc

When this flag is marked two buttons are shown:

For example imagine generic product T-Shirt Model A has the characteristics:

But still variants have not been created. If you press the button you see all possible combinations:


Then all combinations can be selected or just pick some of them. Once the selection takes place pressing Done, combinations will be created as Products. This newly products will have the Generic Product field filled with the product that was marked as generic. We can say it is their parent product

Another button that might appear is Updatecharbutton.PNG. It only shows up when the generic product or the newly product variant has a non-variant characteristic related. Two scenarios:

  1. Generic product: This button allows to enter the value of that characteristic.
    Imagine the characteristic is Fashion Line that has three value: Sport, Vintage, Classic.
    Unlike the characteristics that are variants users cannot enter the value through the Characteristic Configuration tab
  2. Variant Product: This button allows to enter/update the characteristic that is not variant

Once a variant has been created its characteristics and values can be viewed either in the grid or in form view:


Press the button Buttonchardesc.PNG and opens a pop-up to select values:



There is a preference Show Product Characteristics Parents: Values can be 1,2,3,4, etc. The number means how many levels in the hierarchy tree the user wants to show in form view in the Product window. For example if the tree is: Colour->Green->Green light->0034

New values of an existing characteristic can be added. For example colour red when already having Blue and White. When it happens this new value is automatically added to all generic products that already have the characteristic Colour. This new value will be present in the configuration tab but deactivated. If the user wants to use it in a specific product in order to create new variants he can just activate the value and use the button "Manage Characteristics"

Modify Tax

Bulbgraph.png   This feature is available starting from 3.0PR19Q2.

This taxes modification is implemented through a service linked to the product. This service has to be marked as can modify taxes of the products linked to, and the configuration of the products to modify taxes and the new tax to apply must be also specified.

To configure it go to the Product window and create a new service. A service is just a product with the field Product Type set to Service. It has to be activated also the field Linked To Product and the field Modify Tax. When this field is activated, an new tab named Modify taxes categories is visible. In this Tab is defined the configuration of the taxes categories of products this service will modify when linked and the new tax category to apply.


To ease the configuration process two components have been added:

1.- Modify Tax for Product Category (Button): Pick and Execute window to assign the product categories and tax categories in the same action.


2.- Copy Service Modify Tax Configuration (Button): Pick and Execute window where services which modify taxes are displayed. User can select one to many service, and current configuration will be assigned to selected services. Once process have been executed, the old configuration (if exists) will be deleted and new one will be added. This process helps in deploying the same configuration to multiple services.



A product can be part of many Price List Versions which are valid for a given time period.


There are two ways you can get a product to be part of a Price List:

  1. by selecting the Price List/s and entering both the "Net Unit Price" and the "Net List Price" values in the Price List tab, while creating the product.
    As a consecuence of that, the product being created will also be part of the Price List selected.
  2. by selecting the product and entering both the "Net Unit Price" and the "Net List Price" values, while creating the "Price List".
    As a consequence of that, that the Price List as well as both "Net Unit Price" and "Net List Price" values will be automatically shown in the "Price List" tab of the product.
    To learn more visit Price List.


Accounting tab allows to configure the ledger accounts to be used while posting product related transactions such as product purchase or sales to the general ledger.


As shown in the screen above, you can configure for each product and general ledger some accounts to be used in the below listed transactions:

This account is typically an asset account

At first, these accounts are inherited from the Defaults accounts of the organization's general ledger configuration for which the product is being created. The end-user can always change them.

Besides, it is important to remark that it is possible to configure the creation of new correlative accounts for the products as described in the General Ledgers tab of the Organization window.

Bill of Materials

This tab allows to edit the bill of materials components the selected product consists of.

Bill of Materials apply to products flagged as Bill of Materials.

This tab provides information of the list of products contained and its quantity for the Bill of Materials production.

If the product Tax_Category is flagged as As per BOM, this tab also provides information for the price of each product in the Bill of Materials list. The price and quantity in this list is used to perform the division of the base amount to calculate the taxes based on the taxes configured for each product of the list

Product BOM Tab.png


The transaction tab is a summarized view of all the transactions of a product.

There is not a way for you to directly create new product transactions in the transactions tab.
Product transactions of any type are automatically saved and listed in this tab as they are booked in Openbravo.

Product Transactions Tab.png

As shown in the image above, Openbravo saves and informs us about below relevant data for each product transaction type:

Openbravo also informs us about the specific:

information of the product transaction, as applicable.

It is also possible to review:

1. the Costing Status of a transaction.

Costing status of a transaction can be any of the ones listed below and has a lot to do with the Costing Background Process:

2. and whether the cost of a transaction has been calculated or not.
As soon as a product transaction gets its cost calculated by the Costing Background Process the field "Is Cost Calculated" gets the value "Yes".

Once the cost of a transaction is calculated you can also view the:

Additionally, "Is Cost Permanent" field informs whether the cost of a transaction is permanent or not. In case it is permanent, it will not be changed anymore.

Finally, it is important to remark that in the case of "Average" cost algorithm, the "average" cost of a product is calculated as "Moving Average" as explained in this wiki article.

The average cost of a product is calculated based on the product's transaction flow, therefore it is the sum or subtraction of the "Total Cost" of the transactions listed for the product, divided by the sum of the "Total Movement Quantity" of the transactions.

For instance the average cost of a product which transactions are listed below is equal to 23.33 = (2000.00-1000.00+2500.00)/(100-50+100):

Manual Cost Adjustment

Additionally, the cost of a transactions can be modify by clicking on Manual Cost Adjustment process button. After clicking this button a new popup is opened:


This pop-up allows entering below detailed data:

For additional information about which cost adjustment is or it is not unit cost, please review this wiki article : Cost Adjustments - Introduction.

Once done a "manual cost correction" cost adjustment will be created.

This cost adjustment can be reviewed and post to the ledger in the Cost Adjustment window.

Same way, this cost adjustment can also be reviewed in the Transaction Cost tab.


Purchasing tab information is used for products that are planned by the purchasing plan.

In this tab the information that is required for the creation of the Purchasing plan and of the automatic creation of Purchase Orders from the Purchasing Plan is entered.
Also, the Requisition process uses the Business Partner information for the automatic creation of Purchase Orders.



Product names can be translated to any language.

The way to get that is as simple as:

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

Back button.png   Back to Coworking:Master Data Management

Retrieved from ""

This page has been accessed 3,668 times. This page was last modified on 13 June 2013, at 15:52. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.