{"id":34486,"date":"2025-11-28T10:18:59","date_gmt":"2025-11-28T10:18:59","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34486"},"modified":"2025-12-11T04:30:19","modified_gmt":"2025-12-11T04:30:19","slug":"how-to-configure-mbq-for-a-product-in-odoo","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/master\/how-to-configure-mbq-for-a-product-in-odoo\/","title":{"rendered":"How to Configure MBQ for a Product in Odoo"},"content":{"rendered":"\n<p>MBQ or Minimum Base Quantity, refers to the minimum stock level that must be maintained for a product. It helps with stock planning and auto-replenishment decisions. When the stock falls below the MBQ, alerts or reordering processes can be triggered.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigate MBQ tab in Product Master<\/strong><\/h2>\n\n\n\n<p>Go to the Dashboard and click on the Inventory module. From the Products menu, select Product Master and choose a particular product. Then, select the <strong>MBQ<\/strong> tab and follow these steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the Company.<\/li>\n\n\n\n<li>Choose the Sales Classification: Fast, Average, or Slow, depending on how quickly the product sells.<\/li>\n\n\n\n<li>Set the Scheduled Days, which allows you to specify particular days (for example, Monday) when draft purchase orders will be deleted.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"966\" height=\"132\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ.png\" alt=\"Odoo Product MBQ\" class=\"wp-image-34492\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ.png 966w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-300x41.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-768x105.png 768w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Run Scheduler for Calculate MBQ<\/strong><\/h2>\n\n\n\n<p>Open <strong>Settings<\/strong> from the Dashboard and select the Technical menu. Click on Scheduled Actions and choose MBQ Process to manage MBQ calculations. You can click <strong>Run Manually<\/strong> to execute the scheduler immediately, or set the <strong>Next Execution Date<\/strong> to run the scheduler automatically at a later time.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"447\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Run-Manually.png\" alt=\"Odoo Product MBQ Run Manually\" class=\"wp-image-34497\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Run-Manually.png 489w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Run-Manually-300x274.png 300w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>View Min-Max Stock Calculation<\/strong><\/h2>\n\n\n\n<p>After running the scheduler, go to the product screen and click <strong>More<\/strong> at the top of the screen, then select <strong>MIN\/MAX<\/strong>. The system calculates the minimum and maximum values based on the last 56 MBQ sold days, or from the first GRN date if the product age is less than 56 days. These values will be automatically populated after the MBQ process runs.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"868\" height=\"57\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Min-Max.png\" alt=\"Odoo Product MBQ Min Max\" class=\"wp-image-34498\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Min-Max.png 868w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Min-Max-300x20.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Min-Max-768x50.png 768w\" sizes=\"auto, (max-width: 868px) 100vw, 868px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Details of Min-Max Stock Calculation<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Product Name<\/strong>: Name of the product<\/li>\n\n\n\n<li><strong>Location<\/strong>: Stock location<\/li>\n\n\n\n<li><strong>On-hand<\/strong>: Current stock available<\/li>\n\n\n\n<li><strong>Forecast<\/strong>: Expected demand<\/li>\n\n\n\n<li><strong>Trigger<\/strong>: Manual or automatic reorder<\/li>\n\n\n\n<li><strong>Min Quantity: <\/strong>Minimum stock level before reordering<\/li>\n\n\n\n<li><strong>Max Quantity: <\/strong>Maximum stock level to maintain<\/li>\n\n\n\n<li><strong>To Order Qty<\/strong>: Number of units to order<\/li>\n\n\n\n<li><strong>UOM<\/strong>: Unit of measurement<\/li>\n<\/ul>\n\n\n\n<p>Click <strong>Order Once<\/strong> to generate the <strong>Purchase Order<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1795\" height=\"58\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Order-Once.png\" alt=\"Odoo Product MBQ Order Once\" class=\"wp-image-34502\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Order-Once.png 1795w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Order-Once-300x10.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Order-Once-1024x33.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Order-Once-768x25.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Product-MBQ-Order-Once-1536x50.png 1536w\" sizes=\"auto, (max-width: 1795px) 100vw, 1795px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formula Used in MBQ Calculation<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>    \u2022 Average Sold Quantity per Day = Total Sold Quantity \u00f7 MBQ Days\n    \u2022 Minimum Stock = Average Sold Quantity \u00d7 Stock Holding Days\n    \u2022 Maximum Stock = Average Sold Quantity \u00d7 Reorder Level Days\n    \u2022 Forecasted Stock = On Hand + Incoming \u2212 Outgoing\n    \u2022 To Order Quantity = Maximum Stock \u2212 Forecasted Stock\n<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MBQ or Minimum Base Quantity, refers to the minimum stock level that must be maintained for a product. It helps [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[538],"tags":[653,534,449],"class_list":["post-34486","post","type-post","status-publish","format-standard","hentry","category-master","tag-configure","tag-mbq","tag-product"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34486","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=34486"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34486\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}