Available Loyalty Points Showing 0 Quantity

Available Loyalty Points Showing 0 Quantity

Environment: 

iVend 6.6 7989 patch

Problem Statement: 

The available loyalty points are showing 0 quantity for some customers.

Symptoms:

--Customer having some available points e.g 200 points
--user performs manual adjustment of 300 points thus gets the value in negatives 
--The awarded points are showing as positive, but the expired points are showing greater than the awarded points.
--The available points column will not show the correct value until the negative awarded points are balanced.

Resolution:

Manually adjust the points or redeem the points to balance the negative awarded points.
Shorten the points expiry days to prevent the points from expiring before they can be used.
SQL Query to Fetch List of Customers with Negative Points:

select AvailablePoints, LoyaltyId, * from LoyLoyaltyCardInformation
inner join LoyPointsSummary ON LoyLoyaltyCardInformation.LoyaltyCardInformationKey = LoyPointsSummary.CustomerKey
where LoyPointsSummary.AvailablePoints < 0
order by LoyPointsSummary.AvailablePoints
 
Recommendations:NA 

    • Related Articles

    • Loyalty - Award and Redeem Points

      Loyalty – Award and Redeem Loyalty Points at the POS iVend Retail includes a fully featured Customer Loyalty program. iVend Loyalty is a points and rewards application designed to enhance the opportunities to win and retain new customers and greatly ...

    • Loyalty Redeemable Points in POS

      Environment : iVend 6.6 Patch 7454. Problem Description : Loyalty Redeemable Points in POS. Scenario : Client is using the default configured Loyalty in demo-stack. We used a customer registered as a loyalty to perform transactions in POS to get the ...

    • Cannot refund loyalty points.

      Query: If a customer paid the amount of a sale transaction (partially or completely ) using loyalty points and then refunded the sale , the loyalty points did not Roll back using the Loyalty Tender type. Response /Workaround: Loyalty Tender type can ...

    • Cannot refund loyalty points.

      Query: If a customer paid the amount of a sale transaction (partially or completely ) using loyalty points and then refunded the sale , the loyalty points did not Roll back using the Loyalty Tender type. Response /Workaround: Loyalty Tender type can ...

    • Available Redeemable Currency is not matching with the Available points for the customer

      Product Version: 6.6 Incident Reference: INC0011696 Problem Statement: Even though customer has more points available to redeem, but Available currency to redeem is showing lesser value. Details: As per below screenshot, customer has total 280 points ...