How to Calculate Product Pricing Fields in an Odoo GR Bill

When you receive goods in Odoo, the GR Bill helps you track the cost, taxes and final pricing of each product. These fields are calculated in a structured way to ensure accurate costing and clear billing. Understanding each field makes it easier to verify vendor bills and maintain correct inventory valuation.

Creating a GR Bill in Odoo

To start, open the Purchase module and click +New to create a Request for Quotation (RFQ). After you complete the Purchase Order and the items are received in the warehouse, validate the Goods Receipt (GR).

Once the GR is validated, you can click Create GR Bill. The GR Bill screen shows all vendor and product details, making it simple to continue with billing.

Calculation Of Product Pricing Fields in GR Bill

In the GR Bill, the Basic Cost shows the buying cost of the product and the MRP shows the maximum retail price. These two values help in accurate cost calculations.
For example: For Product 20100512, the Basic Cost = 210.00 and MRP = 260.00 is displayed in the GR Bill.

Unit Value Calculation

When no discount is applied, the Unit Value is the same as the Basic Cost and Total Disc. Amount also be 0. The Unit Value is calculated using this Formula:

Unit Value = Basic Cost − Discount Percentage

Example:

Basic Cost: 210.00 , Discount Percentage: 0%
Unit Value = 210 – 0

So, Unit Value is displayed as 210.00

Final Gross Cost Calculation

If the Add Cost field is zero, the Final Gross Cost (FGC) will equal the Unit Value. This ensures that the final pricing reflects the actual cost of the product without any additional charges.

If there is an value in Add Cost, then FGC is calculated as:

FGC = Unit Value  ±  Add Cost	

Example:

Unit Value = 210.00 , Add Cost = 0 
FGC = 210.00 + 0 

So, FGC is displayed as 210.00

Net Cost Calculation

The Net Cost represents the total cost of a product(per unit) after including applicable taxes. It is calculated using the following formula:

Net Cost = Final Gross Cost + Taxes%

Example:

FGC = 210.00 , Taxes = 18%
Net Cost = 210.00 + 18%

So, Net Cost is displayed as 247.80

Tax Excl Calculation

The Tax Excl represents the total cost of a product before including applicable taxes. It is calculated using the following formula:

Tax Excl. = Unit Value × Bill Quantity

Example

Unit Value = 210.00 , Bill Quantity = 5
Tax Excl. = 210.00 * 5 

So, Tax Excl. is displayed as 1,050.00

Tax Incl Calculation

The Tax Incl represents the total cost of a product after including applicable taxes. It is calculated using the following formula:

Tax Incl. = (Unit Value + Tax%) ×  Bill Quantity

Example:

Unit Value = 210.00 , Bill Quantity = 5 , Taxes = 18%
Tax Incl. = (210 + 18%) * 5 

So, Tax Incl. is displayed as 1,239.00

Final Summary Calculations in the GR Bill

At the bottom of the GR Bill, Odoo shows a summary containing Total Basic Cost, Taxable Amount, Taxes, and the Total Amount.

Total Basic Cost Calculation

The Total Basic Cost represents the sum of the basic costs of all products in the GR Bill, calculated using the formula:

Total Basic Cost = Sum(Basic Cost × Quantity)

Example:

Line 1 -> Basic Cost = 210.00  , Quantity = 5 
Line 2 -> Basic Cost = 550.00 , Quantity = 7
Total Basic Cost = Sum(210.00 * 5 + 550.00 * 7)

So, Total Basic Cost is displayed as 4,900.00

Taxable Amount Calculation

The Taxable Amount represents the total cost of a product before including applicable taxes. It is calculated using the following formula:

Taxable Amount = Total Basic Cost − Total Discount

Example:

Total Basic Cost = 4,900.00 , Total Discount = 0.00
Taxable Amount = 4,900.00 - 0.00

So, Taxable Amount is displayed as 4,900.00

Tax Amount Calculation

Tax Amount Calculation computes the total tax applied to all the products in the GR Bill.

Example:

SGST: 441.00
CGST: 441.00

So, SGST and CGST is displayed as 441.00 and 441.00

Total Amount Calculation

The Total Amount represents the final amount payable, including both the taxable amount and the total tax.

Total Amount = Taxable Amount + Total Tax

Example:

Taxable Amount = 4,900.00 , SGST = 441.00 , CGST = 441.00
Taxable Amount = 4,900.00 +  441.00 + 441.00

So, Total is displayed as 5782.00

Confirming the GR Bill in Odoo

Once all product details, costs, taxes and required fields are verified, the final step is to confirm the GR Bill. This completes the billing process for the received goods.