Now you can import prepaid card balance in FusionRetail6 from excel file. Please use the following steps…
Step1: Creating an excel file for product recipe
- Create an excel file with the following columns
|
Card Number |
Enter prepaid card (Already issued) numbers in this field |
|
Mode Of Payment |
Enter the specific Mode of payment for that particular prepaid card. (Must be created in FusionRetail6 prior to import the excel file) |
|
Card Deposit Value |
Enter card deposit value here |
|
Card Validity (In Days) |
Enter validity of the card in days |
|
Amount |
Enter the card amount |
|
Location |
Enter the location (branch) name here, for which you want to make that card active. (Must be created in FusionRetail6 prior to import the excel file) |
Step2: Import the excel file in FusionRetail6
- Go to Main Menu > Settings > Import & Export > Import Data(T>I>I)
- Alt + L
- Select “Prepaid card balance” from the list
- Set other option
- Select the excel file in “File Name” field
- Map the headings of the excel file with FusionRetail6 fields
- Alt + I (or you may use “– I Import” button)
- It will import the recipe excel file in the database
Step3: Checking the change in FusionRetail6
- Go to Main Menu > Sale Management > Transaction > Prepaid (S> T> P)
- Press Alt + H (or you may also use ‘–H History’ button)
- It will generate a report as below…
For more details please visit: