{"id":13280,"date":"2025-02-28T04:53:12","date_gmt":"2025-02-28T04:53:12","guid":{"rendered":"https:\/\/jaldi.store\/?p=12258"},"modified":"2026-08-25T04:18:06","modified_gmt":"2026-08-25T04:18:06","slug":"how-to-view-sales-attribute-report-dm-in-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-view-sales-attribute-report-dm-in-adempiere-retail\/","title":{"rendered":"How to view Sales Attribute Report (D&amp;M) in Adempiere Retail"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>Sales Attribute Report<\/strong> is a report that shows sales data based on different <strong>attributes or characteristics<\/strong> of products or transactions.<\/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>Head cashier<\/li>\n\n\n\n<li>Sales 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>Analyze Sales by Product Features<\/li>\n\n\n\n<li>Track Sales Channels and Payment Methods<\/li>\n\n\n\n<li>Generate Customized Reports<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisite Activities<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Assign Attributes to Products and Transactions<\/li>\n\n\n\n<li>Use a POS or ERP System That Supports Attribute Tracking<\/li>\n\n\n\n<li>Reporting Period and Filters<\/li>\n\n\n\n<li>Validate Data Accuracy<\/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>Sales Transactions Must Capture Attribute Data<\/li>\n\n\n\n<li>Only Completed Sales Are Included<\/li>\n\n\n\n<li>Support Filtering and Sorting<\/li>\n\n\n\n<li>Report Time frame Must Be Defined<\/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>Select \u2018<strong>Sales Attribute Report (D&amp;M)\u2019<\/strong> in <strong>Menu<\/strong> -&gt; <strong>Sales reports<\/strong> &gt; <strong>Manager report<\/strong> &gt; <strong>Sales Attribute Report (D&amp;M)<\/strong> or Search <strong>Sales Attribute Report (D&amp;M)<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"626\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM.png\" alt=\"Tenthplanet ADempiere Report-Sales Attribute Report (D&amp;M)\" class=\"wp-image-24841\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-300x183.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-768x470.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2 : <\/strong>Select the date range  and attribute to open the <strong>Sales Attribute Report (D&amp;M)<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"665\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-1.png\" alt=\"Tenthplanet ADempiere Report-Sales Attribute Report (D&amp;M)-1\" class=\"wp-image-24842\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-1-300x195.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-1-768x499.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3 :<\/strong> To view a preview of the <strong>Sales Attribute Report (D&amp;M)<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"625\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-2.png\" alt=\"Tenthplanet ADempiere Report-Sales Attribute Report (D&amp;M)-2\" class=\"wp-image-24844\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-2-300x183.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/Tenthplanet-ADempiere-Report-Sales-Attribute-Report-DM-2-768x469.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Date invoice : <\/strong>The inclusion of a date in a Sales Attribute Report is essential for several reasons, as it helps to provide context and allow for meaningful analysis of sales performance over time. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Name : <\/strong>Including the name (typically referring to product name, attribute name, or department name) in a Sales Attribute Report is important for several key reasons. It provides clear context for the<br> sales data and enables businesses to identify and analyze sales performance based on specific products, attributes, or categories.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sold Quantity : <\/strong>Showing sold quantity in a Sales Attribute Report is crucial for providing a comprehensive understanding of how a specific product, product variant, or product attribute (such as size, color, or brand) is performing in terms of units sold.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sold Value : <\/strong>The sold value provides direct insight into the revenue generated from the sale of specific products or attributes over a given period. This allows businesses to track their financial performance at a granular level.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MRP Value : <\/strong>Showing the MRP value alongside the actual selling price helps businesses analyze how much discount or deviation is being applied from the retail price.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Net Value : <\/strong>The Net Value reflects the true revenue a business earns from sales transactions, taking into account any discounts, promotions, returns, and tax adjustments.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Profit : <\/strong>In a Sales Attribute Report, Profit typically refers to the amount of money the business earns from the sale of products after accounting for the cost of goods sold (COGS) or cost of sales.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Mark Down % : <\/strong>In a Sales Attribute Report, Markdown % typically refers to the percentage reduction from the original or list price of a product to the actual selling price. It is an important metric for assessing how much a product&#8217;s price has been discounted, usually as part of a sales promotion, clearance, or price adjustment strategy.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Mark Up % : <\/strong>In a Sales Attribute Report, Markup % is a key metric that shows the percentage difference between the cost price (or cost of goods sold &#8211; COGS) and the selling price of a product. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Contribution % : <\/strong>In a Sales Attribute Report, Contribution % refers to the percentage that each product, department, or category contributes to the overall sales, profit, or other relevant financial <br>metrics. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Margin by WALC :  <\/strong>In the Sales Attribute Report, Margin by WALC (also known as Margin by Weighted Average Landed Cost) typically refers to the profit margin calculated using the weighted average landed cost (WALC) of products.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Sales Attribute Report is a report that shows sales data based on different attributes or characteristics of products or [&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,31],"tags":[],"class_list":["post-13280","post","type-post","status-publish","format-standard","hentry","category-jaldi-super-store","category-adempiere-reports","category-jaldi-life-style"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13280","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=13280"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13280\/revisions"}],"predecessor-version":[{"id":28481,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13280\/revisions\/28481"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=13280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=13280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=13280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}