{"id":13297,"date":"2025-02-28T04:53:11","date_gmt":"2025-02-28T04:53:11","guid":{"rendered":"https:\/\/jaldi.store\/?p=12378"},"modified":"2026-09-02T11:14:12","modified_gmt":"2026-09-02T11:14:12","slug":"how-to-view-sales-performance-report-with-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-view-sales-performance-report-with-adempiere-retail\/","title":{"rendered":"How to view Sales Performance Report with Adempiere Retail"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>Sales Performance Report<\/strong> is a summary that shows,<strong>How well sales are doing over a specific period \u2014 like total sales made, targets met, and comparisons to previous periods.<\/strong><\/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>Measure Sales Success<\/li>\n\n\n\n<li>Evaluate Sales Teams or Individuals<\/li>\n\n\n\n<li>Make Informed Business Decisions<\/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>Maintain Accurate Sales Data<\/li>\n\n\n\n<li>Reporting Period<\/li>\n\n\n\n<li>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>Reporting Period<\/li>\n\n\n\n<li>Group Sales Data Appropriately<\/li>\n\n\n\n<li>Maintain Data Integrity<\/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 Performance Report\u2019<\/strong> in <strong>Menu<\/strong> -&gt; <strong>Sales reports<\/strong> &gt; <strong>Manager report<\/strong> &gt; <strong>Sales Performance Report<\/strong> or Search <strong>Sales Performance Report<\/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-Sales-PerfomanceReport.png\" alt=\"Tenthplanet-ADempiere-Sales Performance Report\" class=\"wp-image-25575\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport-300x183.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport-768x469.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 ,Batch\/product wise and Parameter to open the <strong>Sales Performance Report<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"877\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport1.png\" alt=\"Tenthplanet-ADempiere-Sales Performance Report-1\" class=\"wp-image-25579\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport1.png 1005w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport1-300x262.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport1-768x670.png 768w\" sizes=\"auto, (max-width: 1005px) 100vw, 1005px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3 :<\/strong> To view a preview of the <strong>Sales Performance Report<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"713\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport2.png\" alt=\"Tenthplanet-ADempiere-Sales Performance Report-2\" class=\"wp-image-25584\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport2-300x209.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Sales-PerfomanceReport2-768x535.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Item Code : <\/strong>To show the <strong>item code<\/strong> in a Sales Performance Report, you should include a column that displays the unique identifier for each product or service sold. This item code helps to precisely track and differentiate between different products, ensuring that sales data is accurately attributed to the correct items.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Product Name : <\/strong>To show the <strong>product name<\/strong> in a Sales Performance Report, you should include a column that lists the specific name of each product or service sold during the reporting period. This provides clarity on which products are contributing to sales and enables a deeper analysis of sales performance at the product level.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>HSN Code : <\/strong>To show the <strong>HSN code<\/strong> in a Sales Performance Report, you should include a column that lists the Harmonized System of Nomenclature (HSN) code for each product or service sold.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MRP : <\/strong>To show the <strong>MRP<\/strong> (Maximum Retail Price) in a Sales Performance Report, you should include a column displaying the MRP of each product or service sold during the reporting period. The MRP represents the highest price at which a product can be sold to the consumer, as set by the manufacturer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>TAX : <\/strong>To show <strong>tax<\/strong> in a Sales Performance Report, you should include a column that details the tax amount applied to each sale, which could include GST or other relevant taxes depending on the region.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sold Quantity : <\/strong>To show <strong>sold quantity<\/strong> in a Sales Performance Report, you should include a column that displays the total number of units sold for each product or service during the reporting period. This metric is crucial for understanding product demand and evaluating sales volume. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Total Landed Cost : <\/strong>To show the <strong>total landed cost<\/strong> in a Sales Performance Report, you should include a column that details the total cost of acquiring and delivering each product, which typically includes the product&#8217;s purchase price, shipping fees, customs duties, taxes, and any other costs incurred to bring the item to the point of sale.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sold Value : <\/strong>To show the <strong>sold value<\/strong> in a Sales Performance Report, you should include a column that reflects the total monetary value of each product or service sold during the reporting period.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Profit : <\/strong>To show <strong>profit<\/strong> in a Sales Performance Report, you should include a column that calculates the profit for each product or service, typically by subtracting the total cost (including landed cost, production costs, or COGS) from the sold value or sales revenue.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Mark Down % : <\/strong>To show the <strong>markdown percentage<\/strong> in a Sales Performance Report, you should include a column that calculates the percentage by which the original selling price of a product has been reduced. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Mark Up % : <\/strong>To show the <strong>markup percentage<\/strong> in a Sales Performance Report, you should include a column that calculates the percentage difference between the cost price of a product and its selling price. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Average Quantity : <\/strong>To show the <strong>average quantity<\/strong> in a Sales Performance Report, you should include a column that calculates the average number of units sold per transaction or over a specific period<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Brand : <\/strong>To show the <strong>brand<\/strong> in a Sales Performance Report, you should include a column that identifies the brand associated with each product sold during the reporting period. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Classification : <\/strong>To show <strong>classification<\/strong> in a Sales Performance Report, you should include a column that categorizes each product based on predefined classifications, such as product type, category, or industry segment. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Product Department : <\/strong>To show the <strong>product department<\/strong> in a Sales Performance Report, you should include a column that identifies the specific department or business unit responsible for each product sold, such as electronics, apparel, or home goods.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Merchandise : <\/strong>To show <strong>merchandise<\/strong> in a Sales Performance Report, you should include a column that specifies the type of merchandise or product being sold, such as specific collections, brands, or item categories like footwear, clothing, or accessories. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Manufacturer : <\/strong>To show the <strong>manufacturer<\/strong> in a Sales Performance Report, you should include a column that identifies the manufacturer or supplier of each product sold.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Product Category : <\/strong>To show <strong>product category<\/strong> in a Sales Performance Report, you should include a column that classifies each product into its respective category, such as electronics, clothing, home goods, or beauty products. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sub Category : <\/strong>To show <strong>sub-category<\/strong> in a Sales Performance Report, you should include a column that further divides each product into a more specific sub-category within its primary product category, such as &#8220;smartphones&#8221; under &#8220;electronics&#8221; or &#8220;running shoes&#8221; under &#8220;footwear.&#8221; <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Purchase VAT : <\/strong>To show <strong>purchase VAT<\/strong> in a Sales Performance Report, you should include a column that displays the Value Added Tax (VAT) applied on the purchase cost of the products sold, which reflects the tax paid on the items when acquired from suppliers. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Vendor : <\/strong>To show the <strong>vendor<\/strong> in a Sales Performance Report, you should include a column that identifies the specific supplier or vendor from whom each product was purchased. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Item Type : <\/strong>To show<strong> item type<\/strong> in a Sales Performance Report, you should include a column that categorizes each product by its specific type, such as &#8220;physical goods,&#8221; &#8220;digital products,&#8221; &#8220;services,&#8221; or &#8220;bundled items.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Vendor Code : <\/strong>To show <strong>vendor code<\/strong> in a Sales Performance Report, you should include a column that displays the unique identifier or code assigned to each vendor or supplier. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Margin By WALC : <\/strong>To show <strong>margin by WALC<\/strong> (Weighted Average Landed Cost) in a Sales Performance Report, you should include a column that calculates the profit margin based on the weighted average cost of each product, which includes all costs associated with getting the product ready for sale, such as purchase cost, shipping, taxes, and other overheads.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Sales Performance Report is a summary that shows,How well sales are doing over a specific period \u2014 like total [&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,31],"tags":[],"class_list":["post-13297","post","type-post","status-publish","format-standard","hentry","category-jaldi-super-store","category-adempiere-reports","category-adempiere-retail","category-jaldi-life-style"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13297","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=13297"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13297\/revisions"}],"predecessor-version":[{"id":25590,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13297\/revisions\/25590"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=13297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=13297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=13297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}