Hi, Sharing few notes on Integration Capabilities of Tally ERP 9. Tally has developed its latest version Tally ERP 9 in account with the user’s convenience and with the fact that they will require some features that were not available in the earlier versions. The several strengths of the latest version also make it a perfect product for integration with other products which calls for the ability to offer the essential APIs for reading and writing. Tally ERP 9 is a complete business solution that offers different ways to integrate data. There are many APIs available in Tally, which are: · XML · ODBC · DLL These allow seamless integration between application/database in two modes. The first is online mode and the next is offline. Online Mode · Tally to Tally using synchronisation · Tally to External Application and vice versa using the available interfaces · Tally to web service using HTTP interface Offline Mode · Tally to External Applications using Export · Data from external application in XML using import Synchronisation Synchronisation is the way through which integration is done between Tally ERP 9. The data between all the branches can be synchronized with their head office. The words ‘Data Synchronisation’ implies to a process where data is replicated between two or more locations. With the help of this process the branch offices can send data to the head office and vice versa, over a network with a dynamic IP address or static IP address. Data synchronisation flows both ways, i.e. from the client to the server and vice versa. Integration Ability Tally ERP 9 integrates with your other prevailing IT and Tally solutions with ease, thanks to the several industry standard interfaces that are supported. One can program a spreadsheet in Excel to extract timely information from the latest Tally version using the ODBC interface. You can then be updated on your key metrics through a linked SMS alert product. These are simple examples of the several integration capabilities available. The most multipurpose interface is the SOAP capability of Tally ERP 9. All programming languages, standard IT products, and development tools support XML. An application can read and write into Tally ERP 9 without writing a single line of code in TDL. If you are already using other business solutions and wish to use the power of accounting, finance and reporting of the latest Tally version, you can export the data from Tally ERP 9, build the XML structure with data, and push it into Tally ERP 9. Internal unique identifiers, advanced capabilities, multi lingual and error responses will meet your most demanding needs of integration. Irrespective of your requirement, Tally ERP 9 as the hub in an IT solution, the technical abilities with complete Tally support are available by default without any additional expense. Thanks
Hi, As we know a Client application can access Tally.ERP 9 data in two forms 1.Tables 2.Calling a Procedure Right now we want to export entire data of tally into a database and in doing so, in doing so we have been able to access the entire data in the tables but we are stuck at second point (I.e. calling a procedure) Is there any way to know the total number of procedures (collections) in a standard tally installation? Also we want to know the properties of those collections (kind of table columns). Could we do it without using TDL? If not how can this be handled in TDL? Appreciate your response. Thanks, Naga
As of now, I think, u got the answer coz its almost 7 years. But for new members I m giving my view. Tally database is nosql database. You can't think it in row column way. You can export it in rows but its only for user convenience. Still anyone wants more clarification pls write the questions precisely. I will try to give answers or I will share my contact details. Many times clarification is better in discussions.
Synchronization means some strategy tailored to your needs. 1. Since you can not store state in Tally the other best option is to monitor Tally data. 2. Importing complete data from Tally would take time and if you are synchronizing multiple companies your option is to do that at intervals. Monitoring optimistically Ledger Voucher count, Voucher Type (Voucher) count etc etc should be fast and is dictated by type of Tally data. You can then selectively import data.
Expanding the first point, New data poses no problem External application can provide id along with Voucher which is also stored by Tally as part of the voucher. This id would remain the same across many / different imports. Minor points: 1. Vouchers imported into Tally from external sources can be tagged with corresponding voucher types. 2. Tally Vouchers can be exported to a mirror company in Tally or some database to compare. Third party applications before modifying data ideally would check whether the data has been modified in Tally. If so human reconciliation is called. Otherwise modify and update in Tally also.
Mirror Company is nothing but a backup either in Tally or some other database primarily used to compare. Mirror company is not where you do data entry. It is completely under program control. So when you post to mirror company also you can compare id and voucher data to find whether someone has modified the voucher data. It works flawlessly for data imported into Tally.
Tally has many id for the voucher - Remoteid, VchKey, Alterid, Masterid etc etc. I think some are there for backward compatibility. I think RemoteId defines source of data. And it helps Tally in synchronizing.
Collection Attribute Aggr Compute, Count of a Voucher Type, Voucher Count of a Ledger are some functions that can be employed to monitor Tally data entry.
Hello experts We are creating a web-based module and accessing Tally Data. We were planning to identify the changes in Tally database by Master id and Alter-Id. However once there is voucher autonumbering in Tally, and old voucher is deleted, then how to track this CHANGE (in voucher number) as Alterid remains same in system. Do we need to purge the entire data or there is any alternate route to track such changes. Appreciate your advice or guide which post should I refer to as I couldn’t search related one.
What I will do is, I will save a copy of Tally data to Local Database, and compare that with tally data , this way we can track add, edit and deletions in Tally If you don't want full database save at least AlterID, GUID and MasterId
Thanks @Vineeth for prompt response. We tried the same. In case one voucher is deleted on backdate by the user, then interestingly other vouchers Alterid, Masterid and GUID remains same.... are we are not able to track the change in voucher number due to old deletion... the only method remaining is that in case some Masterid is missing or inserted on back date, then Re-copy the entire Tally data.. this will delay the process....
That's the expected behaviour , deleting one voucher should not effect others vouchers We need to copy database only once , From next time we only sync differences like add, Delete, Update We compare existing local database with tally data sync differences
One way synchronization and New Item / Object updates are certainly doable. When querying Tally TDL function 'NumItems' (Object /Collection) and related functions are invaluable. Separate TDL specific code, Call them in your language, put them in a dll. Familiarity with TDL helps though.
