{"id":3985,"date":"2023-07-31T11:49:20","date_gmt":"2023-07-31T11:49:20","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/%d8%b9%d8%b1%d8%b6-%d8%aa%d9%82%d8%b1%d9%8a%d8%b1-%d8%a5%d8%ac%d9%85%d8%a7%d9%84%d9%89-%d9%85%d8%a8%d9%8a%d8%b9%d8%a7%d8%aa-%d8%a7%d9%84%d9%85%d9%86%d8%aa%d8%ac%d8%a7%d8%aa\/"},"modified":"2026-10-20T13:48:22","modified_gmt":"2026-10-20T13:48:22","slug":"displaying-the-total-products-sales-report","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/","title":{"rendered":"Displaying the Total Products Sales Report"},"content":{"rendered":"<div dir=\"ltr\" lang=\"en\">\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The <strong style=\"color: #111827;\">Total POS Products Sales<\/strong> report shows every product sold from the point of sale, with the quantity sold, the quantity returned, the net quantity and the values. This guide explains how to view and filter the report, and how to find <strong style=\"color: #111827;\">the number of items sold from each point of sale<\/strong> and <strong style=\"color: #111827;\">the number of items that have refunds<\/strong>.<\/p>\n<div style=\"display: flex; gap: 10px; background: #f6f8fb; border-left: 4px solid #1a56db; border-radius: 6px; padding: 14px 16px; margin: 0 0 18px;\">\n<p><span style=\"flex: 0 0 auto; font-size: 18px; line-height: 1.6;\">\ud83d\udec8<\/span><\/p>\n<p style=\"margin: 0; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Note:<\/strong> Opening POS reports requires the <strong style=\"color: #111827;\">View All Sessions<\/strong> or <strong style=\"color: #111827;\">View His Sessions<\/strong> permission. Without either of them, the message <strong style=\"color: #111827;\">You are not allowed to access this page<\/strong> appears. Set these from <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/roles\/index\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Roles<\/strong><\/a>.<\/p>\n<\/div>\n<div style=\"border: 1px solid #e5e7eb; border-radius: 8px; padding: 12px 16px; margin: 0 0 20px;\">\n<p style=\"margin: 0 0 6px; font-weight: bold; color: #111827;\">Contents<\/p>\n<ol style=\"margin: 0; padding-left: 22px;\">\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#open\"><strong style=\"color: #1a56db;\">View the report<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#per-pos\"><strong style=\"color: #1a56db;\">Number of items per point of sale and number of refunded items<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#credit\"><strong style=\"color: #1a56db;\">Refunds and credit notes<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#filters\"><strong style=\"color: #1a56db;\">Report filters<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#columns\"><strong style=\"color: #1a56db;\">Report columns<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#rules\"><strong style=\"color: #1a56db;\">Rules and restrictions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#errors\"><strong style=\"color: #1a56db;\">Error messages and solutions<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#settings\"><strong style=\"color: #1a56db;\">Related cases and settings<\/strong><\/a><\/li>\n<li style=\"margin-bottom: 4px;\"><a style=\"color: #1a56db;\" href=\"#faq\"><strong style=\"color: #1a56db;\">FAQ<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"open\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">View the report<\/h2>\n<ol style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">From the main menu, click <strong style=\"color: #111827;\">Point of Sales<\/strong>, then <strong style=\"color: #111827;\">POS Reports<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">In the <strong style=\"color: #111827;\">POS Sales-Transactions<\/strong> section, click <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/pos_shifts\/reports\/total_pos_product_sales\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">View<\/strong><\/a> next to <strong style=\"color: #111827;\">Total POS Products Sales<\/strong>. When it first opens, the report shows the sales of all sessions without filtering.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Set the period in <strong style=\"color: #111827;\">Date From<\/strong> and <strong style=\"color: #111827;\">Date To<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">To filter the report to a specific point of sale, choose the device in the <strong style=\"color: #111827;\">Pos Shift Device<\/strong> field.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Adjust the other filters as needed, then click <strong style=\"color: #111827;\">Show Report<\/strong>.<\/li>\n<\/ol>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">To print, click <strong style=\"color: #111827;\">Print<\/strong>. To export, click <strong style=\"color: #111827;\">Export<\/strong> and choose <strong style=\"color: #111827;\">Export to CSV<\/strong>, <strong style=\"color: #111827;\">Export to Excel<\/strong> or <strong style=\"color: #111827;\">Export to PDF<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">To clear the filters, click <strong style=\"color: #111827;\">Reset<\/strong>.<\/li>\n<\/ul>\n<h2 id=\"per-pos\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Number of items per point of sale and number of refunded items<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report shows each product on one line and doesn&#8217;t split the results by point of sale in a single table. So view the report for each point of sale separately:<\/p>\n<ol style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Choose the first POS device in <strong style=\"color: #111827;\">Pos Shift Device<\/strong>, set the period, then click <strong style=\"color: #111827;\">Show Report<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The <strong style=\"color: #111827;\">number of different items<\/strong> sold from this point of sale = the <strong style=\"color: #111827;\">number of lines in the report<\/strong>, since each line is one item.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The <strong style=\"color: #111827;\">number of units sold<\/strong> appears in the totals row under the <strong style=\"color: #111827;\">Sales<\/strong> column, and the <strong style=\"color: #111827;\">net units<\/strong> after refunds under the <strong style=\"color: #111827;\">Net<\/strong> column.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The <strong style=\"color: #111827;\">items that have refunds<\/strong> are the lines with a value greater than zero in the <strong style=\"color: #111827;\">Refunds<\/strong> column. To show them first, choose <strong style=\"color: #111827;\">Refund Descending<\/strong> in <strong style=\"color: #111827;\">Order By<\/strong>, then <strong style=\"color: #111827;\">Show Report<\/strong>. The number of refunded units is in the totals row under <strong style=\"color: #111827;\">Refunds<\/strong>.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Repeat the steps for each device. To count the lines easily, export each report to Excel.<\/li>\n<\/ol>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Example: the report for the \u201cCashier 1\u201d device for March:<\/p>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px; font-size: 15px; line-height: 1.8; color: #1f2430;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Name<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Sales<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Refunds<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Net<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Product A<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">20<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">2<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">18<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Product B<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">15<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">0<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">15<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Product C<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">5<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">1<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">4<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Totals<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">40<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">3<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">37<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">\u201cCashier 1\u201d sold <strong style=\"color: #111827;\">3 items<\/strong> totaling 40 units, with refunds on <strong style=\"color: #111827;\">2 items<\/strong> (Product A and Product C) totaling 3 units, for a net of 37 units.<\/p>\n<h2 id=\"credit\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Refunds and credit notes<\/h2>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The <strong style=\"color: #111827;\">Refunds<\/strong> column counts only the <strong style=\"color: #111827;\">refund receipts<\/strong> recorded from the point of sale, <strong style=\"color: #111827;\">and doesn\u2019t count credit notes<\/strong>:<\/p>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px; font-size: 15px; line-height: 1.8; color: #1f2430;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Document<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Is it created from POS?<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Does it appear in the report?<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Refund Receipt<\/strong> (POS refund)<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes, from <strong style=\"color: #111827;\">Refund<\/strong> on the selling screen.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Yes, in the <strong style=\"color: #111827;\">Refunds<\/strong> column.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Credit Note<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No, it&#8217;s created from the invoices screen only.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">So if the question is about <strong style=\"color: #111827;\">items that have a credit note<\/strong>, what this means in POS is <strong style=\"color: #111827;\">refunded items<\/strong> (the Refunds column). For credit notes recorded from the invoices screen, review them in <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/invoices\/creditnotes\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Credit Notes<\/strong><\/a>.<\/p>\n<h2 id=\"filters\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Report filters<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px; font-size: 15px; line-height: 1.8; color: #1f2430;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Filter<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Description<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Shown when<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Pos Shift ID<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">One or more sales sessions.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Pos Shift Device<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The POS device; you can choose more than one device. The field name appears in English.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Pos Shift<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The POS shift, such as morning or evening. You can choose more than one shift.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Store<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The warehouse the point of sale dispenses from (only the warehouses you&#8217;re allowed to view).<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Date From<\/strong> \/ <strong style=\"color: #111827;\">Date To<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The period, based on the <strong style=\"color: #111827;\">session opening date<\/strong>, not the invoice date.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Order Source<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The order source recorded on the invoice.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">When order sources exist<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Branch<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">One or more branches.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">When branches are enabled<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Currency<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">All In<\/strong> the default currency (default), <strong style=\"color: #111827;\">All Separated<\/strong> (a table for each currency), or a specific currency.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Group By<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Products<\/strong> (default), or <strong style=\"color: #111827;\">Branch<\/strong>.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">When branches are enabled<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Order By<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Code or name, ascending or descending, or options such as <strong style=\"color: #111827;\">Refund Descending<\/strong> (most refunded first) and <strong style=\"color: #111827;\">Sales Descending<\/strong> (best-selling first).<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Always<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"columns\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Report columns<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px; font-size: 15px; line-height: 1.8; color: #1f2430;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Column<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Description<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Code<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The product code, or its ID if it has no code.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Name<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The product name.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Branch<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The branch the product was sold from (when branches are enabled).<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Sales<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The quantity sold in POS invoices.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Refunds<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The quantity returned in refund receipts recorded from the POS.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Net<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Sales \u2212 Refunds.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Average<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The average selling price per unit, excluding tax.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Taxes<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The tax amount on the product.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Discount<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The net discount on the product after deducting the refunds&#8217; discount.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">Total<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">The net sales value of the product after deducting refunds.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"rules\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Rules and restrictions<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report counts only sales invoices and refund receipts recorded from POS sessions. Invoices added from the invoices screen and credit notes aren&#8217;t included.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">A refund is counted on the session and point of sale it was recorded from, even if the original invoice is from another session.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The period is based on the <strong style=\"color: #111827;\">session opening date<\/strong>, so invoices in a session opened before the start of the period don&#8217;t appear, even if the invoice date is within the period.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report doesn&#8217;t split results by point of sale; view it once per device.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">It doesn&#8217;t show the number of items as a ready figure: the number of items = the number of lines. The <strong style=\"color: #111827;\">Subtotal<\/strong> and <strong style=\"color: #111827;\">Totals<\/strong> rows add up quantities and values, not the number of items.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\">The report is view-only and doesn&#8217;t change any invoice or stock quantity.<\/li>\n<\/ul>\n<h2 id=\"errors\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Error messages and solutions<\/h2>\n<table style=\"width: 100%; border-collapse: collapse; margin: 0 0 18px; font-size: 15px; line-height: 1.8; color: #1f2430;\">\n<tbody>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Cause<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Message<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; background: #f6f8fb; font-weight: bold;\">Solution<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">You don&#8217;t have permission to view sessions.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">You are not allowed to access this page<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Add the <strong style=\"color: #111827;\">View All Sessions<\/strong> or <strong style=\"color: #111827;\">View His Sessions<\/strong> permission to your role.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">No sales match the filters.<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\"><strong style=\"color: #111827;\">No data match the supplied filters<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px 12px; text-align: left; vertical-align: top;\">Widen the period, or change the device, shift, warehouse or branch.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"settings\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">Related cases and settings<\/h2>\n<ul style=\"margin: 0 0 16px; padding-left: 26px;\">\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">POS devices<\/strong>: <strong style=\"color: #111827;\">Pos Shift Device<\/strong> lists the devices registered in <strong style=\"color: #111827;\">POS Devices<\/strong>, so give each point of sale a device with a clear name.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Branches<\/strong>: a <strong style=\"color: #111827;\">Branch<\/strong> filter and column appear, and the product appears on a separate line for each branch it was sold from, so its name may repeat.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Multiple currencies<\/strong>: if you have sessions in more than one currency, choose <strong style=\"color: #111827;\">All Separated<\/strong> to show a table for each currency.<\/li>\n<li style=\"margin-bottom: 10px; line-height: 1.9; font-size: 16px; color: #1f2430;\"><strong style=\"color: #111827;\">Deleted products<\/strong>: their sales remain in the report, and their line may appear without a name.<\/li>\n<\/ul>\n<h2 id=\"faq\" style=\"font-size: 22px; font-weight: bold; color: #111827; margin: 32px 0 14px; padding-bottom: 8px; border-bottom: 2px solid #eef0f3;\">FAQ<\/h2>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">How do I find the number of items per point of sale and the number of items that have a credit note?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">From <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/pos_shifts\/reports\/total_pos_product_sales\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Total POS Products Sales<\/strong><\/a>: choose the point of sale in <strong style=\"color: #111827;\">Pos Shift Device<\/strong>, set the period, then <strong style=\"color: #111827;\">Show Report<\/strong>. The number of lines = the number of items sold, and the refunded items are the lines where <strong style=\"color: #111827;\">Refunds<\/strong> is greater than zero. Repeat for each point of sale. <a style=\"color: #1a56db;\" href=\"#per-pos\"><strong style=\"color: #1a56db;\">Details<\/strong><\/a>.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Why don&#8217;t credit notes appear in the Refunds column?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Because a POS refund is recorded as a <strong style=\"color: #111827;\">refund receipt<\/strong>, and credit notes aren&#8217;t created from the POS. Review them in <a style=\"color: #1a56db;\" href=\"https:\/\/go.daftra.com\/owner\/invoices\/creditnotes\" target=\"_blank\" rel=\"noopener\"><strong style=\"color: #1a56db;\">Credit Notes<\/strong><\/a>. <a style=\"color: #1a56db;\" href=\"#credit\"><strong style=\"color: #1a56db;\">Details<\/strong><\/a>.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Can I view all points of sale in one table split by point of sale?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No. The report combines a product&#8217;s sales from all selected devices into one line; view it for each device separately.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Why doesn&#8217;t a POS invoice appear even though its date is within the period?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">Because the report is based on the session opening date. Widen the period to include the session opening date, or choose the session in <strong style=\"color: #111827;\">Pos Shift ID<\/strong>.<\/p>\n<h3 style=\"font-size: 18px; font-weight: bold; color: #111827; margin: 24px 0 10px;\">Does the report include sales from the invoices screen?<\/h3>\n<p style=\"margin: 0 0 14px; line-height: 1.9; font-size: 16px; color: #1f2430;\">No, the report is for POS sales only.<\/p>\n<\/div>\n","protected":false},"author":17,"featured_media":0,"template":"","categories":[2036,2164,2535],"tags":[4023,4386,24288,24286,24289,24297,24296,24293,24290,4081,24295,24291,24292,24299,24294,24298,4082,24218,24228,24287,24285],"class_list":["post-3985","tutorial","type-tutorial","status-publish","hentry","category-sales","category-point-of-sales","category----en","tag-credit-note","tag-credit-notes","tag-credit-notes-not-showing-in-pos","tag-items-with-credit-notes","tag-net-amount","tag-number-of-items-per-pos","tag-number-of-items-sold","tag-pos-device","tag-pos-product-sales-report","tag-pos-reports","tag-pos-sales-activity","tag-pos-sales-report","tag-pos-sales-report-by-product","tag-pos-shift-device-en","tag-product-sales-activity-in-pos","tag-product-sales-in-pos","tag-reports","tag-returned-amount","tag-returned-invoice","tag-returned-items","tag-total-product-sales"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Displaying the Total Products Sales Report - Daftra Knowledge Base<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Displaying the Total Products Sales Report - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"The Total POS Products Sales report shows every product sold from the point of sale, with the quantity sold, the quantity returned, the net quantity and the values. This guide explains how to view and filter the report, and how to find the number of items sold from each point of sale and the number [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-20T13:48:22+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.daftra.com\/#organization\",\"name\":\"Daftra\",\"url\":\"https:\/\/docs.daftra.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg\",\"caption\":\"Daftra\"},\"image\":{\"@id\":\"https:\/\/docs.daftra.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"publisher\":{\"@id\":\"https:\/\/docs.daftra.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/\",\"name\":\"Displaying the Total Products Sales Report - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"datePublished\":\"2023-07-31T11:49:20+00:00\",\"dateModified\":\"2026-10-20T13:48:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Displaying the Total Products Sales Report\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Displaying the Total Products Sales Report - Daftra Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/","og_locale":"en_US","og_type":"article","og_title":"Displaying the Total Products Sales Report - Daftra Knowledge Base","og_description":"The Total POS Products Sales report shows every product sold from the point of sale, with the quantity sold, the quantity returned, the net quantity and the values. This guide explains how to view and filter the report, and how to find the number of items sold from each point of sale and the number [&hellip;]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-10-20T13:48:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/docs.daftra.com\/#organization","name":"Daftra","url":"https:\/\/docs.daftra.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/#logo","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2023\/10\/daftra-ar.svg","caption":"Daftra"},"image":{"@id":"https:\/\/docs.daftra.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","publisher":{"@id":"https:\/\/docs.daftra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/","name":"Displaying the Total Products Sales Report - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"datePublished":"2023-07-31T11:49:20+00:00","dateModified":"2026-10-20T13:48:22+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/displaying-the-total-products-sales-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Displaying the Total Products Sales Report"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/3985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":3,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/3985\/revisions"}],"predecessor-version":[{"id":151268,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/3985\/revisions\/151268"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=3985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=3985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=3985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}