Category: How to ?

How to ?

Merge data in Tally.ERP 9

How to merge data in Tally.ERP 9 ?

Assuming, you have two companies viz Company No 1 and Company No 2 and you wish to transfer all the data of Company No 1 into Company No 2.

Steps :-

  1. Open Company No 1 and Export data from Tally ERP 9 in XML format including dependent masters
    a) Use option “Gateway of Tally >> Display >> Daybook”
    b) Set the period using Alt+F2
    c) Next, press Alt+E to export the Tally.ERP 9 data into XML format including dependent masters.
    d) This will generate a file named “daybook.xml” in the Tally folder.
  2. Open Company No 2 and Import data into Tally.ERP 9 in Company No 2
    a) Use option “Gateway of Tally >> Import of data >> Vouchers”
    b) Specify the file-name as “daybook.xml” and press enter to import data into Tally.ERP 9

Remarks:-
a) Take backup of your Tally Companies before merging for safety purpose.
b) After merge, the Company No 2 contains the data of Company No 1
c) The above has been tested with Tally.ERP 9 Release 3.0 with some test-data.

Merging in Tally.ERP 9 vs Tally 9

Tally.ERP 9 Release 3.0 provides an option to export vouchers along with the dependent masters. Hence, there is no need to separately export the masters as it was required previously.

Related Posts :-
How to copy / paste entries from one company into another by ApniTally

Free Tally tools

Export Tally data to Excel | Free tool

How can I export Tally data into Excel ?

You can use Tally ODBC feature supported by Tally Accounting software to get data from Tally into Excel. Alternatively, you can use this FREE Tally to Excel utility to get Tally data into Excel.

Supported Tally versions : Tally.ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3

Remarks:-
Tally ODBC does not expose all the fields of all tables / objects in Tally. Hence, you will be able to retrieve only the first level fields (limited fields) from Tally database tables / objects.

How to ?

Merge two Stock Items in Tally.ERP 9

How to merge two Stock Items in Tally.ERP ?

Merging two Stock Items in Tally.ERP 9

It is assumed that you have two Stock Items viz “Item 1” and “Item 2” and you need to merge the “Item 2” into “Item 1” such that all the Vouchers having “Item 2” would show “Item 1” after the merge-process.

PS:
a) Take backup of your Tally data for safety purpose before trying out the underneath steps.
b) We have tested Merging of two stock items with Tally.ERP 9 Release 3.0 only

Step-by-step instructions:-

  1. Change Tally.ERP 9 configuration settings
    a) Select option “Gateway of Tally >> F12 >> General”
    b) Set the option “Overwrite Vouchers during Import” to Yes
  2. Set the period in Tally.ERP 9
    Select option “Gateway of Tally >> Alt+F2” and set the period. Example if you have vouchers for three years, set the period accordingly so that the whole data is accessible.
  3. Export Tally.ERP 9 data in XML
    a) Select option “Gateway of Tally >> Display >> Daybook >> Alt+F2” and set the full-period
    b) Next, export Tally.ERP 9 data using “Alt+E” in XML format.
  4. Make changes in XML data
    a) Open the file “Daybook.xml” in Notepad and find/replace all occurrences of the “Item 2” with “Item 1”.
    Remarks: The file daybook.xml is created in step-3 on exporting data  using Alt+E
    b) Save the Daybook.xml file
  5. Import data in Tally.ERP 9
    a) Select option “Gateway of Tally >> Import of Data >> Vouchers”.
    b) Specify the file-name (ex: daybook.xml) and press enter to import it.
  6. Verify the Vouchers in Tally.ERP 9
    Select option “Gateway of Tally >> Display >> Daybook” and check vouchers to verify the merging-process.
How to ?

Changing Ledger Allocation details for Stock-Items in Tally ERP

How can I change the Ledger Allocation details for multiple Stock Items in Tally ERP ?

Brief description of the Query
I am using POS Sales for invoicing. I have created a Voucher class (incl VAT), so that in the Invoice the rates are inclusive of all the taxes. When creating Stock-Items, I use the option “Set/Modify Default Ledgers for Invoicing” to specify the Ledger allocation for Sales Invoice as follows :-

Sales @ 13.5% == 88.1057

Output VAT @ 13.5% ==11.8943

Now as the VAT rates changed from 13.5% to 14%, I will have to manually alter each and every Stock-Item.  Around 6000 SKU’s comprising both items at 5% & 13.5% Vat rates.

Is there any solution to update the Ledger allocations details for multiple stock-items  together in  Tally.ERP ?

Solution
1) Take back up of Tally data (for safety purpose)
2) Use the option “Gateway of  Tally >> Display >> List of Accounts >> Alt+E” to export the STOCKITEM Masters in XML format.

Remarks: This will create a file named Master.xml. in Tally folder

3) Next, open the Master.xml file in Notepad and search/replace 88.1057 (whatever old rate is) with  New Rate. After this save, the Master.xml file

4) Next, import the Master.xml file into Tally using option “Gateway of Tally >> Import of Data >> Masters”
How to ?

VAT Classifications in Tally

How can I create a new VAT Classification in Tally ERP 9 ?

Though VAT classifications can be viewed using “Gateway of Tally >> Display >> Statutory Info >> VAT Classifications”, Tally ERP does not provide any user-interface or menu-option to create VAT Class.

A work-around is to create VAT Class using “Gateway of Tally >> Import of Data >> Masters” option.

Steps :-

1) Download and unzip the XML tags for creating VAT Class
2) Next, select option “Gateway of Tally >> Import of Data >> Masters”
3) Select the file VAT-CLASS.XML (which you have downloaded in step 1) to import it in Tally

Here’s the XML code to create VAT class for “Output VAT @ 14%” for Karnataka State.

<ENVELOPE>
 <HEADER>
 <TALLYREQUEST>Import Data</TALLYREQUEST>
 </HEADER>
 <BODY>
 <IMPORTDATA>
 <REQUESTDESC>
 <REPORTNAME>All Masters</REPORTNAME>
 <STATICVARIABLES>
 <IMPORTDUPS>Modify with New Data</IMPORTDUPS>
 </STATICVARIABLES>
 </REQUESTDESC>
 <REQUESTDATA>
 <TALLYMESSAGE xmlns:UDF="TallyUDF">
 <TAXCLASSIFICATION NAME="Output VAT @ 14%">
 <NAME.LIST TYPE="String">
 <NAME>Output VAT @ 14%</NAME>
 <NAME>Sales @ 14%</NAME>
 </NAME.LIST>
 <TAXTYPE>VAT</TAXTYPE>
 <SUBTAXTYPE />
 <MARKFORDELETION>No</MARKFORDELETION>
 <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
 <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
 <RATEOFVAT>14</RATEOFVAT>
 <!-- Add your State here-->
 <TAXCLASSIFICATIONSTATE.LIST>
 <STATENAME>Karnataka</STATENAME>
 <TAXCLASSIFSTATEPERIOD.LIST>
 <PERIODFROM>20110401</PERIODFROM>
 </TAXCLASSIFSTATEPERIOD.LIST>
 </TAXCLASSIFICATIONSTATE.LIST>
 </TALLYMESSAGE>
 </REQUESTDATA>
 </IMPORTDATA>
 </BODY>
</ENVELOPE>

 

Remarks :-
1) You can use “Gateway of Tally >> Display >> List of Accounts >> Alt + E” to export All Statutory Masters in XML format. This gives you the XML format supported by Tally. Modify it and you can create Statutory Masters as required.


How to ?

Load multiple companies on Tally Start-up

To load one or more companies when you start Tally, you must specify the Company Number in the Tally.ini file

Steps :-

1) Close Tally if it is running.

2) Next, open the Tally.ini file (from Tally folder) in Notepad.

3) Next, set the following :-

Default Companies=Yes
Load=10000
Load=10001