Tally.ERP 9
ODBC- Open Database Connectivity
- Inward connectivity   ( Customization)
- Outward connectivity (Export the data from Tally to Excel)
Go to Gateway of Tally>Press F12>Advanced Configuration>Enable ODBC Server - yes>(client /server technology)> create some ledger.
Installation in Tally.ERP9
Single user/ Multiuser
Server/Client
www.tallysolutions.com > go to downloads>click on TallyERP9 (series A release 3.31)
- Tally.ERP9 series A release3.31(lite installer) : without reference manual
- Tally.ERP9 series A release3.31(full installer) : with reference manual
Go to Next> Select single user/multiuser> licensing
                                                                -single site 
					     -multi site( unique site ID to identify each site)
Activation
Offline Reactivation in Tally.ERP9
Generate Tally_req.lic in the main system > Intall same version of Tally in Internet PC to generate Tally_req.lic file > Response file will be sent to registered E-mail id > Unlock license in case of activation.
Site Licensing in Tally.ERP
While activating Press F2 to give site ID > Site E-mail id acts as a ontrol account for all the list of serial numbers activated under it.
Installation of Tally.ERP9
operating system requirements:-
Single user- MS Windows 98/ME/NT/ 2000/2003/2008/XP/vista/7
Multi user- License server can be installed only on windows NT/ 2000/2003/XP/vista/7
Client in educational mode- not getting license on the client from server 
Steps to be followed on SERVER-
1.	Check the system Date and time , release and version.
2.	Right click on tally icon > go to properties > shortcut > fing target > Open Tally folder > Tally admin file > license server  > check whether uninstall is getting highlighted > also check on the Ping option to check whether license is running or not > check for LAN.
3.	Give firewall and antivirus exceptions for Tally.exe, Tally admin.exe, Tally license server.exe files > Add server name and port number in firewall.
4.	Reinstall Tally in different drive.
To check Release and Version-- Ctrl + Alt + B
Steps to be followed on CLIENT-
1.	Check the system Date and time , release and version.(Ctrl + Alt + B)
2.	Open Tally folder > Configure existing license  > existing multiuser > check whether Server name and Port number has been provided correctly > press enter and restart tally.
3.	Open Tally configure existing settings file > delete two semi colons before "Tally license server = Server :Port" and save the file.
4.	Open Tally admin file> check whether install is getting highlighted and Ping on the client.
5.	Give firewall and antivirus exceptions for Tally.exe, Tally admin.exe, Tally license server.exe files > restart the PC
6.	Reinstall Tally in different drive.
Tally.Net subscription in Tally.ERP9
•	Single user- 3,600 p.a
•	Multiuser- 10,800 p.a
•	Auditor's BAP (Business Advisory Programme)- 4050 p.a
Benefits- To avail the new latest updation of release and stat. files and to avail additional ERP features like SMS, Remote acess & Synchronisation
REMOTE ACCESS ( should have a valid tally.Net)
Enable security control for the company > Login from admin level > Press Alt + F3 > security control > users and passwords > select security list as Tally.Net user > provide email id and enable Allow remote acess option to Yes 
Press Ctrl + K >  user management > Provide email id > enable tally.net user to yes > connect company (F4) > on remote PC > open Tally > login as Remote user > recommended internet speed- 256kbps > Tally.net user in single user =1 & in multiuser = 10 ( Edition in database has been provided from the release 2.0)
In Rempte access we cannot take the data back up / do export import of data.
SMS (short message service) in Tally.ERP9
enable security control for the company > login from the admin level > Press Alt + F3 > security control > user and passwords > enter e-mail id > enable allow SMS > Press F11 on the gateway of Tally > tally.net features > enable SMS access and provide SMS company name (upto 10 digits only) > press Ctrl + K > Press Alt + W > my profile > enter mobile no. and accept it. > on the gateway of tally > press F4 to connect company > now send SMS from the registered mobile number to 566779 along with the suffix number.

Change of SMS suffix---- After connecting the company > login as remote user > enter the remote email id > in the list of online companies > place the cursor on the company and press Alt + C > provide the new sufffix number.
Back up ,Restore and auto back up in Tally.ERP9
Back up ( TBK900.001)
Auto back up (ABK.900 inside company folder)-- to restore it tally command key is Ctrl + Alt + K. In different location TABK.900 file.
Splitting of data
Separation of company data along with masters , their closing balances & vouchers as on that date.
Precautions- 
1.	Take the data back up 
2.	Clear pending purchase and sales order
3.	Adjust Forex gain / loss
4.	Finalize the books of accounts
5.	Reconcile the bank transactions
File that is generated while splitting the data --TAlly.spl/(note pad / word pad), shock wave flash object.
Export & Import of Data in Tally.ERP9
From one company to another company in tally in XML Format (extenisble markup language)
Precautions- 
1.	Take the data back up 
2.	F11 features should be same
3.	Financial period should be same
Error file during export and import is Tally.imp
Data migration in Tally.ERP9 (5.4, 6.3, 7.2 data to Tally9 & ERP9)
- take the data back up
- open the tally folder > Tally 7.2 migration.exe> migrate data > select the company to migrate
(NOTE-- Tally should be in serial number mode and error file generated is Migration.err)
Data conversion(4.5 to 7.2)
conversion utility from Tallyb website > Unzip the conversion File to "C" file > open tally 4.5 to 7.2 folder > tally ini file Provide 4.5 data path > open "WCV Tally> select the company to convert > after conversion migrate the data to TallyERP
(note- In 4.5 , company folder will be in $ symbol)
Synchronisation in tally.ERP9
1. Using Tally.Net - Requires Tally.net subscription.
2. Using IP - Doesnot requires Tally.net subscription.
Steps related to synchronisation-
-On server > Press F12 > Advanced configuration > Tally is acting as server > enter and accept it .
-Enable security control for the server company > Check and connect name in F11 > Tally.Net features
-Press F4 to connect the company on server.
-On client Press F12 > Advavanced configuration > Tally is acting as client and accept it.
-For client company > enable security control > On client > go to gateway of tally> import of data > synchronisation > clienyt rule> create
-On client . go to gateway of tally > Import of data > synchronisation > 
client rule note- You all gert the message Sync start company name: Sync end in control panel.
On server > go to gateway of Tally > Import Of Data > Synchronisation > server rule > activate .

F12 : advanced configuration
1. Enable sync logging (stock req.log)- It generates a log file inside Tally folder which contains the infor. about the synchronised vouchers.
2. Truncate the previous log file before synchronisation- It overwrites  the contents of prevoious log file .
3. Enab;le http log (Tally HTTP log)- HTTP .log file gets generated to login all soap & HTTP  port request  responses 
4. To synchronising the data in between , command is Alt + Q 
Exchge snpshot online - is also called as bulk synchronisation (For companies having huge data)
 Technological changes of Tally.ERP9
Tally vault 
go to gateway of tally > Press Alt +  F3 > Change tally vault > Press enter > enter the password in new password  and repeat password field > press enter 
Important points-
1. we cannot see the enme of the encrypted or tally vaulted company.
2. donot forget your tally vault password because the data once lost cannot be retrieved.
Security control
Activate security control > Alt + F3 > Alter > Enable security control to yes 
Type name of the administrator - xxxxxxxxxxxxx
Password - xxxxxxxxxxx
and allow other options i.e Use tally audit features - Yes 
Shut the company- Select Tally solutions Pvt. Ltd. (donot select tally vaulted company)
imp. point -The password is case sensitive as any variation in case will not allow you to login to tallyERP9
Security level creation
go to gateway of tally > Press Alt + F3 > Press security control -users and passwords and   types of security
Group company
To view the consolidated reports of the number of companies we make a group company. Company selected first for the creation of Group company -> only vouchers of that company can be seen not of all companies.   A Group Company can be created only for companies that have already been loaded. Hence, you must first load the companies whose accounts are to be grouped. Select the companies using F1:Select Cmp button. 
On the gateway of tally > we can see the name of two or more companies that are loaded > Press Alt + F3 > select create group company > Press Enter on Create Group Company.
Entering a Transaction is not possible in Group Company, that is, in AB Group company. [You have to enter the transaction in a member company only, that is, Company A or Company B]
Job work in Tally. ERP9
1.	 Create company.
2.	Enabling jobwork in Tally Erp 9 , go to gateway of Tally > Press F11 > F2 > allow joborder processing / use material in and out / Track stock item cost / maintain multiple godowns to YES.
3.	Allow job order processing- on enabling this feature in the gateway of tally > a new option order voucher will be displayed.   (job work in order and job)
4.	Material in and out- To create material in and out vouchers in inventoryk stock item  vouchers.
5.	Track stock item cost- If you want to track the cost of item from purchase till sale. On enebling this option in stock item master enable cost tracking field will be displayed.                                                                                                                                                                                      Principal manufacture : Pigeon home applications Pvt. Ltd.(Sundry debtors)                                                      Jobworker- TSM manufacturer/ global manufacturer(Sundry creditors)
6.	Voucher type creation									 Raw material in(material in) - finished goods out(material out) - Manufacturing journal(Stock journal)
7.	Job work in cycle (where raw materials are used for manufacturing from  job workers godown)										Job worker in order -> Material in (service godown -NA) -> Material out (for transferred material, count tracking for order no. , destination godown : Jobwork in) -> MAnufacturing journal (godown : jobwork in) -> Material out (Destination godown -NA) -> Sales invoice in item invoice -> Receipts voucher ....
8.	Item cost tracking- it can be done in voucher having movement or have an intent to create inventory movement in future , for a specific item , such as order vouchers , receipts notes, delivery notes etc. Item cost tracking option appears only in Expense, Purchase, Income & sales ledger.
9.	Jobwork (Sub contracting in Tally.ERP9)
	- Jobwork out ----> giving sub contract work to third party , Godown (imp. role)
	-Jobw recork in-----> Receiving sub contract. 
     10.   Job work out Cycle  										job work out order -> material out -> material in(is a godown from where  raw 	material are consumed for the manufacture of finished goods) ->  purchase 	invoice (in account invoice mode / voucher invoice mode) -> Payment made ......					
Error messages
•	After surrendering the license, and while reactivating if the message appears "couldnot reactivate the surrender  license" then it means that the license has not been surrendered properly.
surrender license first > Ctrl + K > login using remote tally.net id and password > then select option license management > there in status it will show pending for confirmation> take the cursor to the status option click there and press space bar > select the option confirm > then come out of control centre and again login > then , in the status it will show status as active > select the surrender there and then enter and accept it > license is surrenderred success fully.
•	While selecting any company it shows error message as" internal error contact tally solutions unable to read message/ file damaged error code xxxx" 
	In this case, close tally first , right click on tally icon > properties > shortcut > find 	target > open the Data folder > open the particular company in which such error 	is occuring > delete all .tsf files > close the folder >then perforn zero rerwite	(forced rewrite) i.e 	copy the targer path > paste it in Run give space write data 	space 0 > click ok > 	tally will open > then press Ctrl + Alt + R > select the 	company for rewrite > it will 	ask for back up before rewrite > enter and accept it 	> after the rewrite procedure 	is complete > open the tally and select the error 	company.
•	

	-

	                     

`