FAQ-8 to 17 ( Export And Import of Data):
 

8. As SDF Format is not available during export is it possible to enable exporting the data in SDF format?

Answer

Yes, it is possible to export the data in SDF format. You will have to download an extension or a customized program from www.tallysolutions.com and paste the file in C:\Tally.ERP9 folder.

§         Go to Gateway of Tally or Company Info menu press F12: Configuration > F4: Local TDLs.

§         In the TDL Configuration screen, enable Local TDLs on Startup and provide the path or the folder where the TDL file is stored.

§         Start Tally.ERP 9, in the export configuration screens and you will have the option SDF format along with other available formats.

----------------------------------------------------------------------------------------------------Query

9. Can I Export and Import the required transactions only in Tally.ERP 9?

Answer

Yes, it is possible to export and import the required transactions only. Before exporting the data ensure that the Financial period and Book beginning from dates are the same in both the companies

  • Go to Gateway of Tally > Display > Daybook > press Alt+F2
  • Mention the required period
  • Set Select vouchers to show to All Vouchers 

The exported transactions for the specified period are stored in DayBook.xml.

----------------------------------------------------------------------------------------------------Query

10. I have data in two companies namely Company A and Company B in Tally.ERP 9. Company A is having data from January to March and Company B is having data from April to December. Can I merge the data into a single company?

Answer

Yes, it's possible to merge the data of company A and company B by following the steps shown below. As a precaution it is suggested to take a back up of both the companies.

  • Create a new company having the F11: Features of both Company A and B
  • The Financial Year from date must also be the same as Company A and B
  • Select company A, export the Masters and Daybook for the required period
  • Import the masters and the day book in the new company.
  • Similarly repeat the above steps for company  

The new company will have data for company A and B.

----------------------------------------------------------------------------------------------------Query

 

11. Can I export data from Tally.ERP 9 in Excel Format?

Answer

Yes, it is possible to export data in Excel format. From any Tally.ERP 9 report click E: Export or press Alt+E. In the Export Report screen:

  • In the Language field, select Default (All Languages).
  • In Format field, select Excel (Spreadsheet)
  • By default, the application folder's location will be used as the Export Location.
  • Fill in the Output File Name. A shortened version of the report's name in Tally.ERP 9 is filled in by default.
  • Fill in the Output Sheet Name. By default, the report's name in Tally.ERP 9 is filled in.
  • Configure the other options as per requirement.

 

Tally.Erp 9 : Export And Import of Data

  [8-5]

  • Press Enter or Y to export the report in Excel format. The exported file is saved in the Tally.ERP9 application folder.

---------------------------------------------------------------------------------------------------- 

Query

 

12. Can I export the data into Excel and save the file on Desktop or any other folder?

Answer

 

Yes, it is possible to store the file on the desktop or any other location by specifying the required path or folder in Export Location field.

---------------------------------------------------------------------------------------------------- 

Query

13. Is there a provision to export the ledgers along with their respective closing balances and Import them into a new company as opening balances?

Answer

 

It is possible to export masters to a new company, however the opening balances need to be manually entered in the new company.

----------------------------------------------------------------------------------------------------Query

 

14. I want to import a set of vouchers belonging to the same company. How can I achieve this without overwriting them?

Answer 

 

It is possible to duplicate the same set of vouchers within the same company.  To duplicate vouchers while importing the data you need to disable the option Overwrite Vouchers during import (where voucher Remote GUID matches) which is provided in F12: Configure > General configuration.

 

Note:

  • On enabling the option Overwrite Vouchers during import (where voucher Remote GUID matches), Tally.ERP 9 will overwrite the existing vouchers.
  • By default Overwrite Vouchers during import (where voucher Remote GUID matches) is disabled.

Query

 

15. We wanted to import an XML file into Tally.ERP 9. While importing the data we encountered an error which halted the import process. Is there an option to ignore the errors and continue importing the data?

Answer

 

Yes, it is possible to ignore the errors while importing the XML data into Tally.ERP 9. To ignore possible errors while importing XML data into Tally.ERP 9 enable the option Ignore errors during XML import (Applicable for importing vouchers in XML format/SOAP Request) which is provided in F12: Configure > General configuration.  

 

For Example: An XML file has 50 transactions that are to be imported into Tally.ERP 9. The import process is commenced, after importing 19th voucher the import process came to an abrupt halt and displayed the appropriate error message.

 

You can enable the option Ignore errors during XML import (Applicable for importing vouchers in XML format/SOAP Request) provided in F12: Configure > General Configuration and restart the import process. The entire XML data will be imported to Tally.ERP 9 without any breaks or errors by ignoring erroneous vouchers.


Query

 

16. Can I record the error messages that appear while importing or synchronizing data. How can I do this and where is the file stored?

Answer 

 

Yes, it is possible to record error messages that appear while importing/synchronizing data. The detailed messages are stored in a file Tally.imp which reside in the application folder.

To record detailed messages in Tally.imp file the user has to enable the option Enable Detailed Log (tally. imp) which is provided in F12: Configure > Advanced configuration.


Query

 

17. Tally.ERP 9 displays a message Failed to write to tally.imp file or Failed to open tally.imp file while synchronizing or importing data. Why?

Answer

 

Tally.ERP 9 displays this message when it was unable to open or write to Tally.imp due to any one of the following reasons:

  • Tally.imp file is write protected
  • The file is used by another application
  • Another instance of Tally.ERP 9 is using this file

Make the changes shown below to resolve this issue:

 

  • Full permissions have to be given to Tally.imp file by following the steps shown:
    • In the application folder right click tally.imp file
    • Select Properties
    • In the tally.imp Properties window, click Security tab
    • Click Edit to change the permissions
    • In Permissions for tally.imp window, select the required user from Groups or UserNames
    • In Permissions for Authenticated Users check Allow against Full Control
    • Click Apply
    • Click OK
  • Close another instance of Tally.ERP 9 which is running on your system
 
Company Information @ Tally.ERP9
 
 
 
Group & Ledger
Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES
Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
 
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 
 
 
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

Tally,Tally GST,TallyERP9 GST, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.

SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...