{"id":15453,"date":"2025-07-18T12:56:30","date_gmt":"2025-07-18T12:56:30","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=15453"},"modified":"2025-07-18T13:05:56","modified_gmt":"2025-07-18T13:05:56","slug":"idempiere-product-master-substitute","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/idempiere-product-master-substitute\/","title":{"rendered":"iDempiere Product Master Substitute"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Substitute tab defines alternative products that can replace a component in a BOM.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It helps ensure production continuity when a\u00a0preferred component is unavailable.<\/li>\n\n\n\n<li>You can specify validity dates, priority, and quantity ratio for substitution.<\/li>\n\n\n\n<li>Useful in flexible manufacturing and supply chain management.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Field Name<\/strong><\/td><td><strong>Description<\/strong><\/td><td><strong>Column Name<br>DataType<br>Reference Type<br>AD_Column_ID<\/strong><\/td><\/tr><tr><td><strong>Tenant<\/strong><\/td><td>Identifies the client\/tenant owning the data.<\/td><td>* AD_Client_ID<br>* numeric(10)<br>* Table Direct<br>* 1436<\/td><\/tr><tr><td><strong>Organization<\/strong><\/td><td>Indicates the organization within the client.<\/td><td>* AD_Org_ID<br>* numeric(10)<br>* Table Direct<br>* 1437<\/td><\/tr><tr><td><strong>Product<\/strong><\/td><td>The main product\/component for which substitutes are defined.<\/td><td>* M_Product_ID<br>* numeric(10)<br>* Search<br>* 1782<\/td><\/tr><tr><td><strong>Name<\/strong><\/td><td>Name of the substitute product entry.<\/td><td>* Name<br>* character varying(60)<br>* String<br>* 1443<\/td><\/tr><tr><td><strong>Description<\/strong><\/td><td>Optional notes or explanation about the substitute.<\/td><td>* Description<br>* character varying(255)<br>* String<br>* 10920<\/td><\/tr><tr><td><strong>Active<\/strong><\/td><td>Indicates whether the substitute record is active.<\/td><td>* IsActive<br>* character(1)<br>* Yes-No<br>* 1438<\/td><\/tr><tr><td><strong>Substitute<\/strong><\/td><td>The actual product that can replace the original component in the BOM.<\/td><td>* Substitute_ID<br>* numeric(10)<br>* Search<br>* 1783<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Substitute tab defines alternative products that can replace a component in a BOM. Field Name Description Column NameDataTypeReference TypeAD_Column_ID [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-15453","post","type-post","status-publish","format-standard","hentry","category-product"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=15453"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/15453\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=15453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=15453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=15453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}