{"id":13520,"date":"2025-02-28T04:52:55","date_gmt":"2025-02-28T04:52:55","guid":{"rendered":"https:\/\/jaldi.store\/?p=12478"},"modified":"2026-09-02T11:50:01","modified_gmt":"2026-09-02T11:50:01","slug":"how-to-view-loyalty-transaction-details-by-customer-report-in-adempiere-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-view-loyalty-transaction-details-by-customer-report-in-adempiere-retail\/","title":{"rendered":"How to view Loyalty Transaction Details by Customer Report in Adempiere Retail"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The <strong>Loyalty Transaction Details by Customer Report<\/strong> is a detailed list of <strong>all loyalty point activities<\/strong> (earned, redeemed, expired, adjusted) for each customer, showing <strong>how and when<\/strong> their points were used.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>User Access<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Who Can Access<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Admin<\/li>\n\n\n\n<li>Back Office<\/li>\n\n\n\n<li>Purchase Manager<\/li>\n\n\n\n<li>Manager<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">What User Can Do<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Track Individual Customer Point<\/li>\n\n\n\n<li>Verify Loyalty Program Accuracy<\/li>\n\n\n\n<li>Analyze Redemption Patterns<\/li>\n\n\n\n<li>Export or Print Reports<\/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>Enable Loyalty Program in System<\/li>\n\n\n\n<li>Track All Loyalty Transactions<\/li>\n\n\n\n<li>Date Range for Reporting<\/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>Unique Customer Identification<\/li>\n\n\n\n<li>Point Calculation<\/li>\n\n\n\n<li>No Negative Balance<\/li>\n\n\n\n<li>Point Expiry<\/li>\n\n\n\n<li>Balance Update<\/li>\n\n\n\n<li>Reporting Date Filter<\/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> To select a Loyalty transaction details by customer.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report.png\" alt=\"Tenthplanet-ADempiere-Loyalty Transaction Details by Customer Report\" class=\"wp-image-26124\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-300x131.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-768x335.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 2:<\/strong> To enter a date in this field is mandatory. Then to enter a Customer and to click the start check box to run the process.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"383\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-1.png\" alt=\"Tenthplanet-ADempiere-Loyalty Transaction Details by Customer Report-1\" class=\"wp-image-26133\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-1.png 850w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-1-300x135.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-1-768x346.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 3:<\/strong> Once to complete the process then to show the report based on the given data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"623\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-2.png\" alt=\"Tenthplanet-ADempiere-Loyalty Transaction Details by Customer Report-2\" class=\"wp-image-26136\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-2.png 773w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-2-300x242.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-2-768x619.png 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"531\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-3.png\" alt=\"Tenthplanet-ADempiere-Loyalty Transaction Details by Customer Report-3\" class=\"wp-image-26137\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-3.png 642w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2025\/02\/TenthPlanet-ADempiere-Loyalty-Transaction-Details-by-Customer-Report-3-300x248.png 300w\" sizes=\"auto, (max-width: 642px) 100vw, 642px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>STEP 4:<\/strong>  <strong>Date invoiced <\/strong>&#8211; refers to the specific date when an invoice is issued or created. It\u2019s the day the seller or service provider formally records the transaction and requests payment from the buyer. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                 <strong>Card number<\/strong>&#8211; typically refers to a unique identifier associated with a customer\u2019s account or transaction card.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">                <strong>Mobile number<\/strong>&#8211; refers to the phone number associated with a customer, typically used for communication, account identification, or customer service purposes. This number is generally provided by the customer when they create an account, make a purchase, or interact with a business.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">               <strong>Reward points<\/strong> &#8211; are a form of loyalty program or incentive offered by businesses to encourage customer retention and repeat purchases. These points are earned by customers as they engage with a brand\u2014usually by making purchases, signing up for services, or engaging in certain promotional activities.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">              <strong>Points redeemed <\/strong>&#8211; typically refers to the process of using accumulated points or rewards to claim products, services, discounts, or other benefits in a loyalty program, rewards system, or promotional offer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Bill number<\/strong> &#8211; is a unique identifier assigned to a specific bill or invoice. It is used to track and reference the details of a transaction, payment, or service rendered. Bill numbers are often used in businesses, utilities, or government services to make it easier to locate, manage, and verify particular bills.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Loyalty Transaction Details by Customer Report is a detailed list of all loyalty point activities (earned, redeemed, expired, adjusted) [&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-13520","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\/13520","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=13520"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13520\/revisions"}],"predecessor-version":[{"id":26141,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/13520\/revisions\/26141"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=13520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=13520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=13520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}