{"id":34073,"date":"2025-11-27T06:34:03","date_gmt":"2025-11-27T06:34:03","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34073"},"modified":"2026-07-07T06:10:11","modified_gmt":"2026-07-07T06:10:11","slug":"how-to-calculate-product-pricing-fields-in-an-odoo-gr-bill","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/purchase\/how-to-calculate-product-pricing-fields-in-an-odoo-gr-bill\/","title":{"rendered":"How to Calculate Product Pricing Fields in an Odoo GR Bill"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Creating a GR Bill in Odoo<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To start, open the Purchase module and click <strong>+New<\/strong> to create a Request for Quotation (RFQ). After you complete the Purchase Order and the items are received in the warehouse, <strong>validate <\/strong>the Goods Receipt (GR). <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Completed-1024x533.png\" alt=\"Odoo Purchase GR Completed\" class=\"wp-image-34074\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Completed-1024x533.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Completed-300x156.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Completed-768x400.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Completed.png 1207w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Once the GR is validated, you can click <strong>Create GR Bill<\/strong>. The GR Bill screen shows all vendor and product details, making it simple to continue with billing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Calculation Of Product Pricing Fields in GR Bill<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">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.<br>For example: For Product 20100512, the Basic Cost = 210.00 and MRP = 260.00 is displayed in the GR Bill.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"762\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-1024x762.png\" alt=\"Odoo Purchase GR Bill Screen\" class=\"wp-image-34075\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-1024x762.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-300x223.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-768x571.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen.png 1207w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Unit Value Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Unit Value = Basic Cost \u2212 Discount Percentage<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Basic Cost: 210.00 , Discount Percentage: 0%\nUnit Value = 210 \u2013 0<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Unit Value is displayed as 210.00<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Final Gross Cost Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If there is an value in Add Cost, then FGC is calculated as:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>FGC = Unit Value  \u00b1  Add Cost\t<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Unit Value = 210.00 , Add Cost = 0 \nFGC = 210.00 + 0 <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, FGC is displayed as 210.00<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Net Cost Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Net Cost represents the total cost of a product(per unit) after including applicable taxes. It is calculated using the following formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Net Cost = Final Gross Cost + Taxes%<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>FGC = 210.00 , Taxes = 18%\nNet Cost = 210.00 + 18%<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Net Cost is displayed as 247.80<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tax Excl Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Tax Excl represents the total cost of a product before including applicable taxes. It is calculated using the following formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Tax Excl. = Unit Value \u00d7 Bill Quantity<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Unit Value = 210.00 , Bill Quantity = 5\nTax Excl. = 210.00 * 5 <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Tax Excl. is displayed as 1,050.00<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tax Incl Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Tax Incl represents the total cost of a product after including applicable taxes. It is calculated using the following formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Tax Incl. = (Unit Value + Tax%) \u00d7  Bill Quantity<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Unit Value = 210.00 , Bill Quantity = 5 , Taxes = 18%\nTax Incl. = (210 + 18%) * 5 <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Tax Incl. is displayed as 1,239.00<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"761\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-Pricing-calculations-1024x761.png\" alt=\"Odoo Purchase GR Bill Screen Pricing calculations\" class=\"wp-image-34077\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-Pricing-calculations-1024x761.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-Pricing-calculations-300x223.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-Pricing-calculations-768x571.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Screen-Pricing-calculations.png 1203w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Final Summary Calculations in the GR Bill<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">At the bottom of the GR Bill, Odoo shows a summary containing Total Basic Cost, Taxable Amount, Taxes, and the Total Amount.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Total Basic Cost Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Total Basic Cost represents the sum of the basic costs of all products in the GR Bill, calculated using the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Total Basic Cost = Sum(Basic Cost \u00d7 Quantity)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Line 1 -&gt; Basic Cost = 210.00  , Quantity = 5 \nLine 2 -&gt; Basic Cost = 550.00 , Quantity = 7\nTotal Basic Cost = Sum(210.00 * 5 + 550.00 * 7)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Total Basic Cost is displayed as 4,900.00<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Taxable Amount Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Taxable Amount represents the total cost of a product before including applicable taxes. It is calculated using the following formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Taxable Amount = Total Basic Cost \u2212 Total Discount<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Total Basic Cost = 4,900.00 , Total Discount = 0.00\nTaxable Amount = 4,900.00 - 0.00<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Taxable Amount is displayed as 4,900.00<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tax Amount Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Tax Amount Calculation computes the total tax applied to all the products in the GR Bill.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SGST: 441.00\nCGST: 441.00<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, SGST and CGST is displayed as 441.00 and 441.00<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Total Amount Calculation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Total Amount represents the final amount payable, including both the taxable amount and the total tax.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Total Amount = Taxable Amount + Total Tax<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Taxable Amount = 4,900.00 , SGST = 441.00 , CGST = 441.00\nTaxable Amount = 4,900.00 +  441.00 + 441.00<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">So, Total is displayed as 5782.00<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Confirming the GR Bill in Odoo<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"815\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Completed-1-1024x815.png\" alt=\"Odoo Purchase GR Bill Completed\" class=\"wp-image-34084\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Completed-1-1024x815.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Completed-1-300x239.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Completed-1-768x611.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Purchase-GR-Bill-Completed-1.png 1203w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>When you receive goods in Odoo, the GR Bill helps you track the cost, taxes and final pricing of each [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[383],"tags":[476,641,459],"class_list":["post-34073","post","type-post","status-publish","format-standard","hentry","category-purchase","tag-gr-bill","tag-product-pricing-calculation","tag-purchase"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=34073"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34073\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}