Inventory estimate calculator on stock intercompany accounts
(Stock transfer economics)

Why this module?

When a company uses automatic inventory accounting on product categories (Odoo creates financial entries when moving products), there are two internal accounts Inventory Input and Inventory Output accounts, which are used as counterparts when receiving and delivering products. 

These accounts are often balanced and difficult to value correctly. Therefore, this module attempts to make estimates for these values, and the Excel report can be used as documentation for these.

Example of inventory input account:

Upon receiving products, the inventory account is debited and the inventory input account is credited. When the supplier invoice is validated, the value on the inventory input account is debited and the supplier is credited. Thus, the inventory input account is reconciled, and the value is zero. 

How it works

The module creates a list on the screen with all sales order lines and purchase order lines, where the delivered quantity does not equal the invoiced quantity. The list only includes products with product type "Stockable Product". 

For each line, Odoo calculates this value: (delivered quantity - invoiced quantity) x cost price per unit. 

This results in totals for sales orders "SO" and purchase orders "PO". See example below: 

The sum of the two SO values is the estimated value for the inventory output account.
The sum of the two PO values is the estimated value for the inventory input account. 

Important

It should be noted that the values are based on "best guess" for the actual value, but in any case, it should be close to the real value if other parameters are correct. 

In the V17 version, an additional check has been made so that item lines on SO and PO, where the underlying invoices are in status "draft", are included in the report. Movements must be correctly posted before they reflect in the report.  

PO calculation

When estimating delivered values, Odoo looks for the cost price of the associated delivery orders. When calculating billed value, and a delivery is not present, Odoo will by default use the cost price on the PO line.

SO calculation

When estimating delivered values, Odoo looks for the cost price of the associated delivery orders. When calculating billed value, and a delivery is not present, Odoo will by default apply the cost price on the product form, which may not be the actual cost price.