> 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.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FWq5UP68KMzZvuc7Zucqn%2FConfiguration%20-%20Name.png?alt=media&#x26;token=512df78b-dbea-4e85-95cf-37e6c04716fd" alt=""><figcaption></figcaption></figure>

***

### **Define Report Consolidation and Order**

* Under **Report Consolidation**, enable the following options:
  * **Customer Wise**
  * **Voucher Date**
  * (The list also has **Voucher Number**; leave it unticked for this layout.)
* 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 As** to **Date Wise**.
* Define **Report Order** as **Customer + Period**.
* Keep **Do Not Show Opening Balance** unticked, so that the balance includes the points earned and redeemed before the start date of the report.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FwTqK00SqOMXyqAw9ZWSH%2FReport%20Options.png?alt=media&#x26;token=c8694d4c-38e0-4569-9046-3e4adcd5dcb2" alt=""><figcaption></figcaption></figure>

***

### **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.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FABXpn2O0JfPNozXIn7M5%2FReport%20Options.png?alt=media&#x26;token=fa277dc6-d6e5-463f-bc06-2f247144951c" alt=""><figcaption></figcaption></figure>

* Click **Create Report** to generate the output.

***

### **Customize Report Columns**

* Open **Set Column Attributes**.
* Untick **Select / Un-Select All** to clear all columns and start fresh.
* Select only the columns you wish to include in the final report (e.g., **CUSTOMER NAME(COMBINED)**, **POINTS EARNED**, **POINTS REDEEMED**, **BALANCE POINTS**). Other columns such as **REDEEMED VALUE**, **BONUS POINTS**, **OPENING BALANCE** and **MOBILE NUMBER** can also be added.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FTAQGSaAZnQwlewMVKzyq%2FSet%20Column%20Attribute.png?alt=media&#x26;token=9528a1a9-dec9-4c80-bca1-53806717f237" alt=""><figcaption></figcaption></figure>

***

### **Review the Final Output**

The generated report displays **POINTS EARNED**, **POINTS REDEEMED** and **BALANCE POINTS** for each retail customer. With these settings, each customer gets an opening line followed by one line for every date on which points were earned or redeemed. **BALANCE POINTS** is a running balance, so the customer's current balance is the figure on that customer's last line.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FuliXikiij9qxrKlEdvDr%2FFinal%20Output.png?alt=media&#x26;token=b6e648d7-8d69-4d75-8035-8e1355278f1c" alt=""><figcaption></figcaption></figure>


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-retail-customer-points-ledger-report.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
