Why to Learn XML
The title and subject matter of this article may surprise and many of you will think where XML stands in the accounting field or even with Tally.ERP 9.
Few months ago, I have the same impression as you have but as you will be surprised that xml very much related to Accounting Tally.ERP 9 or rather to say, if you knows xml properly, it will be very helpful in your day-to-day working.
As we all know that most of governments formalities requires e filling of various returns/forms/annexures and the main format of such returns/forms/annexures are xml.
Some of state vat returns requires you to prepare data in excel format and then converting the same into xml format so that you can upload the said converted xml file to VAT site
This is a crucial requirements and business have to comply all these formalise. Still many of you will think why to bother as it will be state responsibility to provide proper format and Tally.ERP 9 will take care of the same. I was also of the same opinion however few months ago, when I tried to upload one xml file to vat site, I got an error method and I was not able to upload the file. Now imagine it was a last day to file return however theere was some issue in the xml file which I had converted from excel to xml. This is the first time, I realised that knowing Accountancy and Tally.ERP 9 is not so enough we are living in a world where so many scripts, applications, programming languages exit and knowledge of these scripts/applications/language saves us from some hurdle and provides a smooth working experience. I take a quick study of the xml file structure and I observed there was a small error in the xml file. I goggled a little bit and I found that it is very easy to edit an xml file, just open the note pad and change the value which is wrong. save it and you are done!
So, it saved my day but lead me to think why not to learn xml is being used almost by so many softwares. its easy, its fun and it saves a lot of time. Even you can import vouchers from xml to Tally.ERP 9. No need to pass manual entries in Tally.ERP 9, just prepare an excel file, format it in Tally.ERP 9 supported xml format, convert the file and import to Tally.ERP 9. Imagine if you can pass 50 entries in Tally.ERP 9 just in 5 minutes!
It would save a lot of man hours as well as efficience of staff and so knowing xml is useful not for the staff but for company management also. Company may need less man power, or can use the existing man power for other business development.
I am confident after reading the above one will surely interested to know more about xml.
So, now the big question is what is XML and what it is used for ?
XML is the short name of eXtensible Markup Language. To make things simple, I will not discuss about the technical definition of XML and we will focus our scope limited for our purpose how to use this language to assist us in our day-to-day work.
XML isn’t a new language but its getting more and popularity now days due to its usage and simplicity. Its is very helpful for transfer of data from one plate form to another/software to software and so on. It is a tag based system and you can set your own tag. In other languages like Java, C++ there are certains rules. You have to go through pre defined systems but in XML you are free to write your application in your own way.
We can define XML is a way of defining tags to mark up data na solve some particular issues.
Do you know what is RSS and ATOM ? When you subscribe this blog through your email, you will get an email notification of any tutorial which I post to tallynine.com. That is called RSS / ATOM. In other words the fees of new post are being delivered to your email address through RSS and XML is the foundation of the RSS/ATOM. XML is a great common data interchanger format for publishing blogs.
XML offers exchnage of data over the web using various web services. We all have to work with XML in one or another way knowingly or unknowingly so a good knowledge of XML will server a very useful tool in our day-to-day working life.
We will learn more about xml and how it useful in Tally.ERP 9 and filing our returns online with various state vat departments.