View source | View content page | Page history | Printable version   

Projects:Enhanced Inventory Accounting



This is a preliminary description of the enhanced inventory accounting made by Bonware. Current version of Openbravo ERP average costing does not take into account other costs than product price, and also the calculation of average cost is decoupled from the event that changes the average cost. The purpose of the additional functionality is to address these issues. In addition, this project specifies the needed posting entries to the ledgers. Actually, calculating the value of inventory and making the posting may be considered two separate functionalities.

There are two main reasons for this improvement. (1) law requires to keep track of the current assets (raw materials, semi-finished products, and finished products), (2) the firm is probably interested in knowing the value of its current assets.

Valuation priciples of current assets

According to law, many of the costs related to acquiring assets, are allowed to be included in the inventory value. These costs are usually purchase price of products, customs, and freight costs. One design aim of this functionality is to be able to handle easily all these kinds of costs.

The most used inventory valuation methods are FIFO, LIFO and average costing. This functionality implements only average costing, but makes it possible to add other valuation methods afterwards.

The average costing method goes as follows. Cost of product in inventory is changed only when a new shipments comes into the inventory. The new average cost is (quantity in inventory X previous average cost + incoming quantity X product costs) / (quantity in inventory + incoming quanntity). Every product is calculated separately.

Inventory cost calculation

Inputting the costs in Openbravo

First of all, the product settings specify which inventory valuation method is used for each product. This functionality only covers the method "average".

There are two types of costs that can be inputted in the system: fixed cost per order line, and cost percent of price. Fixed cost is inputted in currency and it the cost related to the purchase order line. This is usually ideal for setting freight costs.

Cost percent is inputted as a percentage value, and it specifies an additional cost as a percentage of the orderline amount. This is usually ideal for setting customs.

Added fields of this functionality are:

When a new purchase order line is made, the two cost fields are automatically filled from the product purchasing tab. If the field is empty there, the value are got from product category. It is possible to change the values in purchase order line, or leave them as default values.

Calculated inventory costs

Also product costing tab has some adjustments (screenshot 4). The meaning of the fields are follow:

As in the current functionality, there will be a new line when products come into the inventory, because then the average cost value changes.

Calculating the inventory costs

When a purchase receipt is processed (= products are received in the inventory), the product costing tab is automatically updated, i.e. new line is added there.

Recalculating the inventory costs

A process can be launched in UI, which recalculates all the inventory costs from scratch. The process is applied to certain product or all the products.

Start-up prices

Openbravo ERP may be introduced in an existing business, when there are products in the inventory. In that case a manual entry should be done in the product costing tab, to the Openbravo the beginning inventory valuation. If the costing entry is marked as manual, it is not removed in the recalculation process.

Future enhancements

Additional modifications are needed for firms which convert products to others (use raw material to make finished products). This is because the raw materials disappear and the finished products appear through the production process - not in the material receipts and shipments. So the product costing calculation should be extended into production module.

Inventory value posting

The attached Excel documents sketches the posting in different situations. It is yet to determine, where the different accounts are stored (e.g. product or inventory settings, or accounting defaults).

Some addition description below:

Purchasing invoice

As the material postings are done with estimates a difference account is used to follow the difference between the estimated and real cost.

Material returns

Freight invoice

Technical description of the functionality


Retrieved from ""

This page has been accessed 12,028 times. This page was last modified on 8 June 2012, at 05:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.