> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-retail-customer-points-ledger-report.md).
# Generate Retail Customer Points Ledger Report
**YouTube:** [How to Generate Retail Customer Points Ledger Report?](https://youtu.be/2x2Cjke2CGs)
## How to Generate Retail Customer Points Ledger Report?
In this tutorial, we’ll learn how to configure the **Customer Loyalty Points Ledger Report**, which helps track loyalty points earned, redeemed, and the balance available for each customer.
***
### **Open and Create a New Configuration**
* From the **Main Menu**, navigate to the **Setup Module**.
* Click on **Setup Accounts**.
* Open the **Setup Customer Database**.
* Under this section, locate and open **Customer Point Ledger Report**.
* Click on **Configuration** to create a new report setup.
* Assign a **suitable configuration name** for easy identification.
***
### **Define Report Consolidation and Order**
* Under **Report Consolidation**, enable the following options:
* **Customer Wise**
* **Voucher Date**
* In the **Report Order** section, ensure **Customer Wise** is placed at the top.
* If not, use the **Arrow Keys** to adjust the order.
* Set **Period Consolidation** to **Date Wise**.
* Define **Report Order** as **Customer + Period**.
***
### **Save and Generate the Loyalty Points Report**
* Once all settings are defined, click **Save Configuration** to store the setup.
* From the list of available configurations, select the one you just created.
* Click **Create Report** to generate the output.
***
### **Customize Report Columns**
* Open **Setup Column Attributes**.
* Click **Unselect All Columns** to start fresh.
* Select only the columns you wish to include in the final report (e.g., Customer Name, Earned Points, Redeemed Points, Balance Points).
***
### **Review the Final Output**
The generated report displays **Total Points Earned**, **Points Redeemed**, and **Balance Loyalty Points** for each retail customer, providing a clear summary of customer reward activities.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-retail-customer-points-ledger-report.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.