Updating problem in Importing Loyalty Customer Excel.

Updating problem in Importing Loyalty Customer Excel.

Environment:  

6.6

Short Description:  

Updating problem in Importing Loyalty Customer Excel.

Product Query:  

The data for BirthDate and LoyaltyCustomerCountries is not updated in iVend during the import procedure

Resolution/Work Around: 

For BirthDate, we special paste the Date as value option and change format of BirthDate column to Date from General.
For Country, we use the country's code except the description of country.

Recommendations /Suggestion:

N/A.
For Better Clarification Follow attached screenshots

Paste BirthDate as a Paste values in Special Paste

Change BirthDate Cell From General to Date

Use this Country Code in Loyalty import Excel


Note : CS0008315

    • Related Articles

    • Multiple SMS for single Loyalty Transactions

      Environment : iVend Version 6.6 with SAPB1 9.2 Problem Statement: Multiple SMS for single Loyalty Transactions Symptoms : Multiple SMS for single Loyalty Transactions Resolution/Work Around : Due to SMS gateway ,not returning the success message, the ...

    • Customer Not Showing at POS when importing through excel sheet

      Product version: 6.5 Update 6 Problem Statement: Customer Not Showing at POS when importing through excel sheet Proposed Solution/Workaround: There is a possibility that the customer record was imported with wrong values in iVend. So one can first ...

    • Remove Customer Master which has transaction and also remove those customer which has no transaction

      Environment:   Ivend 6.6 Problem statement: Need to Remove Customer Master which has transaction and also need to remove those customers which has no transaction details. Resolution/Work Around: 1. Remove customer master which has no transaction ...

    • Problem in assgning a loyalty program to a customer

      iVend Version: 6.5 update 5 with SAP B1 Version 9.2 Problem statement: Issue while assigning a loyalty program to a customer. User created a new loyalty plan for a customer but it was not showing in the customer screen Proposed Solution: In the ...

    • Error while creating a new product group with Business Central

      Environment: iVend 6.6 Patch 7989 Problem Statement: Loyalty plans were created correctly but adding the products involved in the discount does NOT allow us to create a new group of products. Scenario: Client created loyalty plans in iVend system but ...