{"id":13697,"date":"2025-02-28T04:53:32","date_gmt":"2025-02-28T04:53:32","guid":{"rendered":"https:\/\/jaldi.store\/?p=12208"},"modified":"2026-09-01T11:05:38","modified_gmt":"2026-09-01T11:05:38","slug":"how-to-view-transaction-vs-storage-report-in-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-view-transaction-vs-storage-report-in-adempiere-retail\/","title":{"rendered":"How to view Transaction Vs Storage Report in Adempiere Retail"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>Transaction Report<\/strong> shows details of all product movements \u2014 like sales, purchases, returns, or transfers.A <strong>Storage Report<\/strong> shows where products are currently kept and in what quantity.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>User Access<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Who Can Access<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Admin<\/li>\n\n\n\n<li>Back Office<\/li>\n\n\n\n<li>Purchase Manager<\/li>\n\n\n\n<li>Manager<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>What User Can Do<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Track Product Movements<\/li>\n\n\n\n<li>Check Transaction History<\/li>\n\n\n\n<li>Generate Reports by Date or Type<\/li>\n\n\n\n<li>View Current Stock Levels<\/li>\n\n\n\n<li>Identify Low or Overstocked Items<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pre-Requisite Activities<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Product Master Data<\/li>\n\n\n\n<li>User Access Rights<\/li>\n\n\n\n<li>Transaction Types<\/li>\n\n\n\n<li>Stock Entry Update<\/li>\n\n\n\n<li>Barcode\/Labeling<\/li>\n\n\n\n<li>Regular Stock Audits<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Record All Movements<\/li>\n\n\n\n<li>Real-Time Updates<\/li>\n\n\n\n<li>Date Range Filtering<\/li>\n\n\n\n<li>Storage Limits<\/li>\n\n\n\n<li>Location Setup Required<\/li>\n\n\n\n<li>Track Expiry or Condition (if applicable)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>User Interface<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 1:<\/strong> To select a Transaction Vs Storage Report.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"602\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report.png\" alt=\"Tenthplanet ADempiere Report-Transaction Vs Storage Report\" class=\"wp-image-24035\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-300x176.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-768x452.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 2:<\/strong> To enter a Dynamic report Default add this field.Then to click the Start check box and to run the Process.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1023\" height=\"230\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-1.png\" alt=\"Tenthplanet ADempiere Report-Transaction Vs Storage Report-1\" class=\"wp-image-24037\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-1.png 1023w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-1-300x67.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-1-768x173.png 768w\" sizes=\"auto, (max-width: 1023px) 100vw, 1023px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 3:<\/strong> Once to complete the process to show the report based on given parameter.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"464\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-2.png\" alt=\"Tenthplanet ADempiere Report-Transaction Vs Storage Report-2\" class=\"wp-image-24039\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-2-300x136.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-2-768x348.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"913\" height=\"591\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-3-2.png\" alt=\"Tenthplanet ADempiere Report-Transaction Vs Storage Report-3\" class=\"wp-image-24049\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-3-2.png 913w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-3-2-300x194.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-3-2-768x497.png 768w\" sizes=\"auto, (max-width: 913px) 100vw, 913px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"884\" height=\"558\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-4-1.png\" alt=\"Tenthplanet ADempiere Report-Transaction Vs Storage Report-4\" class=\"wp-image-24050\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-4-1.png 884w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-4-1-300x189.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Transaction-Vs-Storage-Report-4-1-768x485.png 768w\" sizes=\"auto, (max-width: 884px) 100vw, 884px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 4:<\/strong> <strong>Code-<\/strong>A product code is a unique identifier assigned to a specific product, typically used by manufacturers, retailers, and distributors to manage and track inventory, sales, and other logistics.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">               <strong>Product name-<\/strong>A product name is the name given to a specific item, good, or service that a company or manufacturer offers for sale to customers. It is used to identify the product and distinguish it from others in the market. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">              <strong>TRX QTY-<\/strong> typically refers to the transaction quantity in a business or financial context. In Business\/Inventory Management,In Financial or Trading Context,In Supply Chain or Logistics.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STR QTY-<\/strong>likely refers to Storage quantity typically refers to the amount of space available or the volume\/amount of items that can be stored in a particular storage facility or system. It can be used in various contexts, such as <strong>Physical Storage<\/strong>,<strong>Data Storage<\/strong>,<strong>Inventory Management<\/strong> The specific meaning depends on the context in which &#8220;storage quantity&#8221; is being used, but it always relates to the amount of items or data that can be stored.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                <strong>MRP-<\/strong> stands for <strong>Material Requirements Planning<\/strong>. It&#8217;s a system used in manufacturing and inventory management to plan and manage the materials needed for production.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>S price-<\/strong>The selling price is the amount of money a seller charges a buyer in exchange for goods or services. It is the final price at which a product or service is offered for sale to customers, and it typically includes factors like the cost of production, profit margin, and any additional expenses (e.g., taxes, shipping fees).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">             <strong>Landed cost-<\/strong>Landed cost refers to the total cost of getting a product from the supplier to its final destination, ready for sale.Product cost,Shipping or Freight charges,Import duties or tariffs,Customs fees,Storage costs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">            <strong>Tax-<\/strong>Tax is a compulsory financial charge or levy imposed by a government on individuals, businesses, or other entities to fund public expenditures and services.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">           <strong>Department-<\/strong>A Product Department is a business division or team within an organization that focuses on the development, management, and marketing of products or services.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">           <strong>Category-<\/strong>A product category is a classification or group of similar products that share common characteristics or serve a similar purpose.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">          <strong>Sub Categories-<\/strong>A product subcategory is a more specific group or subset within a broader. Subcategories help companies and consumers drill down into more precise groups, making it easier to identify and compare products that are similar in more specific ways.<br> For example:<br>-Product Category: Electronics<br>-Subcategories: Smartphones.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">        <strong>Brand-<\/strong>A product brand refers to the identity and image of a specific product or product line.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">        <strong>Locator-<\/strong>A product locator is a tool or system that helps customers find a specific product in a store, online, or across multiple locations. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br><br><br>   <br>  <br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Transaction Report shows details of all product movements \u2014 like sales, purchases, returns, or transfers.A Storage Report shows where [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,90,83],"tags":[],"class_list":["post-13697","post","type-post","status-publish","format-standard","hentry","category-jaldi-super-store","category-adempiere-reports","category-adempiere-retail"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13697","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=13697"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13697\/revisions"}],"predecessor-version":[{"id":25649,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13697\/revisions\/25649"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=13697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=13697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=13697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}