{"id":34792,"date":"2025-12-08T10:59:49","date_gmt":"2025-12-08T10:59:49","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34792"},"modified":"2025-12-11T05:03:37","modified_gmt":"2025-12-11T05:03:37","slug":"how-to-filter-search-and-group-by-the-loyalty-points-report-in-odoo-pos","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/reports\/how-to-filter-search-and-group-by-the-loyalty-points-report-in-odoo-pos\/","title":{"rendered":"How to Filter, Search and Group the Loyalty Points Report in Odoo POS"},"content":{"rendered":"\n

Loyalty Points<\/strong> tracks loyalty balances to monitor customer engagement, boosts retention by identifying and rewarding loyal customers, enables marketing based on point usage and activity, flags expiring points to encourage timely redemption, and supports decisions with insights into program performance.<\/p>\n\n\n\n

Go to the Main Menu \u2192 Point of Sale<\/strong> Click on Reporting<\/strong> \u2192 Advanced Reports Select Loyalty Point Report. By default, the Loyalty filter is applied to the report. It shows only records related to customers enrolled in the loyalty program.<\/p>\n\n\n\n

Search in <\/strong>Loyalty Point<\/strong> Report<\/strong><\/h2>\n\n\n\n

The search bar lets users find records quickly in the report. Users can search by different fields such as:<\/p>\n\n\n\n

    \n
  • Partner: The name of the customer.<\/li>\n\n\n\n
  • Program: The name of the loyalty program the points belong to.<\/li>\n<\/ul>\n\n\n\n

    Search suggestions help select the right field to search in. This makes finding loyalty records faster and easier.<\/p>\n\n\n\n

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

    Custom Filters in <\/strong>Loyalty Point<\/strong> Report<\/strong><\/h2>\n\n\n\n

    To add a custom filter, click the \u25bc (dropdown)<\/strong> icon in the search bar and select Add Custom Filter<\/strong>. A Custom Filter<\/strong> popup will appear, allowing you to view the available filters. Choose the filter you want, such as Partner<\/strong> or Points<\/strong>, then select the appropriate operation, for example, is in<\/strong>, =<\/strong>, !=<\/strong>, or contains<\/strong>. Enter or select the value based on the chosen filter, and finally, click Add<\/strong> to apply the custom filter.<\/p>\n\n\n\n

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

    Custom Grouping in <\/strong>Loyalty Point<\/strong> Report<\/strong><\/h2>\n\n\n\n

    To create a custom group, click the \u25bc (dropdown)<\/strong> icon in the search bar and select Add Custom Group<\/strong>. A list of group-by fields, such as Created On<\/strong> and Expiration Date<\/strong>, will appear. Choose a field to group your report accordingly.<\/p>\n\n\n\n

    \"Odoo<\/figure>\n","protected":false},"excerpt":{"rendered":"

    Loyalty Points tracks loyalty balances to monitor customer engagement, boosts retention by identifying and rewarding loyal customers, enables marketing based […]<\/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":[731,730,602,495,729],"class_list":["post-34792","post","type-post","status-publish","format-standard","hentry","category-reports","tag-filter","tag-group-by","tag-loyalty-points-report","tag-pos","tag-search"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34792","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=34792"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34792\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}