v7.21 — November 2025
Released: November 2025Pay with Rewards
Redemption APIs
Four new APIs for managing Pay with Rewards redemptions: Create Redemption- Member must have sufficient, positive points — requests with zero or negative balances are rejected
- Eligible member statuses: Active only — Inactive, Suspended, Cancelled, and Membership Blocked members are rejected
- Member cannot have an existing active redemption request
- Points cannot exceed 11 digits
ValidityPeriodInDays: defaults to 3 days if 0 or not passed; otherwise uses the specified value (maximum 90 days)
- Only requests with Pending status can be cancelled
- Processed requests cannot be cancelled
- View requests across all statuses or filter by a specific status
- Passing
status=0returns all statuses
- Fetch a specific request by ID to view the current status and details
Cashback Issuance APIs
Three new APIs for cashback management: Create Cashback- Mandatory inputs: ProgramId, RelationReference, Points, RewardType
- Member must have sufficient point balance
- The cashback request is written immediately with Pending status and processed end-of-day via an automated cron job, which changes the status to Processed
- Points must be integers; decimal values are not accepted
- An optional Description field can be stored but is not included in the JSON output file
- Filter by Status (passing
0returns all), RecordsPerPage (defaults to 10), and PageNumber - Cashback entries do not support cancellation or expiration
- Fetch a specific cashback record by CashbackId
File Generation for Pay with Rewards / Direct Cashback
- File name format:
YYYYMMDDHHMMSSCashBackFileGeneration.json - Accrual transactions after a redemption request are considered for matching (sorted by date/time); transactions before the request are ignored
- Decimal point values are treated as spoilage
"Debit by redemption"filter in transaction reports fetches both Pay with Rewards and Cashback records- Transaction code is
MP-MPAYM-G02for all cashback transactions
Data Processing
DateTime Format Support
- APIs and file uploads now accept datetime values in
YYYY-MM-DD HH:MM:SSformat - If only a date is passed (
YYYY-MM-DD), it is stored asYYYY-MM-DD 00:00:00.000 - Date-only pickers remain in the UI; a time picker is not implemented
Regex Pattern Matching in Pre-Processing
- Trims whitespace from customer transaction and CPD files
- Converts date formats (ddmmyyyy / mmddyyyy) to the standard
yyyy-mm-ddformat (time cannot be changed via pre-processing) - Handles other transformations such as preferred language code conversions
Handback File Enhancements
- Success logs are now included in handback files for both TXN and CPD file types
- TXN files: error code is hidden; only the detailed error message is shown
- CPD files: both error code and error message are visible
Reports
Six New Custom Reports
Redemption Report- Available under Reports → Custom Reports with flexible date range selection
- Requires a
bin_numberattribute in member attributes - Exposes
cash_equivalent_pointsfrom redemption transaction data as Purchase Points Used - Earned Points Used is automatically computed as Total Points Redeemed minus Purchase Points Used
- Monthly report generated on the 1st of each month (previous month’s data)
- Captures Checker ID (approver or rejector) and Description (merchant name)
- Status shows Pending if the request is still with a checker or approver
- Decision Time is blank for pending requests
- Supports manual generation via custom start/end date
- Monthly report generated on the 1st of each month (previous month’s data)
- Requires a
bin_numbermember attribute (string, non-mandatory/non-unique); appears as null if empty - Fixed columns: Member ID, Bank Identifier, Activity, Date, Time, IP Address, Device/Browser
- Pulls data from three sources: BNS file transactions, manual bonus additions, and miscellaneous point debits
- Columns: Member ID, BIN, Creation Date, Bonus Points, Bonus Type, Narration, Description
- Supports custom Start/End Date parameters and monthly scheduling
- Monthly report showing point movements from the 1st to the last day of the month
- Columns: Member Relation Reference, Date Range, Opening Balance, Accrued Miles, Redeemed Miles, Expired Miles
- Includes adjustment columns for Bulk Upload and Manual Add/Remove modifications
- Closing Balance reflects the last day of the month
- Per-member summary columns: Member ID, BIN, Last Update, Status
- Point breakdowns: Purchase Points (Type 4), Bonus Points, Earned Points (excluding Type 4), Redeemed Points
- Totals: Total Points Available, Total Purchase Points Available, Total Earned Points Available
Custom Date Range Generation
- A new Generate button in the Custom Report module allows data generation between two specified dates
- Admin users create reports; users with “Create Report” permission can share, delete, and generate; users with “View Report” permission can only view, generate, and download
Manual Points
Narration Prefix for Manual Adjustments
- All transactions created via Add/Remove Points now include the prefix “Manual Adjustment” in the narration (e.g., “Manual Adjustment – Bonus Points”)
- Existing narration values are preserved but prefixed
- The updated narration is visible in Transaction Summary, Exports, and Reports
- Users can filter by “Manual Adjustment” to isolate manual entries
Maker-Checker Comments
- When maker-checker is enabled, the maker can add comments during an Add/Remove Points request
- Comments appear in the maker-checker request description (not in the approval section)
- Audit trail captures verifier and approver comments, not maker comments
Member Activity
New Activity Codes
The following activity codes are now available in the LBMS database:| Activity | Code |
|---|---|
| Pay with Rewards | 168 |
| Points Transfer | 169 |
| Cashback | 170 |
| Sport Booking | 171 |
| Sport Search | 172 |
| Sport Details | 173 |
- Activities are passed via the
InsertMemberActivityWithSessionIDandInsertMemberActivityAPIs - Activities are exportable via the Member Activity export feature