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

Product

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


Contents

Introduction

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

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.

WS180.png

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.

ReturnableError.png

ReturnableWarning.png

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.

Variants

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:

ManageVariants.PNG

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:

Gridchardesc.PNG

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

Orgchartree.PNG


Descriptioncharform.PNG

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.


ServiceTaxesProductConfig.jpg


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.


ServiceTaxesModifyTax.jpg


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.


ServiceTaxesCopyService.jpg

Price

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

WS183.png

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.

Product Price with Exceptions

The product Price with Exceptions tab allows setting a different unit price for the selected product in a price list version. The new price can be established to be applicable for a date range and a specific organization. This new price will be used instead of the unit price coming from the price list version (product price tab) for the selected organization or any of its children when fulfilling the date criteria. If there are two exceptions valid for a given organization, that one with an organization closer to it in the tree structure will be the one chosen to be applied.

ManualDoc:T45A27DB574BA4AAD906AABE172F6E46E

Price Rule Version

This tab will only be available when field Is Price Rule Based is selected. This tab gives the possibility of adding Service Price Rules to the Service starting from a certain date.

Price Rule Version Tab.png

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

Also in this window it is possible to define a maximum and minimum amounts that will be taken into account when showing services.

Those amounts define an interval between product prices so that the service will only be available to be added in case the sum of the selected products is between the interval.

For services of quantity rule: Unique Quantity the quantity of the line matters, as it will be only added one service.

For services of quantity rule: As per Product the quantity of the line does not matter, only matters the price of the product as there will be added as many services as products are selected. Indeed only if all the products prices are between the tranche the service will be shown.

Also if once a service (not yet delivered) has been added to the receipt, the price of the related product changes, a validation will be triggered, and in case the service no longer meets the tranche rules, it will be removed from the current receipt and a pop up will be shown saying so.

Accounting

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.

WS210.png

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

Costing Rule

Costing rule tab allows to review the costing rules that apply to the product within a given date range.

Costing Rules apply to products set as "Item" type flagged as Stocked.

This tab provides information about the validated costing rule(s) which applies on a given date range to the product, as well as the Costing Algorithm defined for that rule.

Costing rules can be created and validated in the Costing Rules window related to the corresponding legal entity / organization.

Currency used by the costing rule is the currency set for the organization.

Product CostingRule Tab.png

Costing

Costing tab collects and summarize product cost related information as a result of every product transaction. Product's costs are valid during a fixed date range and can be calculated either by using an Average or a Standard costing algorithm.

One of the first things to do while creating or importing a product into Openbravo is to inform Openbravo about:

  1. the initial Cost of the products if any, by entering it in this tab.
    Keep reading to learn how to do it.
  2. and the initial Stock of the products if any, by creating and booking a Physical Inventory.

Overall this tab allows to:

Same way either a "Standard" or an "Average" Costing Rule needs also to be defined for the Organization as the way to calculate the cost of the products' transactions within that organization.
Average algorithms override the behavior of the "Default Cost" method prioritizing the use of the current "Average Cost" if any.

If the Openbravo instance has been upgraded and therefore migrated from a version prior to 3.0 MP13 the costs calculated by the "legacy" engine are also visible here.
It is possible to recognize them by their cost type:

WS800057.png

If the Openbravo instance has not been upgraded, "Cost type" is set as "Average".

Product Costing Tab.png

The way to define the Cost of a product implies to enter below detailed information:

Besides:

Substitute

Define substitute products to be used if this product becomes unavailable.

ManualDoc:T181

Average Cost Transactions

ManualDoc:T9175CE3AFD764112BDB6E0647EB67FDF

Transaction Adjustments

ManualDoc:TAA5ED8909C5C49E290B1FCEF7DAFFFEF

Transactions

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:

ManualCostAdjustment.png

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.

Transaction Costs

Transaction Costs records are automatically created by the Costing Background Process and then listed for the product in this tab.

As soon as a product transaction gets its cost calculated a new record is created in this tab.

Same way as soon as a product transaction gets its cost adjusted a new record is created in this tab referring to a "Cost Adjustment Line".

Product TransactionCost Tab.png

Some relevant fields to note are:

Purchasing

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.

WS239.png

Manufacturing

Manufacturing tab is used for products that are planned by the manufacturing plan.

The information in this tab is mainly used by MRP to process the Manufacturing Plan and Purchasing Plan. The storage bin field is filled out for products in production to indicate the default storage bin the product will be stored in when coming out of production.

  1. Safety stock and Max not reserved stock are 200 and 1000 units, respectively
  2. There are several sales orders to be delivered by 3000 units in total
  3. These sales orders will generate the corresponding purchase orders (pre-reserved) when launching the MRP
  4. There are currently in stock 80 units
  5. When MRP is launched it will create the corresponding pre-reserved and because being after below safety stock it will create another purchase order:
    1. As the Max not reserved stock is defined the system will create a purchase order of 920 units (1000-80)
    2. If this parameter wasn't defined it would work as usual and it would create a purchase order of 120 units (200-80)

Translation

Product names can be translated to any language.

The way to get that is as simple as:

Characteristics

Relation of characteristics assigned to the Product

Fields:


Once the record is saved all the values of the characteristic are populated into the characteristic configuration tab

Bulbgraph.png   Explode Configuration Tab flag is available since PR16Q1.

Characteristic Configuration

Characteristic Configuration tab contains the available values for each characteristic assigned to the generic product. Price modifiers to create the variants are defined in this tab as well.

Fields to take into account:

Stock

This Tab shows the available Stock for this Product in the application. It only shows Storage Bins for which the quantity available of the Product is not 0

For each not empty storage bin, it also show information about the:

Unit Cost

Unit Cost Tab displays information about the actual "Unitary Cost" (Unit Cost) of the product.

The "Unitary Cost" of a Product is the value of each stocked unit of the product no matter the costing algorithm used to calculate the cost of that product.

This cost is calculated using the "Total Stock" of a product and the "Total Value" of the stock of the product, as per formula below:

This way, the unitary cost calculated is independent of the "Costing Algorithm" used to calculate the cost of each transaction and product, therefore this unitary cost is compatible with all "Costing Algorithms" (Average, Standard, FIFO, ...)

In this Tab there is going to be a record for:

UnitCost.png

Product Categories

The user can define if a product of a certain product category can be related to a product of 'Service' type by creating a relation between an Order Line of the Service product and another Sales Order Line of the product belonging to included/excluded product categories.

This tab will only be available when field ‘Included Product Categories’ of the Service has a value. It contains all the product categories related to the service.

Related Product Categories.png

The following information about related products is available in the tab:

This tab is not editable, it is not possible to add records manually either edit them. It only allows to delete records. To add new records it is necessary to click on ‘Relate Prod Categories’ button (Visible only when field ‘Included Product Categories’ has a value). This button will open a Pick & Edit displaying all product categories not related to the service.

Relate Product Categories P&E.png

Category Price Rule Version

ManualDoc:TFD12E781543C4CE99EF685A67A7D2142

Products

The user can define if a product can be related to a product of 'Service' type by creating a relation between an Order Line of the Service product and another Sales Order Line of the product included/excluded.

This tab will only be available when field ‘Included Products’ of the Service has a value. It contains all the product related to the service.

Related Products.png

The following information about related products is available in the tab:

This tab is not editable, it is not possible to add records manually either edit them. It only allows to delete records. To add new records it is necessary to click on ‘Relate Products’ button (Visible only when field ‘Included Products’ has a value). This button will open a Pick & Edit displaying all products not related to the service.

Relate Products P&E.png

Product Price Rule Version

ManualDoc:T994A26A418BB4E51AA9C42FE786E24A0

Alternate UOM

AltUOM AlternativeUOMtab.jpg

Fields to note:

For additional information about how to manage altenative unit of measure, please review this How To document.

Modify Taxes Categories

Defines taxes modification for products linked to service. Products linked to this service that belongs to the configured category will change the tax category when linked to this service.

ManualDoc:T3E0794D777C74CF5A4CFAAE43A851275

Media

ManualDoc:TADE6916905F7406BB70C1073133EDF0D



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

Back button.png   Back to Master Data Management

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

This page has been accessed 75,655 times. This page was last modified on 22 August 2023, at 09:26. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.