Records in this category
- How to add everyone for a folder security?
- Why I need to type the full number instead of just 1 in case the card number is 000001?
- How to utilize the GS1 (UPC / EAN) barcode at the time of receiving the goods?
- How to search a customer by a phone number?
- How to Modify Financial Year Range?
- How to know the database name from the software?
- I am unable to do the modification at branch location. How FusionRetail 6 works in multi location environment?
- How to find out the error if data is not transferred to Tally Offline or Online?
- What is the process of calculation of tax in sale and purchase (before discount or after discount?)
- What will happens to my old data base of customer, their points and credit note?
- Print, Ml, MLIM exes are showing Stop in System Diagnostic.
- Is there any easy method to search option fields?
- Sending Data backup through Email
- How to solve the issue mentioned below?
- Migration process to be followed in Multi-location
- /faq/content/1/551/en/.html
- How can I rename the Matrix Fields in RanceLab® FusionRetail™ 6?
- How can I print the Closing Balance of a ledger from Thermal POS printers?
- How can I print the Credit Information of a customer from RanceLab® FusionRetail™ 6?
- How can I print the Station name from my thermal Receipt printer?
- How can we maintain a link of the Sale Challan Vouchers that are adjusted with the Sale Invoices?
- /faq/content/1/594/en/.html
- How to print multiple order bills in Quick Mode?
- How to configure the FTP details in RanceLab® FusionRetail™ 6?
- Setting up Separate Counters for Order, Cash and Delivery in Sweet Shop.
- The FusionRetail™ 6 installer is little bit heavy in size.
- The architecture of Cash Drawer Balancing:
- How to import offline Location Data in Fusionretail 6?
- How to create a credit invoice against a customer?
- Is it possible to get the format files and the report layouts along with the Branch data?
Tags
Sticky FAQs
General Questions
Is it possible to Import prepaid card balance from an excel file to FusionRetail 6?
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:
Tags: Importing Master
Related entries: -
Last update: 2011-05-17 09:34
Author: Admin2
Revision: 1.1
You cannot comment on this entry