{"id":33920,"date":"2025-11-26T10:03:21","date_gmt":"2025-11-26T10:03:21","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=33920"},"modified":"2025-12-11T04:52:17","modified_gmt":"2025-12-11T04:52:17","slug":"how-to-view-the-lot-wise-sales-report-in-odoo-pos","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/reports\/how-to-view-the-lot-wise-sales-report-in-odoo-pos\/","title":{"rendered":"How to View the Lot Wise Sales Report in Odoo POS"},"content":{"rendered":"\n

The Lot Wise Sales Report in Odoo POS helps businesses track sales based on specific batches or lots of products. This is very useful for companies that need to monitor items with expiry dates, packaging batches, or serial-tracked products.<\/p>\n\n\n\n

By checking sales at the lot level, businesses can manage stock more accurately and make better decisions on purchasing, production, and replenishment.<\/p>\n\n\n\n

Accessing the Lot Wise Sales Report<\/strong><\/h2>\n\n\n\n

To open the Lot Wise Sales Report, go to Point of Sale \u2192 Reporting \u2192 Lot Wise Sales<\/strong>. This report is accessible only to the Head Cashier<\/strong>, ensuring that sensitive sales and batch information is viewed only by authorized users.<\/p>\n\n\n\n

\"Odoo<\/figure>\n\n\n\n

The filtering options make it easy to find the right data. You can filter by Lifestyle<\/strong> or Superstore<\/strong> categories, or search using HSN Codes<\/strong>. Grouping options allow you to organize the data by Company, Product, Brand, HSN Code, Division, Department, Category, or Subcategory. For example, choosing Brand will show sales grouped by each brand.<\/p>\n\n\n\n

If additional filters are needed, you can use the Add Custom Filter<\/strong> option to include more fields such as tax amounts, taxable values, or pricelists. The Add Custom Group<\/strong> feature works the same way, letting you include fields like GST Number or Sales Team for more detailed grouping.<\/p>\n\n\n\n

Quick search options allow you to find data by Categories, Brand, or Company. The date field helps you filter transactions within a specific period, making it easier to track sales trends or check performance for a particular day or month.<\/p>\n\n\n\n

\"Odoo<\/figure>\n\n\n\n

Understanding the Fields in the Report<\/strong><\/h2>\n\n\n\n

The Lot Wise Sales Report displays several important fields that help you analyze product performance. The Product Code<\/strong> shows the unique identification of the item, while the HSN Code<\/strong> displays the tax classification along with the applied tax percentage.<\/p>\n\n\n\n

The Brand<\/strong> name of the product is also shown, along with the Sold Quantity<\/strong>, which indicates how many units were sold through the POS.<\/p>\n\n\n\n

    \u2022 Taxable Amount: The total amount before tax, calculated as:\nTotal Amount \/ (1 + Tax %)\n    \u2022 Tax Amount: The tax amount, calculated as:\nTaxable Amount \u00d7 Tax % \/ 100\n    \u2022 Total Amount: The POS bill amount, calculated as:\nTaxable Amount + Tax Amount<\/code><\/pre>\n\n\n\n
Discount information is also available, showing both the discount percentage and the discount amount applied during the POS sale. Product category details are displayed in four levels: Division, Department, Category, and Subcategory, the Company<\/strong> involved in the sale, and the Lot Name<\/strong>, which identifies the specific batch.<\/p>\n\n\n\n
    \u2022 Margin: The profit earned, calculated as:\nMargin = Gross Total \u2013 Cost\n    \u2022 Markup %: The percentage increase on Cost, calculated as:\nMarkup % = (Margin \/ Cost) \u00d7 100\n    \u2022 Markdown %: The percentage reduction from Gross Total, calculated as:\nMarkdown % = (Margin \/ Gross Total) \u00d7 100<\/code><\/pre>\n\n\n\n
You can also view Promotion Discounts<\/strong>, the Promotion Name<\/strong>, and the Order Count<\/strong>, which shows how many POS orders were completed for that item or lot.<\/p>\n\n\n\n
\"Odoo<\/figure>\n\n\n\n
Viewing the Report in Different Formats<\/strong><\/h2>\n\n\n\n
Odoo offers three different views for the Lot Wise Sales Report.<\/p>\n\n\n\n
The List View<\/strong> displays each record in a table format with rows and columns, making it easy to read detailed data.<\/p>\n\n\n\n
The Pivot View<\/strong> allows you to summarize information by dragging and grouping fields such as Cashier, Date, Company, or Brand, making comparisons easier.<\/p>\n\n\n\n
The Graph View<\/strong> presents the information visually using bar charts, line charts, or pie charts, helping users quickly understand trends or patterns in sales across lots.<\/p>\n\n\n\n
\"Odoo<\/figure>\n\n\n\n
Exporting the Lot Wise Sales Report<\/strong><\/h2>\n\n\n\n
If you need to analyze the data in Excel or share it with others, Odoo allows you to export the report. After applying the necessary filters or groupings, you can click the Export All<\/strong> button, and the report will be downloaded in Excel format. The exported file will reflect the filters and date ranges you selected, making it convenient for offline reporting or further analysis.<\/p>\n\n\n\n
\"Odoo<\/figure>\n\n\n\n
\"Odoo<\/figure>\n","protected":false},"excerpt":{"rendered":"
The Lot Wise Sales Report in Odoo POS helps businesses track sales based on specific batches or lots of products. […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[634],"tags":[617,495,596],"class_list":["post-33920","post","type-post","status-publish","format-standard","hentry","category-reports","tag-lot-wise-sales-report","tag-pos","tag-report"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33920","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=33920"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33920\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=33920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=33920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=33920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}