{"id":18274,"date":"2019-02-07T17:18:05","date_gmt":"2019-02-07T11:48:05","guid":{"rendered":"http:\/\/tenthplanet.in\/compiere\/?p=18274"},"modified":"2025-07-31T10:05:25","modified_gmt":"2025-07-31T04:35:25","slug":"material-management","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/compiere\/material-management\/","title":{"rendered":"Compiere Material Management"},"content":{"rendered":"<p>Compiere Material Management procedures<\/p>\n<h4>Product UOM<\/h4>\n<p>The unit of measure is a standardized quantity of physical property, the customer manages products with four different UOM namely \u2018Each\u2019 (tin, bottle, sachets), Carton, Dozen and Pallet. The standard precision and costing precision are used to calculate the amounts in the UOM conversion.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Pallet size for a shipment received by the customer from Supplier &lt;&gt; customer pallet size for post-VAS storage.<\/li>\n<li>Tracking in the system will be based on the lowest UOM, that is, EACH. For reports and online data entry, users can use a mix of UOM. For example, an invoice can show 4 CARTONS and 3 TINS.<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18320\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_UOM_Product.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_UOM_Product\" width=\"900\" height=\"277\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_UOM_Product.png 900w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_UOM_Product-300x92.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_UOM_Product-768x236.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><br \/>\nUOM Conversion<\/h4>\n<p>The UOM Conversion identifies a unique to and from Unit of Measure and conversion rate.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Each product has a different conversion rate example one product will have 12 cartons in a pallet and another will have 24 etc.,<\/li>\n<li>Tin, bottle, sachets (smallest UOM) are the baseline UOM in the system<\/li>\n<li>Supplier pallet conversion is different from customer conversion<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18322\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_UOM_Product_Material_Management_UOM_Converion.png\" alt=\"TenthPlanet_Compiere_Distribution_UOM_Product_Material_Management_UOM_Converion\" width=\"878\" height=\"261\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_UOM_Product_Material_Management_UOM_Converion.png 878w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_UOM_Product_Material_Management_UOM_Converion-300x89.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_UOM_Product_Material_Management_UOM_Converion-768x228.png 768w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><br \/>\nUOM Group<\/h4>\n<p>The UOM Group provides a utility to create the product UOM conversion for the products having related UOM. Example: Tin-Carton-Pallet when selecting a UOM group for the product, the individual product-specific UOM Conversions are created.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Each product has a different conversion rate example one product will have 12 cartons in a pallet and another will have 24 etc.,<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18314 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group\" width=\"859\" height=\"241\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group.png 859w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group-300x84.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group-768x215.png 768w\" sizes=\"auto, (max-width: 859px) 100vw, 859px\" \/><\/p>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18315\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group-2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group 2\" width=\"865\" height=\"205\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group-2.png 865w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group-2-300x71.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_UOM_Group-2-768x182.png 768w\" sizes=\"auto, (max-width: 865px) 100vw, 865px\" \/><br \/>\nLot Control<\/h4>\n<p>Customer material policy is FEFO (First Expiry First Out), the lot and expiration date of a product have been captured and stocked. The material movement will further happen based on a lot and expiry date. Lot control helps to define the creation of lot number by mentioning the start number, increment by, prefix and suffix.<\/p>\n<p>Since customer uses Supplier lot number, automatic sequence number feature not required.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The customer uses Supplier lot number<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18288 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Lot_Control.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Lot_Control\" width=\"676\" height=\"285\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Lot_Control.png 676w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Lot_Control-300x126.png 300w\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" \/><\/p>\n<h4>Define Attribute Set<\/h4>\n<p>Customer captures lot and expiry date of the product, the attribute set allows users to define the lot control, Shelf days and make the system mandatory to capture lot and expiry.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Expiry date need to be mandatory<\/li>\n<li>Lot number need to be captured for all products<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18276\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Attribute_Set.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Attribute_Set\" width=\"883\" height=\"369\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Attribute_Set.png 883w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Attribute_Set-300x125.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Attribute_Set-768x321.png 768w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/p>\n<h4>Product category<\/h4>\n<p>The product Category allows you to define different groups of products. These groups can be used in generating Price Lists, defining margins and for easily assigning different accounting parameters for products. Customers groups their products by brand.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Product brand considered as a product category<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18303\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Category.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Category\" width=\"884\" height=\"189\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Category.png 884w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Category-300x64.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Category-768x164.png 768w\" sizes=\"auto, (max-width: 884px) 100vw, 884px\" \/><\/p>\n<h4>Product Division<\/h4>\n<p>The customer manages their product hierarchy for generating business intelligence reports. Product division allows you to define the different divisions of a product example PND, Up to Age, Pharma, etc. Each product will map to one of the defined divisions.<\/p>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18326 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Division.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Division\" width=\"490\" height=\"234\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Division.png 490w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Division-300x143.png 300w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18327 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Division-2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Division 2\" width=\"483\" height=\"133\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Division-2.png 483w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Division-2-300x83.png 300w\" sizes=\"auto, (max-width: 483px) 100vw, 483px\" \/><\/p>\n<h4>Product Franchise<\/h4>\n<p>The customer manages their product hierarchy for generating business intelligence reports. The product franchise allows you to define different franchises of a product example Pre-Natal, Infant, etc. Each product will map to one of the defined franchises.<\/p>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18306 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise\" width=\"401\" height=\"195\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise.png 401w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise-300x146.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18307 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise-2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise 2\" width=\"404\" height=\"110\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise-2.png 404w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Franchise-2-300x82.png 300w\" sizes=\"auto, (max-width: 404px) 100vw, 404px\" \/><\/p>\n<h4>Product Stage<\/h4>\n<p>The customer manages their product hierarchy for generating business intelligence reports. The product stage allows you to define the different stages of a product example stage1, stage2, etc. Each product will map to one of the defined stages.<\/p>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18311 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product-Stage.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product Stage\" width=\"493\" height=\"241\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product-Stage.png 493w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product-Stage-300x147.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18312 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Stage_2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Stage_2\" width=\"487\" height=\"133\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Stage_2.png 487w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Stage_2-300x82.png 300w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/p>\n<h4>Product Line<\/h4>\n<p>The customer manages their product hierarchy for generating business intelligence reports. The product line allows you to define different lines of a product example Simalac Mom300g, Simalac Mom 700g etc. Each product will map to one of the defined product lines.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Product Line is used to performing Phase In \/ Phase-Out analysis.<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18308 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Line.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Line\" width=\"393\" height=\"193\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Line.png 393w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Line-300x147.png 300w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18309 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Line-2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Line 2\" width=\"485\" height=\"135\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Line-2.png 485w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Line-2-300x84.png 300w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/p>\n<h4>Product State<\/h4>\n<p>The customer manages their product life cycle in three different states namely Phase In, Stable and Phase Out. The product state allows you to define the different states and will be associated with the product in the product master.<\/p>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18313 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_state.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_state\" width=\"475\" height=\"236\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_state.png 475w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_state-300x149.png 300w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/><\/p>\n<h4>Product Rank<\/h4>\n<p>Customer products are classified into three different rankings A, B, and C based on the movement of the product.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Material movement policy is based on product expiry and product rank A, B and C<\/li>\n<li>Product rank will be applied Nationwide<\/li>\n<li>ABC Classification is applied to SKU at Stable state<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18310 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Rank.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Product_Rank\" width=\"480\" height=\"234\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Rank.png 480w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Product_Rank-300x146.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/p>\n<h4>Manage Product<\/h4>\n<p>Manage product allows you to create or update product for trade. The product attributes such as division, franchise, brand, stage, product line, rank, product state, tax category, UOM, price is associated with the product. Also, it allows you to define the vendor code, barcode (Tin &amp; Carton), weight, volume, market position (mid-tier, IQ), AC Neilsen, Product nature (Powder, liquid), government registration number, minimum order quantity, replenish quantity and shelf life.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The product name should be stored in English as well as Vietnamese using English alphabets<\/li>\n<li>Need to view product master report (helps to print product master)<\/li>\n<li>Government registration SKU history need to be tracked<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18290 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product\" width=\"429\" height=\"633\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product.png 429w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product-203x300.png 203w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18291 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product_2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product_2\" width=\"391\" height=\"215\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product_2.png 391w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Product_2-300x165.png 300w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><\/p>\n<h4>Discontinue Product (Fully)<\/h4>\n<p>Customers will mark the product as \u201cDiscontinue\u201d to stop sales and purchase for any customers.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The system will show the discontinued products in the product info screen<\/li>\n<li>User will decide the transaction for discontinued<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18282 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Discontinue_Product.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Discontinue_Product\" width=\"657\" height=\"164\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Discontinue_Product.png 657w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Discontinue_Product-300x75.png 300w\" sizes=\"auto, (max-width: 657px) 100vw, 657px\" \/><\/p>\n<h4>Deactivate Product<\/h4>\n<p>Customers will mark the product as inactive if the vendor stopped or new product replaced.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The system should restrict the inactive products for further transactions<\/li>\n<li>Need to view the historical information of inactive products<\/li>\n<li>The system should not allow to deactivating the products having any open transactions<\/li>\n<li>The system should not allow to deactivating the products in stock<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18281 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Deactivate_Product.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Deactivate_Product\" width=\"656\" height=\"161\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Deactivate_Product.png 656w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Deactivate_Product-300x74.png 300w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/><\/p>\n<hr \/>\n<h3>Pricelist Management<\/h3>\n<p>Pricelist (also called customer discount) has a selling and purchase list. The customer has a different price list for different customers. The price list version is managed to keep track of price change history. Currently, the active version is used for transactions. Discount can be applied to the pricelist version using pricelist discount schema.<\/p>\n<h4>Define pricelist<\/h4>\n<p>This allows the user to define various pricelists for purchase and sale. Price lists determine currency and tax treatment. The customer has purchase and selling price list. It manages a different selling price lists for different customers.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Need to track the pricelist versions<\/li>\n<li>The different pricelist will be configured for different customers<\/li>\n<li>Pricelists are not inclusive of tax<\/li>\n<li>Selling pricelist, it will be maintained by IM Business Analyst<\/li>\n<li>Purchasing pricelist, it will be maintained by Plan Team directly<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18300 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Management.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Management\" width=\"762\" height=\"210\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Management.png 762w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Management-300x83.png 300w\" sizes=\"auto, (max-width: 762px) 100vw, 762px\" \/><\/p>\n<h4>Define Pricelist version<\/h4>\n<p>Pricelist version allows the user to recalculate the pricelist from the base price list with a discount. The active pricelist version based on the validity is used for transactions.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Need to track the version history<\/li>\n<li>Need to have category based price recalculation<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18302 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Version.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Version\" width=\"760\" height=\"267\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Version.png 760w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Version-300x105.png 300w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/p>\n<h4>Define Pricelist schema<\/h4>\n<p>The customer has different pricelist discounts for different customers. The price list discount schema allows user to define the discount percentage.<\/p>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18301 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Schema.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Schema\" width=\"763\" height=\"196\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Schema.png 763w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Price_List_Schema-300x77.png 300w\" sizes=\"auto, (max-width: 763px) 100vw, 763px\" \/><\/p>\n<h4>Manage Master Plan<\/h4>\n<p>Managing the mater plan is used to perform the VAS more effectively to avoid the out of stock situation. Every week have a master plan for that week to perform the VAS. The master plan has a plan list.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Need to have a weekly master plan<\/li>\n<li>The plan has quantity in terms of tins<br \/>\nMaterial move policy is FIFO (new Inbound shipments) and Requirement (ad hoc requirements for campaigns, or special instructions)<\/li>\n<li>Receipt reference is traceable<\/li>\n<li>The system will provide the option to generate a plan list for Incoming shipments based FIFO and ABC. This process should consider non labeled goods.<\/li>\n<\/ul>\n<hr \/>\n<h3>Physical Inventory<\/h3>\n<p>Physical inventory used to create, change, or delete Stock. This allows you to generate inventory count lists. These counts can then be processed to update the actual inventory with the new counts.<\/p>\n<p>For Inventory Difference, the loss or gain of inventory is booked to the Warehouse Difference Account defined for this Accounting Schema. For Charge a field for selecting a specific Charge is displayed. This allows you to account for specific differences in inventory due to shrinkage or damage. It also allows you to move items out of inventory for internal use and account for them properly.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The excess count will handle outside the system<\/li>\n<li>Physical Inventory will be managed outside the system<\/li>\n<li>Setting Opening Inventory (the system will post the relevant Account)<\/li>\n<li>Inventory Move will be done manually<\/li>\n<li>Destruction of goods (the system will post the relevant Account)<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18299 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Physical_Inventory.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Physical_Inventory\" width=\"769\" height=\"315\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Physical_Inventory.png 769w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Physical_Inventory-300x123.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Physical_Inventory-768x315.png 768w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/p>\n<h4>Inventory Move<\/h4>\n<p>Inventory move help to create movement ticket, print movement ticket, create confirmation and process movement after confirmation.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li><strong>User can manually select the lot or by system suggestion :<br \/>\n<\/strong><\/li>\n<li>The system suggested movement from Hold to VAS will follow FIFO rule (by GRN Date)<\/li>\n<li><strong>Material movement policy is FEFO :<br \/>\n<\/strong><\/li>\n<li>Material movement policy is FEFO (for system suggestion) for all other movements unless the user overrides and choose lot manually<\/li>\n<li><strong>The different document will be generated for different movement types :<br \/>\n<\/strong><\/li>\n<li>Internal warehouse movement \u2013 movement ticket<\/li>\n<li>Movement between warehouses (branch transfer ) \u2013 Picking List + Lenh Dieu Dong \/ Internal Transfer Note\/Internal Invoice<\/li>\n<li>Others: movement from quarantine to damage: Movement ticket from Quarantine to damage warehouse (ACT)<\/li>\n<li>Shipment movement: The system will capture the movement of which shipment, contract number, and order reference to track stock damaged or missing because of insurance, supplier, forwarder or customer mistakes.<\/li>\n<\/ul>\n<p>UI \/Report Layout<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18285 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move-1.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move 1\" width=\"810\" height=\"227\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move-1.png 810w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move-1-300x84.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move-1-768x215.png 768w\" sizes=\"auto, (max-width: 810px) 100vw, 810px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18286 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_2\" width=\"808\" height=\"235\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_2.png 808w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_2-300x87.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_2-768x223.png 768w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18287\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_3.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_3\" width=\"821\" height=\"410\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_3.png 821w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_3-300x150.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Inventory_Move_3-768x384.png 768w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><\/p>\n<h4>Move Confirmation<\/h4>\n<p>Move confirmation help to confirm the movement before processing the actual transaction. The system will generate the move to confirm if the movement, receipt and shipment documents indicate \u2018require confirmation\u2019. The confirmation required document can only processed to adjust inventory after processing the move confirmation.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li><strong>Movement document can be processed after confirmation :<br \/>\n<\/strong><\/li>\n<li>On first completion system will generate Confirmation record and status will be \u201cIn Progress\u201d<\/li>\n<li>Next step to confirm the movement or adjust the stock in the Movement<\/li>\n<li>Finally, complete the Movement<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18296 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_confirmation.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Move_confirmation\" width=\"822\" height=\"251\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_confirmation.png 822w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_confirmation-300x92.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_confirmation-768x235.png 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18298 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_Confirmation_3.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Move_Confirmation_3\" width=\"816\" height=\"147\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_Confirmation_3.png 816w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_Confirmation_3-300x54.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Move_Confirmation_3-768x138.png 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/p>\n<h4>Internal Transfer<\/h4>\n<p>The customer performs internal transfers to move stock between suspense, Damage, Hold, Available (AV), Reverse Log, Quarantine and In transit.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Internal transfer by manual lot selection<\/li>\n<li>Internal transfer by the system using material policy FEFO<\/li>\n<li>Internal transfer document has different document sequence to branch movement<\/li>\n<li>User can move any stock from one locator to another locator at any instance<\/li>\n<li>Documents generated\/printed for internal transfer is different from branch movement<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18284 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Internal_Transfer_1.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Internal_Transfer_1\" width=\"795\" height=\"223\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Internal_Transfer_1.png 795w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Internal_Transfer_1-300x84.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Internal_Transfer_1-768x215.png 768w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/p>\n<h4>Branch Transfer<\/h4>\n<p>This helps to move stock from one branch to another branch using the picklist generated by the system. Manual override can be possible if any variance in the actual picking.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The virtual warehouse will be maintained in both source and destination branch<\/li>\n<li>Partial Movement between branches to be handled manually<\/li>\n<li>Synchronization to take care to zero Virtual warehouse<\/li>\n<li>Branch Transfer and Internal transfer different document sequence number and windows<\/li>\n<li>Movement ticket number to be unique to branches<\/li>\n<li>Selection of LOT can be manual (user decides specific LOT) or system suggested (FEFO)<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18277 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Branch_Transfer.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Branch_Transfer\" width=\"767\" height=\"213\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Branch_Transfer.png 767w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Branch_Transfer-300x83.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/p>\n<h4>Consignment Order<\/h4>\n<p>The consignment process in the customer consists of 4 steps namely Consignment fill up, Consignment Issue, Consignment Invoice and Consignment return. The salesperson\/customer request will be recorded in the system and issued after proper confirmation.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>There 2 types of consignment cash van and others<\/li>\n<li>Cash van has due for 1 week, but it can be overwritten longer or shorter depends on the situation, others will be filled by the user<\/li>\n<li>The notice will be sent to salesperson\/customer to close the consignment based on due date by viewing the report<\/li>\n<li>Inventory move will be generated from consignment order<\/li>\n<li>Movement and Sales Order should have a consignment order reference<\/li>\n<li>Need to capture the borrower name<\/li>\n<li>Consignment move will have Material Reference<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18279 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Order_1.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Order_1\" width=\"445\" height=\"478\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Order_1.png 445w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Order_1-279x300.png 279w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/p>\n<p>Consignment Process Steps :<\/p>\n<p>Step 1: Borrower request to borrow goods after all approval<br \/>\nStep 2: Order processing will record the details<br \/>\nStep 3: IDM creates inventory move for mentioned SKU (Here system will suggest the lot and expiry)<br \/>\nStep 4: The order processor will print the internal invoice from the Inventory move.<\/p>\n<h4>Consignment Settlement<\/h4>\n<p>Consignment return takes place when the salesperson\/customer settles the consignment order by returning the goods, replenish and provide the details of goods sold\/missing.<\/p>\n<p>The customer has two special cases for consignment settlement:<\/p>\n<p>1. The cash van team can borrow for customers&#8217; testing. When they return to the company, it will have correct lot and expired date but empty tins. In this case, the company will receive stock back and wait for accounting approval to move to the damage warehouse.<\/p>\n<p>2. Customer service can borrow to exchange stock for customers in case customers complain about product quantity. So, when they return stock to the company, not an expired date of these products will not match with the consignment stock.<br \/>\nIn this case, the accounting will solve as customers exchange the same products and the same price.<br \/>\nNo financial impact, only update inventory.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>For consignment delivery, the stock will be reduced from Borrow location<\/li>\n<li>Consignment replenishment is handled by closing the existing consignment. A new consignment order will be placed for replenishment. (pick fresh LOT from the available warehouse. Previous consignment LOT will be moved back to AV for immediate sales \u2013 see point 4 on Consignment Return).<\/li>\n<li>For consignment sale, an invoice will be raised against \u2018standard\u2019 customer or DNA customers (depend on SM).<\/li>\n<li>Consignment return will be moved to available or damaged based on the quality of materials.<\/li>\n<li>Consignment missing will be decided by management to charge a salesperson\/customer or to move the missing quantity to the missing locator or sell to the borrower.<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18280 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Settlement.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Settlement\" width=\"445\" height=\"466\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Settlement.png 445w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Consignment_Settlement-286x300.png 286w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/p>\n<hr \/>\n<h3>Manage Fleet<\/h3>\n<p>The managing fleet is used to allocate the trucks for delivery orders based on its capacity and route. Also, it helps to track the delivery orders associated with it. The capacity of the truck will be determined by a carton of the product. The total volume of the truck has been captured along with its registration number, provider and driver.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Need to capture the volume of the truck<\/li>\n<li>The truck volume will be defined by Carton<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18289 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Fleet.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Manage_Fleet\" width=\"488\" height=\"263\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Fleet.png 488w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Fleet-300x162.png 300w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/p>\n<h4>Manage Route<\/h4>\n<p>The managing route is used to group the delivery orders.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The route will be mapped to customer drop ship address<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18292 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Route.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Manage_Route\" width=\"493\" height=\"208\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Route.png 493w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Route-300x127.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/p>\n<h4>Generate Transport Manifest<\/h4>\n<p>This process is used to generate the transport manifest from delivery orders. Delivery orders are grouped by routes that can be filtered by the customer type. This allows users to select one or more or all delivery orders yet to ship. It also lists all the trucks available in the system and allows users to deselect the truck which is not currently available due to breakdown or occupied.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The report should have route, weight, carton, and number of drops, including customer ship-to address<\/li>\n<li>1 Manifest (unique manifest number) to be printed per truck<\/li>\n<li>Actual loading will be updated manually<\/li>\n<li>Transport manifest has no link with Invoice print<\/li>\n<li>The system will generate all DO belong to one route for user to choose manually to update transport manifest. Also, allow choosing DO from another route if the truckload is not full<\/li>\n<li>The volume will have the total number of Cartons in DO<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18283 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Generate_Transfer_Manifest.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Generate_Transfer_Manifest\" width=\"610\" height=\"536\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Generate_Transfer_Manifest.png 610w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Generate_Transfer_Manifest-300x264.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/p>\n<h4>Manage Transport Manifest<\/h4>\n<p>Managing transport manifest is used to update the actual loading and to process the manifest after delivery.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>DA, Supermarket and general trade have separate manifest<\/li>\n<li>Need to track the manifest status<\/li>\n<li>One manifest for one truck<\/li>\n<li>The manifest line should have DO<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18293 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest\" width=\"411\" height=\"224\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest.png 411w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest-300x164.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18294 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest_2.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest_2\" width=\"410\" height=\"114\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest_2.png 410w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Manage_Transport_Manifest_2-300x83.png 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18319 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Transport_Manifest_by_Truck.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Transport_Manifest_by_Truck\" width=\"576\" height=\"472\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Transport_Manifest_by_Truck.png 576w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Transport_Manifest_by_Truck-300x246.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<h4>Manage Product Type<\/h4>\n<p>The customer manages their product hierarchy for generating business intelligence reports. The product franchise allows you to define different franchises of a product example Pre-Natal, Infant, etc. Each product will map to one of the defining franchises.<\/p>\n<h4>Manage Production<\/h4>\n<p>This SR is used to maintain the Production, Production Plan and Production Line details. Data on this screen will be from user key-in. This SR contains three tabs.<br \/>\n1. Production<br \/>\n2. Production Plan<br \/>\n3. Production Line<\/p>\n<p>Production is used to maintain Production details. The production Plan is used to maintain the Production Plan details. Each Production can have one or more Production Plans. Each Production Plan can have one or more Production Lines. Production Line is used to maintaining the production line details.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<p><strong>Production Tab :<\/strong><\/p>\n<ul>\n<li>Production tab will have Name, Description, Active, Movement Date, Create \/ Post Production fields<\/li>\n<li>All the fields in the Production Tab are read-only in HQ and editable in Branches<\/li>\n<li>Other than \u201cName\u201d fields are optional fields. \u201cName\u201d field is a mandatory field. The name should be unique<\/li>\n<li>Once records created in Production Plan tab, Packages are increased and Product inventory is decreased in chosen locator using \u201cCreate\/Post Production\u201d Process button<\/li>\n<\/ul>\n<p><strong>Production Plan Tab :<\/strong><\/p>\n<ul>\n<li>Production Plan tab will have Production Name, Line No, Product, Active, Production Quantity, Locator, Description fields.<\/li>\n<li>All the fields in the Production Plan Tab are read-only in HQ and editable in Branches<\/li>\n<li>The system allows creating multiple production plans for each production<\/li>\n<li>The user wants to create the packages then choose the product BOM in the Product field<\/li>\n<li>User key in the number of packages to be produced<\/li>\n<li>User chose the locator in which the packages to be produced<\/li>\n<li>The system does not allow to create records with Expiry Product BOM<\/li>\n<li>The system does not allow to save with negative quantity<\/li>\n<li>Allow only Product BOM in Production Plan tab<\/li>\n<\/ul>\n<p><strong>Production Line Tab :<\/strong><\/p>\n<ul>\n<li>Production Line tab will have Production Plan, Line No, Product, Active, Movement Quantity, Locator and description fields.<\/li>\n<li>All the fields in the Production Line Tab are read-only in HQ and editable in Branches.<\/li>\n<li>The system allows creating multiple production lines for each production plan.<\/li>\n<li>Once the User process the \u201cCreate\/Post Production\u201d button in the Production Tab, the System increases the packages and decreases the Configured SKU based on User key in Production Quantity from the chosen locator.<\/li>\n<\/ul>\n<h4>Unpack Packages<\/h4>\n<p>This SR is used to unpack the packaged products.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The system allows unpacking the packaged products while the user process the Unpack function<\/li>\n<li>While process with Unpack function, system Increases the SKU and decreases the Packages in the storage of chosen Locator<\/li>\n<li>Unpack function allow only for Hold Warehouse Type Locators<\/li>\n<\/ul>\n<hr \/>\n<h3>Reports<\/h3>\n<p><strong>Transaction Detail Report<\/strong><\/p>\n<p>This report displays the details of a product(s) and their Movement. You select a Movement Type (e.g. Shipment, Material Receipt, Physical Inventory), to and from Movement Date, Product Category, Product, Locator, Lot and Lot No. This report will also display Attribute and Lot data.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The display fields should be configurable<\/li>\n<li>Ability to print the report<\/li>\n<li>Ability to export the report in CSV format<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18318 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Transaction_Detail_Report.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Transaction_Detail_Report\" width=\"765\" height=\"283\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Transaction_Detail_Report.png 765w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Transaction_Detail_Report-300x111.png 300w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/p>\n<h4>Replenish Report<\/h4>\n<p>This report displays all Products that should be ordered based on the Replenishment Rules defined for each product. Use this report when creating your Purchase Orders. You may select a Warehouse and Business Partner.<\/p>\n<p>The report will list the Product, Current Vendor, Maximum and Minimum Quantities, Minimum Order Qty, On Hand and Reserved Qty, as well as the Qty to Order. If a Product has a Replenishment rule of Manual it will not appear on this report. You may also generate a Requisition, Purchase Order, or Inventory Move for the products on this report.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The display fields should be configurable<\/li>\n<li>Ability to print the report<\/li>\n<li>Ability to export the report in CSV format<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18316 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Replinesh_Report.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Replinesh_Report\" width=\"773\" height=\"198\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Replinesh_Report.png 773w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Replinesh_Report-300x77.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Replinesh_Report-768x197.png 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/p>\n<h4>Storage Detail<\/h4>\n<p>This report displays Storage information for a Product(s). You may select a Warehouse, Locator, Product Category, Product, Lot, and Lot No. The report will list details including the Available, Ordered, and Reserved Qty along with Lot, Serial No, and Attribute Instance data.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The display fields should be configurable<\/li>\n<li>Ability to print the report<\/li>\n<li>Ability to export the report in CSV format<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18317 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Storage_Detail.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Storage_Detail\" width=\"768\" height=\"134\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Storage_Detail.png 768w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Storage_Detail-300x52.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<h4>Master Inventory Report<\/h4>\n<p>This report provides complete inventory information in the warehouse.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The display fields should be configurable<\/li>\n<li>Ability to print the report<\/li>\n<li>Ability to export the report in CSV format<\/li>\n<li>In all reports, all SKU will be considered as rows and not a column<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18295 aligncenter\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Master_Inventory_Report.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_Master_Inventory_Report\" width=\"766\" height=\"544\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Master_Inventory_Report.png 766w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_Master_Inventory_Report-300x213.png 300w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/p>\n<h4>VAS Report<\/h4>\n<p>This report provides VAS detail which will help to identify any mismatch before and after VAS. Users can generate this report by the VAS movement date.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>Ability to print the report<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18321\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_VAS_Report.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Management_VAS_Report\" width=\"974\" height=\"324\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_VAS_Report.png 974w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_VAS_Report-300x100.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Management_VAS_Report-768x255.png 768w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/p>\n<h4>Consignment Order Report<\/h4>\n<p>This report provides open consignment details that help to trace consignment due, open consignment. It will list the consignment date, salesperson\/customer, due date, SKU, lot, total quantity and pending quantity.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>The display fields should be configurable<\/li>\n<li>Ability to print the report<\/li>\n<li>Ability to export the report in CSV format<\/li>\n<\/ul>\n<p><strong>UI \/Report Layout<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-18334\" src=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Consignment_Goods_Report.png\" alt=\"TenthPlanet_Compiere_Distribution_Material_Consignment_Goods_Report\" width=\"941\" height=\"397\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Consignment_Goods_Report.png 941w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Consignment_Goods_Report-300x127.png 300w, https:\/\/tenthplanet.in\/compiere\/wp-content\/uploads\/sites\/4\/2019\/02\/TenthPlanet_Compiere_Distribution_Material_Consignment_Goods_Report-768x324.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/p>\n<h4>ITEM MASTER REPORT<\/h4>\n<p>To list the item master report from the mapping fields and constant values based on the template.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>This report is a table-based report with a default header and list of columns<\/li>\n<li>The Report Header, Column Header, and Rows should follow the default NGERP font and size<\/li>\n<li>The report should display the records based on the attached template<\/li>\n<li>The new options \u201cN\u201d and \u201cE\u201d should be added in the reference list for the Product Master\u2019s Classification field in NGERP<\/li>\n<li>For column ISSTOL in the report show the value from product\u2019s classification; if A, then show A, if B then show B, if C then show C, if other than A, B, C use A<\/li>\n<li>For column IIID, if product\u2019s IsActive=\u2019N\u2019 then show 1 else 0<\/li>\n<li>For column DIID, if product\u2019s IsActive=\u2019N\u2019 then show 1 else 0<\/li>\n<li>For column NIID, if the product\u2019s state is \u201cPI\u201d then show 1 else 0<\/li>\n<li>For column SAMPL, if Product\u2019s state is \u201cSA\u201d then show 1 else 0<\/li>\n<li>For column PCONVF, if Purchase UOM is equal to Stock UOM, then the PUR_STOCK_CONV factor should be set to 1. If these 2 are different, then the conversion should be based on the UOM Conversion table\u2019s DivideByRate.<\/li>\n<li>For column SCONVF, if Selling UOM is equal to Stock UOM, then the SELL_STOCK_CONV factor should be set to 1. If these 2 different then the conversion should be based on the UOM conversion table\u2019s DivideByRate.<br \/>\nThe column LPROD should be shown in the format of 1-6-3-3-3. Value to be shown from the Supplier Product Code.<\/li>\n<li>The column D56PROD should show the Supplier Product Code in the format of 1-6-3-3-3<\/li>\n<li>1 = The 1st character of Supplier Product Code<\/li>\n<li>6 = The next 6 characters of Supplier Product Code<\/li>\n<li>3 = The next 3 characters of Supplier Product Code<\/li>\n<li>3 = The next 3 characters of Supplier Product Code<\/li>\n<li>3 = The next 3 characters of Supplier Product Code<\/li>\n<li>The column IDESC should show the Product English Name, upper case<\/li>\n<li>The column ISCST should show the Price Standard from the \u201cStandard Cost Price List\u201d price list to be created by a customer for this purpose. All the products will have the price defined in this price list<\/li>\n<li>The column AVGSP should show the price standard from \u201cNutrico Selling Price List\u201d<br \/>\nFor purchase UOM, Stock UOM, Sell UOM displays the UOM code<\/li>\n<li>All other mappings for all fields are available in the Item Master Template attached below.<\/li>\n<\/ul>\n<h4>MANAGE ITEM CONSTANT VIEW<\/h4>\n<p>The SR is to create constant value for Supplier fields. These constant values will help when generating the Item Master Report for Supplier.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>All the columns that will have constant value should be maintained as an Oracle view (not needed to create these columns in Product Master)<\/li>\n<li>These columns will be shown in the Item Master Report<\/li>\n<li>These columns need not be added in the Product Master table<\/li>\n<li>The following are the fields that need to be managed as Constant view in NGERP<\/li>\n<\/ul>\n<h4>Master Price List Change Report<\/h4>\n<p>This report lists the changes made from all fields of \u201cPrice List\u201d, \u201dVersion\u201d and \u201cProduct Price\u201d tab from Price List screen in a specific period of time.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>This report should be available ONLY in HQ<\/li>\n<li>This Report is a form-based report with header and footer based on format given<\/li>\n<li>User should be able to export the report in EXCEL and PDF format<\/li>\n<li>Parameters for the report :<\/li>\n<li>Region \u2013 Optional parameter<\/li>\n<li>Updated Date &#8211; Mandatory<\/li>\n<li>Price List drop-down box \u2013 Optional parameter and it will have the values \u201cSales Price List\u201d, \u201dPurchase Price List\u201d and \u201dBlank\u201d<\/li>\n<li>If User chooses \u201cSales Price List\u201d then only records related to Sales Price List will be shown<\/li>\n<li>If User chooses \u201cPurchase Price List\u201d, then only records related to the Purchase Price List will be shown<\/li>\n<li>If User chooses Blank Option, then all (sales Price List and Purchase Price list) records will be shown<\/li>\n<li>This report should not show NTA Price List changes details<\/li>\n<\/ul>\n<h4>Master Product Change Report<\/h4>\n<p>This report lists the changes made in each field of the \u201cProduct\u201d and \u201cPrice\u201d tab from Product Screen in a specific period of time.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>This report should be available ONLY in HQ<\/li>\n<li>User should be able to generate the report using Updated Date parameter (Between From Date and To Date) and it is mandatory<\/li>\n<li>This Report is a form-based report with header and footer based on format given<\/li>\n<li>User should be able to export the report in EXCEL and PDF format<\/li>\n<li>This report should not show the NTA Product \/ Price list changes<\/li>\n<\/ul>\n<h4>STOCK ON HAND REPORT<\/h4>\n<p>Stock on Hand Report displays the Inventory on hand on a daily basis. This report is used to identify the exact lot, quantity and inventory status of each product in hand. This report is useful to plan the Supply of materials by Suppliers to customers.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>User should be able to generate the report from the system based on format given<\/li>\n<li>This report is a retro report with as of date parameter<\/li>\n<li>The report does not have any preprinted format to print, and it is a simple table-based report to extract<\/li>\n<li>The report will be generated on a daily basis<\/li>\n<li>Ability to export in XLS format with exact decimal values as mentioned in the template<\/li>\n<li>We need to display all the inventory records from the warehouse for this buffer table<\/li>\n<li>The system should export only those products that are Active in the system<\/li>\n<li>Data for 17 Columns (total 33 Columns) needs to be displayed as in the new requirements of the Full-DRP model. See column G for more details. Other fields will remain in the report with either blank or 0 values.<\/li>\n<li>For Column AFFIUSER, the user id should be the login name in the NGERP system. In case we need to extract it automatically then it should be default as \u201cSuperUser\u201d or \u201cSystem\u201d<\/li>\n<li>In the report, if products have the same Lot No in different locations or locators in the same status, we need to sum it up and show as one row<\/li>\n<li>For column LLOT, for new products without stock, the value to be populated is \u201cBLANK\u201d<\/li>\n<li>For the column OHACT (On Hand Actual), OHPLN (On Hand Planning), and OHFIN (On Hand Financial) the following is the logic to be used to populate<\/li>\n<li>OHACT (On Hand Actual) &#8211; Include Warehouse Type \u201cAvailable for Sales\u201d and<br \/>\n\u201cIn Transit\u201d (exclude locator HCM ITS XHO and CDC ITS CDC)<\/li>\n<li>OHPLN (On-Hand Planning) &#8211; On-hand Actual + Hold WH (all locators)<\/li>\n<li>OHFIN (On Hand Financial) &#8211; Include stock from all Warehouse Types<\/li>\n<li>For new products, the value of OHACT, OHPLN, and OHFIN should be 0<\/li>\n<li>For new products, the column LEXDT (expiry date) should have defaulted to &#8220;99991231&#8221;<\/li>\n<li>For the column &#8220;IMENDT&#8221; (Lot Effective Date), the date should be populated based on the Lot Creation Date (from either M_Lot or M_AttributeSetInstance, needs to be confirmed)<\/li>\n<li>For column &#8220;LSTS&#8221; the default value should be &#8220;A&#8221;.<\/li>\n<li>Sorting order is based on the Key Field Column in the Gold On Hand Excel sheet.<\/li>\n<\/ul>\n<h4>INVENTORY TRANSACTION REPORT<\/h4>\n<p>Inventory Transaction Report helps to display the Inventory Transaction like Purchase and Sales on a daily basis in the NGERP system.<\/p>\n<p><strong>Business Rules<\/strong><\/p>\n<ul>\n<li>User should be able to generate the report for a specific date<\/li>\n<li>The only parameter for this report is the date parameter<\/li>\n<li>The report does not have any pre-printed format to print, and it is a simple table-based report to extract<\/li>\n<li>The report should have the ability to export in XLS format<\/li>\n<li>Required data for 15 fields (total 30 fields) between based on new requirements of the Full-DRP model. See column E for more details. Other fields will remain in the report with either blank or 0 values<\/li>\n<li>Only completed (\u2018CO\u2019,\u2019CL\u2019) transactions should be considered for the export. Both Material Receipt and AR Invoices<\/li>\n<li>The transactions should be displayed in the report based on the Material Receipt &#8220;MovementDate&#8221; or AR Invoice &#8220;DateInvoiced&#8221;<\/li>\n<li>The column AFF_INS_USER should be populated as a login user ID in NGERP. In case we need to extract it automatically then it should be default as \u201cSuperUser\u201d or \u201cSystem\u201d<\/li>\n<li>The report should be generated at company level and the following attachment contains the format and rules to generate the report (as attached in UI Layout)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Unit of measure is a standardize quantity of physical property, customer manages a products with four different UOM namely \u2018Each\u2019 (tin, bottle, sachets), Carton, Dozen and Pallet.<\/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":[33,34],"tags":[],"class_list":["post-18274","post","type-post","status-publish","format-standard","hentry","category-solution","category-distribution"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts\/18274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/comments?post=18274"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/posts\/18274\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/media?parent=18274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/categories?post=18274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/compiere\/wp-json\/wp\/v2\/tags?post=18274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}