{"id":33131,"date":"2025-11-20T06:49:59","date_gmt":"2025-11-20T06:49:59","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=33131"},"modified":"2025-11-28T12:38:29","modified_gmt":"2025-11-28T12:38:29","slug":"manual-reordering-rules-and-mbq-configuration-in-inventory-management","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/purchase\/manual-reordering-rules-and-mbq-configuration-in-inventory-management\/","title":{"rendered":"Manual Reordering Rules and MBQ Configuration in Inventory Management"},"content":{"rendered":"\n

Efficient inventory management ensures the right products are always available without overstocking. Two important tools that support this are Manual Reordering Rules<\/strong> and MBQ (Minimum Base Quantity) Configuration<\/strong>.<\/p>\n\n\n\n

Manual Reordering Rule<\/h2>\n\n\n\n

A Manual Reordering Rule<\/strong> alerts users when stock reaches a predefined minimum level. Unlike automated replenishment, it requires users to manually initiate reorders, allowing better control based on demand and business judgment.<\/p>\n\n\n\n

Configuring MBQ in Products<\/h2>\n\n\n\n

To set up MBQ, open the Product Master in the Inventory module and select the product. Under the MBQ tab, configure details like Sales Classification, Company, and Scheduled Days. Then go to Settings \u2192 Technical \u2192 Scheduled Actions \u2192 MBQ Process and run the scheduler manually or automatically. After running it, verify the Min\/Max Quantities in the product form.<\/p>\n\n\n\n

\"Odoo<\/figure>\n\n\n\n

MBQ Formulas<\/h2>\n\n\n\n
    \n
  • Average Sold Quantity\/Day<\/strong> = Total Sold \u00f7 MBQ Days<\/li>\n\n\n\n
  • Minimum Stock<\/strong> = Average Sold \u00d7 Stock Holding Days<\/li>\n\n\n\n
  • Maximum Stock<\/strong> = Average Sold \u00d7 Reorder Level Days<\/li>\n\n\n\n
  • Forecasted Stock<\/strong> = On Hand + Incoming \u2212 Outgoing<\/li>\n\n\n\n
  • To Order Quantity<\/strong> = Maximum Stock \u2212 Forecasted Stock<\/li>\n<\/ul>\n\n\n\n

    Creating Purchase Orders<\/h2>\n\n\n\n

    Open the Replenishment screen in Inventory. MBQ-configured products appear here with calculated quantities. Review and edit if needed, When select products then click \u201cOrder to Max\u201d to generate purchase orders automatically, or \u201cOrder Once\u201d to create one manually for a single product.<\/p>\n\n\n\n

    \"Odoo<\/figure>\n\n\n\n

    Verifying Purchase Orders<\/h2>\n\n\n\n

    In the Purchase module, go to the RFQ screen to view POs generated from MBQ. If products share the same vendor, a single PO is created; otherwise, separate POs are generated. The Source Document (e.g., OP\/00002) identifies MBQ-generated orders. Verify vendor, quantity, and product details before confirming.<\/p>\n\n\n\n

    \"Odoo<\/figure>\n\n\n\n


    Manual Reordering and MBQ ensure timely replenishment with full user control. Together, they help maintain optimal stock levels, reduce shortages, and improve procurement efficiency.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Efficient inventory management ensures the right products are always available without overstocking. Two important tools that support this are Manual […]<\/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":[383],"tags":[99,535,534,449],"class_list":["post-33131","post","type-post","status-publish","format-standard","hentry","category-purchase","tag-inventory","tag-manual-trigger-for-po","tag-mbq","tag-product"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33131","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=33131"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33131\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=33131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=33131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=33131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}