# 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: 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:
```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-retail-customer-points-ledger-report.md?ask=
```
The question should be specific, self-contained, and written in natural language.
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.