> 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-learning-hub-tutorials-and-best-practices/setups/setup-accounts/setup-customer-database/retail-customer-membership-package-scheme-status.md).

# Retail Customer Membership / Package Scheme Status

**YouTube:** [How to Configure the Retail Customer Membership Package Scheme Status Report?](https://youtu.be/aN9gN_B0fN4)

## How to Configure the Retail Customer Membership Package Scheme Status Report?

In this tutorial, we will learn how to configure and generate the **Retail Customer Membership Package Scheme Status Report** in Logic ERP.

This report helps you check the status of customer memberships and package schemes, including expired, expiring, active, not-started and not-set memberships. It lists what each retail customer is enrolled on, what it covers, the discount it gives and when it expires, so that your team can contact customers for renewal before their membership lapses.

***

### Access to the Report

* Navigate to the **Main Menu**.
* Open the **Setup** module.
* Select **Setup Accounts**.
* Expand the **Setup Customer Database** module.
* Scroll down and open **Retail Customer Membership / Package Scheme Status**.

***

### Select the Date Range and Filters

* Enter the **From** and **To** dates. The dates do not select bills; they are used in two ways:
  * When **As On Date** is set to **Report To Date**, the statuses and **Days To Expiry** are worked out as on the **To** date.
  * When **Expiry Within Report Range** is ticked, only memberships whose **expiry date** falls between the two dates are shown — the quickest way to see what expires next month. Memberships without an expiry date are left out.
* Optionally, narrow the report with these filters:
  * **Branch** – the branch on the customer's record (normally where the customer was registered). Your user branch access also limits the report by this branch.
  * **Customer Database** – selected customers.
  * **Retail Customer Segments** – customers of selected segments.
  * **City** – customers of selected cities.
  * **Company** – memberships that apply to selected companies (brands). Memberships set on a category or a single product are left out when this filter is used.

***

### Configure Report Options

* Click **Config** (or press **F5**) to open the configuration window, and go to the **Report Options** section. Every setting is explained in [Retail Customer Membership / Package Scheme Status - Configuration](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/setup-accounts/setup-customer-database/retail-customer-membership-package-scheme-status/retail-customer-membership-package-scheme-status-configuration.md).
* In **Expiring Within Days**, define the number of days within which a membership or package should be considered as expiring. New configurations start at **30** days. This field can be changed only while the **Expiring** status is ticked. If **Expiring** is unticked, memberships ending within these days are hidden; they do not show as Active.
* Use **As On Date** to choose whether the statuses are measured from **Today** or from the report's **To** date.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fse6psytrIwYKyLZVkUS2%2FCNF.png?alt=media&#x26;token=3215570b-a2d7-4c03-b27f-9586dd85174f" alt=""><figcaption></figcaption></figure>

* For example, if you enter **10 days**, the report shows as **Expiring** the memberships or packages that end on the as-on date or within the next 10 days (both days included).

***

### Select Membership Statuses

* Under the **Status** section, select the statuses you want to include in the report.
* Choose the required statuses according to your reporting needs.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FHZCI3pxpl6mDRF5yZS6a%2FStatus.png?alt=media&#x26;token=74f28326-1725-4a20-963d-623c539c07f6" alt=""><figcaption></figcaption></figure>

* A new configuration starts with all five statuses ticked.
* Once all the settings are configured, **save and close** the configuration window. At least one status must be ticked, or the configuration is not saved.

***

### Generate the Report

* Generate the report after saving the configuration.
* Review the membership or package scheme status displayed for each customer.
* The report can display the following statuses:
  * **Expired:** The end date is before the as-on date.
  * **Expiring:** The end date falls on the as-on date or within the configured number of days after it.
  * **Active:** The membership or package has started and does not end within the expiring days. (A running membership that ends within the expiring days shows as **Expiring**, not Active.)
  * **Not Started:** The start date is after the as-on date.
  * **Not Set:** The start or end date of the membership or package was never entered.

> **Example — As On Date: Today = 25 September 2026, Expiring Within Days = 30**
>
> * **Asha**'s membership runs from 1 March to 31 March 2026 → **EXPIRED** (Days To Expiry −178).
> * **Rohit**'s membership ends on 30 September 2026 → **EXPIRING** (5 days left, within 30).
> * **Meena**'s membership runs from 25 September to 10 December 2026 → **ACTIVE** (76 days left, more than 30).
> * **Kabir**'s membership starts on 1 October 2026 → **NOT STARTED**.
> * **Sonia**'s membership was saved without dates → **NOT SET** (Days To Expiry is blank).

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FRyJOIgQbqRqkbdiPk7bk%2FReport.png?alt=media&#x26;token=233b8e49-bf68-4672-9eea-a783879d1a07" alt=""><figcaption></figcaption></figure>

***

### Understand the Report Columns

| Column                            | Shows                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| --------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Membership Number**             | The customer's membership series and number.                                                                                                                                                                                                                                                                                                                                                                                                              |
| **Customer Name**, **Mobile No.** | The customer's name and mobile number.                                                                                                                                                                                                                                                                                                                                                                                                                    |
| **Branch Name**                   | The branch on the customer's record (normally where the customer was registered).                                                                                                                                                                                                                                                                                                                                                                         |
| **Package Name**, **Pack Name**   | The package (membership) item and its pack.                                                                                                                                                                                                                                                                                                                                                                                                               |
| **Scheme Source**                 | **PACKAGE (BILL)** – the membership was given by selling the package on a bill, so the package name is certain. **PACKAGE (INFERRED)** – no bill is linked, but what the membership covers matches a package setup; the package name is filled in only when exactly one package matches, otherwise it is blank. **MANUAL** – a discount entered by hand for the customer, not part of a package (shown only when **Include Manual Discounts** is ticked). |
| **Scheme Type**                   | What the membership covers: **COMPANY**, **CATEGORY**, **COMPANY + CATEGORY** or **PRODUCT**.                                                                                                                                                                                                                                                                                                                                                             |
| **Applicable On**                 | The company, category or product it covers.                                                                                                                                                                                                                                                                                                                                                                                                               |
| **Start Date**, **Expiry Date**   | The validity of the membership. Blank when the dates were never entered.                                                                                                                                                                                                                                                                                                                                                                                  |
| **CD Percent**, **TD Percent**    | The CD % and TD % discounts the membership gives, as entered in its setup.                                                                                                                                                                                                                                                                                                                                                                                |
| **Days To Expiry**                | Days from the as-on date to the expiry date. Negative once expired; blank when there is no expiry date.                                                                                                                                                                                                                                                                                                                                                   |
| **Status**                        | ACTIVE, EXPIRING, EXPIRED, NOT STARTED or NOT SET.                                                                                                                                                                                                                                                                                                                                                                                                        |
| **Bill No.**, **Bill Date**       | The bill on which the package was sold (blank when no bill is linked).                                                                                                                                                                                                                                                                                                                                                                                    |
| **Schemes**                       | 1 on each row; the subtotal and grand total rows show the number of memberships.                                                                                                                                                                                                                                                                                                                                                                          |

***

### Verify Customer-Wise Details

* Check the membership or package details displayed for each customer.
* If multiple customers have the same name, the report displays them as **separate customer records**.
* Their details and membership statuses are shown individually instead of being merged into a single record (for example the two **SHEETAL** rows in the screenshot below, with membership numbers MM28 and MM29).
* When subtotals are printed by **Customer Name** (see the configuration page), each of them also gets a subtotal of its own, as in the screenshot.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FqsFJtVSb1OY54EPs8K0a%2FCustomer%20Status.png?alt=media&#x26;token=0f348b4b-a5a8-4e8c-a81d-3dbb500e59be" alt=""><figcaption></figcaption></figure>

***

### Objective of This Report

* Monitor customer membership and package scheme statuses.
* Identify memberships and packages that are approaching their expiry date.
* Track expired, active, expiring, not-started and not-set memberships.
* View separate records for customers who share the same name.
* Plan renewal calls from the list of expiring memberships.


---

# 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-learning-hub-tutorials-and-best-practices/setups/setup-accounts/setup-customer-database/retail-customer-membership-package-scheme-status.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.
