PROGRAMMER OR ACCOUNTANT: THE STORY OF MY BIZZARE PASSION

PART 1

"ABOUT ME"

ONCE UPON A TIME I WAS A STUDENT, WHO ALWAYS HAD BIZARRE DREAMS ABOUT HIS CAREER FIELD. THOUGH I GRADUATED MAJORLY IN ACCOUNTS & FINANCE WITH DISTINCTION, BUT HAD UNUSUAL AND BIZARRE IDEAS ABOUT WORKING IN THE AREA OF ACCOUNTS AND FINANCE. 
     
I SIMPLY BELIEVED THAT SOFTWARE TECHNOLOGY CAN POTENTIALLY ERADICATE ALL FLAWS IN THE PROCESS OF ACCOUNTING AND FINANCIAL REPORTING. IN GENERAL, I TEND TO BELIEVE THAT, ACCOUNTANTS HAVE UNDERUTILIZED THIS POTENTIAL POWER, BY BEING UNIMAGINATIVE AND PATHETIC IN THEIR APPROACH. 

THUS, WHILE OTHER FELLOW GRADUATES EVEN MY PARENTS WERE CONSIDERING ME A CRACK AND NEVER MADE ANY SENSE OUT OF WHAT I EVER SAID AND BELIEVED. "MAY BE SOFTWARE TECHNOLOGY WILL MAKE GOOD DIFFERENCE BUT THERE'S NO ROLL OF AN ACCOUNTING GUY LIKE ME OVER HERE", THIS WAS THE IDEA OF ALL AROUND ME.      

BUT NOTHING STOPPED ME FROM PURSUING MY PASSIONS & DREAMS. I HAD DREAMED OF MAKING A REVOLUTIONARY YET SIMPLE APP WHICH WOULD INTEGRATE TALLY.ERP 9 AND MS EXCEL OR ANY OTHER DATABASE CONTAINING BUSINESS TRANSATION AND THERE BY RESCUE THE ACCOUNTANTS FROM REDUNDANT WORK.      

"THE BEGINNING OF MY QUEST"

THE ACTION IN MY STORY STARTED WHILE I WAS WORKING UNDER A CHARTERED ACCOUNTANT. I FELT PREPOSTEROUS ABOUT HAVING THE WORK OF ENTERING JOURNAL ENTRIES INTO TALLY.ERP 9 FROM MS EXCEL SHEET. 

"DEFINING MY QUEST & ACCEPTING REALTY"

I HAD ALWAYS WONDERED, AS TO HAVING AN APP WHICH CAN READ THE DATA FROM EXCEL AND CONVERT THEM INTO PAYMENT TRANSACTIONS AND POST THEM INTO TALLY.ERP 9 SOFTWARE.     
NOW THAT IS GOOD BUT CERTAINLY I HAD NO IDEA OF EVEN THE A B C OF HOW TO MAKE A REAL SOFTWARE THEN.      

"WORK OF LUCK"

THEREAFTER, IT SO HAPPENED THAT I HAD CLEARED ICWAI (INSTITUTE OF COST AND WORKS ACCOUNTANTS) GROUP 2 LEVEL EXAMS TO MAKE MY PARENTS HAPPY. AND I WAS IN THE POSITION TO ASK FOR A REWARD OF MY DESIRE. I THEREFORE ASKED MY PARENTS TO ALLOW ME TO JOIN NIIT FOR A SOFTWARE DEVELOPMENT COURSE. I WAS EXTREMELY GLAD WHEN I WAS ALLOWED BY MY PARENTS TO JOIN. FOR THE FIRST TIME EVER LEARNED SOMETHING WITH SUCH A CUROSITY I HAD THEN. 

BUT STILL THE STORY WOULD TAKE NEXT 6 YEARS TO COMPLETED WITH A HAPPY ENDING. 

END OF PART 1.

PART 2

"PERIOD OF TECHNICAL RENAISSANCE"

NEVER HAD I BEEN SO CURIOUS ABOUT LEARNING ANY THING AS MUCH AS I WAS HERE IN NIIT. I HAD JOINED NIIT FOR .NET, CORE JAVA (FRONT END) + SQL SERVER TECHNOLOGY. ALTHOUGH LATER I COULDN'T COMPLETE .NET AS I HAD TO GO FOR JOB BUT COMFORTABLY COMPLETED CORE JAVA & SQL.

BUT DURING MY COURSE OF PROGRAMMING I HAD A PARTICULAR CURIOSITY, THAT IS I ALWAYS WANTED FIND TO HOW TO DEVELOP A SOLUTION TO INTEGRATE TALLY.ERP 9 AND OUTSIDE DATABASE AS IN MS EXCEL OR SQL.

"MEASURING DISTANCE TO GOAL"

BUT FRIENDS I WAS FAR FROM ANY POSSIBLE BREAKTHROUGH. THIS IS BECAUSE I NEVER PONDERED INTO WHAT TALLY.ERP 9 IS MADE UP OF AND MOST IMPORTANTLY HOW DOES IT INTERFACES WITH OUTSIDE TECHNOLOGY, NEVERTHELESS THESE THINGS WERE ABOUT TO BECOME THE GREATEST LESSONS OF MY LIFE IN NEXT COUPLE OF YEARS.

END OF PART 2.

PART 3

"PLEASURE OF TECHNICAL DRIVE"

I HAD REACHED THE HEIGHTS OF THE PLEASURE OF LEARNING A FAVORITE THING, THAT IS PROGRAMMING.
I WAS HAVING LOT OF FUN WRITING MINOR EXERCISE PROGRAMS IN CORE JAVA + SQL.

"HITTING THE DARKNESS"

BUT WHILE I WAS LEARNING SOFTWARE DEVELOPMENT STEP BY STEP, I WAS ALWAYS & CONSISTENTLY IN THE SEARCH OF FINDING THE WAY TO ACCESS THE DATABASE OF TALLY.ERP 9.

BUT I HAD A LONG WAY TO GO FOR MY ULTIMATE QUEST OF INTEGRATING WITH TALLY.ERP 9.

WHILE I WAS ABLE TO INSERT DATA INTO SQL SERVER 2005 & MS ACCESS I HAD NO IDEA AT ALL AS TO HOW TO HOW IT WOULD WORK FOR TALLY.ERP 9 DATABASE.

I MEAN UNLIKE MS ACCESS OR SQL SERVER 2005 WHICH ACCEPTS DATA THROUGH ODBC OR HTTP SERVICES, I HAD NO CLUE WHICH INTERFACE IS THE WAY INTO DATABASE TALLY.ERP 9.      

SO HOW DO WE GO ABOUT INSERTING DATA IN TALLY.ERP 9? THIS QUESTION REMAINED UNTIL THAT DAY AFTER 3 YEARS, WHEN MY FATE WANTED ME TO FINALLY UNDERSTAND IT ALL.

"FIRST RAY BREAK IN THE DARKNESS"

I CAME ACROSS AND READ AN A DOCUMENTATION IN TALLY SOLUTIONS WEBSITE 
[http://www.tallysolutions.com/website/html/tallydeveloper/integration-capabilities.php]
I READ ALL THE DOCUMENTATIONS AND NEVER UNDERSTOOD EVEN 5% AT THE START. BUT I PONDERED UPON IT AGAIN AND AGAIN AND EACH TIME I UNDERSTOOD SOMETHING NEW. EACH TIME LEARNED SOMETHING NEW.

"PARTS OF ZIGSAW PUZZLE"

I BEGAN REALIZING THAT XML AND CONCEPTS OF SOAP WEB SERVICES 

I HAD HEARD ABOUT SOAP WEB SERVICES LONG BACK.
I HAD ONLY HEARD THAT, WE CAN EXCHANGE DATA EMBEDDED IN XML IF THERE IS A SOAP WEB SERVER

BUT NEVER UNDERSTOOD THE SIGNIFICANCE OF IT IN ACCOMPLISHING MY DREAM APP FOR INSERTING DATA IN TALLY.ERP 9.

HOWEVER, THIS WAS THE FIRST GLIMPSE OF MY UNDERSTANDING OF TALLY INTEGRATION.

ONE THING WAS VERY CLEAR TO ME THAT, THE KEY TO TALLY INTEGRATION LIES IN SENDING XML TO TALLY'S WEB SERVICE ARCHITECTURE.

"FINAL DESTINATION & OUTCOME"

AFTER 30 DAYS OF R&D IN SENDING XML REQUEST TO TALLY.ERP 9 I FINALLY GOT THE WORKING JAVA CODE FOR INSERTING A PAYMENT VOUCHER IN TALLY (AS ONLY IF YOU COME TO KNOW THAT TALLY STORES TRANSACTION DATA IN TERMS OF VOUCHERS).

I HAVE EXPLAINED MY FIRST CODE TO TALLY.ERP 9 IN THE FOLLOWING LINK:

http://philosophyofsciencetech.blogspot.in/2012/11/tallys-web-service-architecture.html

FINALLY OUT OF MY TIGHT SCHEDULE OF WORK AND HOBBY IT TOOK NEXT 6 MONTHS FOR ME TO FINALLY DEVELOP MY FIRST TALLY.ERP 9 INTEGRATION APP.
(CLICK BELOW IMAGE TO DOWNLOAD THE APP)

  
NOW THE FOLLOWING PIC SHOWS THE ACCOUNTING ENTRY INSERTED BY THE ABOVE APP (HOP IN TALLY) INTO TALLY.ERP 9, THROUGH WEB SERVICES EMBEDDED IN XML PROTOCOL

AT THE END THE THING WHICH WAS NOT THE SCOPE OF AN ACCOUNTANT WAS DONE BY ME AS A HOBBYIST PROGRAMMER. 

BUT THE QUESTION REMAINS, AT THE END WHAT AM I? A PROGRAMMER OR ACCOUNTANT? 

Hop In Tally - Excel to Tally.ERP 9 App for Payment Entries

SHORT INTRODUCTION: 

APPLICATION NAME: 

HOP IN TALLY

FUNCTIONALITY: 

IMPORT PAYMENT ENTRIES FROM EXCEL TO TALLY (IN A NUTSHELL ITS A PROTOTYPE TALLY.ERP 9 INTEGRATION UTILITY)

TECHNOLOGY: 

CORE JAVA 

DATABASE TECHNOLOGY: 

<NOT APPLICABLE>

DEVELOPER: 

SUNEET K. CHAUDHARY

Dear All,

This is an app to import payment entries to tally from excel (.xls) file.

Downloading

Click here to download the 'Hop In Tally' App.
Also, Click here to check the JVM requirements.

Extracting 

Folders

Excel format

Hey! Remember your excel sheet to be imported must not contain the following characters:

• &
• "
• '
• <
• > 

Excel Path Mapping

Click on Check Connection and Import

Bulk Mailing App. From Any Excel Sheet Format

SHORT INTRODUCTION: 

APPLICATION NAME: 

SPACETIME APP. 

FUNCTIONALITY: 

BULK EMAILING FROM ANY EXCEL SHEET FORMAT

TECHNOLOGY: 

CORE JAVA 

DATABASE TECHNOLOGY: 

<NOT APPLICABLE>

DEVELOPER: 

SUNEET K. CHAUDHARY

Dear Folks,

This App is been developed for making bulk emails with attachment from and given excel sheet. You may have an excel sheet containing list of recipients from where you can mail them by selection the appropriate sheet, columns, from row & to row.

THE BIGGEST ADVANTAGE IS THAT YOU DON'T NEED TO HAVE A SPECIFIED EXCEL FORMAT. ANY EXCEL FORMAT SHALL DO.

Click Here and download SpaceTimeApp.zip
Also, Click Here and download suitable Java Environment for the above App. to run. 

Enter credentials and press 'submit' button:

Log In:

Select Excel file:

Select 'Sheet No.', 'Column No.', 'From Row' and 'To Row':

Select multiple attachments then write subject & body & click on 'send' button :

Apart from the above you also have a 'html/plain' writer:

URL COSMOS APP (Store, Retrieve & Open Website, Folders, FTP & Desktop App URL Categorically)

Introduction

SHORT INTRODUCTION:

NAME:

URL COSMOS

FUNCTIONALITY: 

URL MANAGEMENT (IT ACTS AS A REPLACEMENT OF WINDOWS SHORTCUT) 

TECHNOLOGY: 

CORE JAVA

DATABASE TECHNOLOGY: 

SQLLITE

DEVELOPER: 

SUNEET K. CHAUDHARY

Dear Folks,

I thought you might like use a very simple app made in Java by me as a hobbyist. Hence this page contains all about the implementation of 'URL Cosmos' (a. k. a. URL Dairy) which is a simple URL dairy. 

URL DAIRY certainly has the following features:

1. Storing and Retrieving Web & App. URLs. (Primary functionality)

2. Categorizing different Website & Application URLs.

3. Building your own category.

4. Ability to open Web URLs on browsers of your own choice. (Multiple Browser adding).

5. EMAIL URL directly from the app.

6. Apart from the above, it has some minor yet useful functionality like,

Shut down

Restart 

Log off

Hibernate

Control Panel

Ping IP

Google Search

Tutorials

• HOW TO GET RID OF DESKTOP SHORTCUTS 

• HOW TO REDUCE TYPING WORK WITH URL COSMOS APP

• HOW TO SEND/SHARE WEB LINKS FROM URL COSMOS APP

Downloading

Click Here and download URLCosmos.zip

Also, Click Here and download suitable Java Environment for the above App. to run. 

Read Inbox in Java (through IMAP host)

The following is a simple Java code for reading inbox mails of Yahoo from Internet Messaging Access Protocol  or IMAP host for Yahoo.
Caution: The application downloads entire inbox to your desktop application on the console screen.
So be careful as it takes long time for more number of emails.
You may further enhance the following code to download only unread emails.
Java code for filtering the unread emails will be published soon  . 

package inbox;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

import java.util.Properties;

import javax.mail.Flags;
import javax.mail.Folder;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.NoSuchProviderException;
import javax.mail.Session;
import javax.mail.Store;
import javax.mail.search.FlagTerm;


/**
 *
 * @author SUNEET
 */
public class Inbox {

    /**
     *
     * @param args the command line arguments
     */
    public static void main(String[] args) throws MessagingException, IOException {
        // TODO code application logic here
        Properties props = System.getProperties();
        props.setProperty( "mail.transport.protocol", "smtps");
        try {
                Session session = Session.getDefaultInstance(props, null);
                Store store = session.getStore("imaps");

                // IMAP host for yahoo.
                // Replace <username> with the valid username of your Email ID.
                // Replace <password> with a valid password of your Email ID.              
                // IMAP host for yahoo.
                store.connect("imap.mail.yahoo.com", "<username>", "<password>");

                System.out.println(store);
             
                Folder inbox = store.getFolder("Inbox");
                inbox.open(Folder.READ_ONLY);
             
                BufferedReader optionReader = new BufferedReader(new InputStreamReader(System.in));
                showAllMails(inbox);
             
        } catch (NoSuchProviderException e) {
            System.out.println(e.toString());
            System.exit(1);
        } catch (MessagingException e) {
            System.out.println(e.toString());
            System.exit(2);
        }

    }  
 
 
    static public void showAllMails(Folder inbox){
        try {
            Message msg[] = inbox.getMessages();
            System.out.println("MAILS: "+msg.length);
            for(Message message:msg) {
                try {
                    System.out.println("DATE: "+message.getSentDate().toString());
                    System.out.println("FROM: "+message.getFrom()[0].toString());          
                    System.out.println("SUBJECT: "+message.getSubject().toString());
                    System.out.println("CONTENT: "+message.getContent().toString());
                    System.out.println("******************************************");
                } catch (Exception e) {
                    System.out.println("No Information");
                }
            }
        } catch (MessagingException e) {
            System.out.println(e.toString());
        }
    }
}

Send SMTP E-Mail in Java

This post will give you the understanding of very basic Java required to send SMTP e-mail.
You basically need to download (click here) "mail-1.4.jar".
Link the "mail-1.4.jar" file to your library: (See pic below)

Compile the following java code:

import java.util.Properties;

import javax.mail.Message;

import javax.mail.MessagingException;

import javax.mail.PasswordAuthentication;

import javax.mail.Session;

import javax.mail.Transport;

import javax.mail.internet.InternetAddress;

import javax.mail.internet.MimeMessage;

/**

 *

 * @author SUNEET

 */

public class Web {

    /**

     * @param args the command line arguments

     */

   public static void main(String[] args) {                

final String username = "s_lady@rocketmail.com";

final String password = "Password";

                //set properties

Properties props = new Properties();

props.setProperty( "mail.transport.protocol", "smtps");

                props.put("mail.smtp.auth", "true");

                props.put("mail.smtp.host", "plus.smtp.mail.yahoo.com");

                props.put("mail.smtp.port", "465");

                props.put("mail.smtp.socketFactory.class", "javax.net.ssl.SSLSocketFactory");

                props.put("mail.smtp.ssl","true");

                props.put("mail.stmp.user", "username");

                props.put("mail.smtp.password", "password");

                //password authetication

Session session = Session.getInstance(props,

 new javax.mail.Authenticator() {

protected PasswordAuthentication getPasswordAuthentication() {

return new PasswordAuthentication(username, password);

}

 });

                //send e-mail

try {

Message message = new MimeMessage(session);

message.setFrom(new InternetAddress("s_lady@rocketmail.com"));

message.setRecipients(Message.RecipientType.TO,

InternetAddress.parse("s_lady@rocketmail.com"));

message.setSubject("Test mail");

message.setText("Dear reciever,"

+ "\n\n No spam to my email, please!");

Transport.send(message);

System.out.println("Email Sended.");

} catch (MessagingException e) {

throw new RuntimeException(e);

}

}

}

Tally ERP 9's Web Service Architecture (Introduction to JAVA to Tally Integration)

Are you looking for finding out ways to connect your application with Tally database. Well if so then this is the right page which will introduce you to Tally's Web Service Architecture which is the best way to integrate Tally with outside technology.

However before you go further with the introduction, my assumption is that you already know basics of Tally along with Tally's XML schema and if not then watch the following video for the basic idea of Tally's XML:

Alternate link
The following is a working java code which sends a payment voucher to Tally database through SOAP request into the Web Service Architecture of Tally and fetches a response from Tally indicating the action taken by Tally for the request in XML format.
Check it out.

1: Go to "Gateway of Tally >> F12 Configure >> Advanced Configuration" settings (Some initial settings needed to be done inside Tally)

2: Request by the Java application code

package tallyrequest;

import java.io.*;

import java.net.*;

/**

 *

 * @author SUNEET

 */

public class TallyRequest{

   

    public String CreateRequest()

    {             

        String TXML = null;

        TXML = "<ENVELOPE>"

                + "<HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER>"

                + "<BODY>"

                + "<IMPORTDATA>"

                + "<REQUESTDESC><REPORTNAME>Vouchers</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>Company</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC>"

                + "<REQUESTDATA>"

                + "<TALLYMESSAGE xmlns:UDF=\"TallyUDF\">"

                + "<VOUCHER REMOTEID=\"00000001\" VCHTYPE=\"Receipt\" ACTION=\"Create\" OBJVIEW=\"Accounting Voucher View\">"      

                + "<DATE>20140401</DATE>"

                + "<VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>"

                + "<VOUCHERNUMBER>1</VOUCHERNUMBER>"

                + "<PARTYLEDGERNAME>Cash</PARTYLEDGERNAME>"

                + "<PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW>"      

                + "<ALLLEDGERENTRIES.LIST>"

                + "<LEDGERNAME>Capital Account</LEDGERNAME>"

                + "<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>"

                + "<AMOUNT>50000.00</AMOUNT>"       

                + "</ALLLEDGERENTRIES.LIST>"

                + "<ALLLEDGERENTRIES.LIST>"      

                + "<LEDGERNAME>Cash</LEDGERNAME>"

                + "<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>"

                + "<AMOUNT>-50000.00</AMOUNT>"          

                + "</ALLLEDGERENTRIES.LIST>"    

                + "</VOUCHER>"

                + "</TALLYMESSAGE>"

                + "</REQUESTDATA>"

                + "</IMPORTDATA>"

                + "</BODY>"

                + "</ENVELOPE>";

        return TXML;

    }

   

    public void SendToTally() throws Exception{

        String Url = "http://127.0.0.1:9000/";      

        String SOAPAction = "";

       

        String Voucher = this.CreateRequest();

// Create the connection where we're going to send the file.

        URL url = new URL(Url);

        URLConnection connection = url.openConnection();

        HttpURLConnection httpConn = (HttpURLConnection) connection;

       

        ByteArrayInputStream bin = new ByteArrayInputStream(Voucher.getBytes());

        ByteArrayOutputStream bout = new ByteArrayOutputStream();

// Copy the SOAP file to the open connection.

       

        copy(bin, bout);     

        byte[] b = bout.toByteArray();

// Set the appropriate HTTP parameters.

        httpConn.setRequestProperty("Content-Length", String.valueOf(b.length));

        httpConn.setRequestProperty("Content-Type", "text/xml; charset=utf-8");

        httpConn.setRequestProperty("SOAPAction", SOAPAction);

        httpConn.setRequestMethod("POST");

        httpConn.setDoOutput(true);

        httpConn.setDoInput(true);

// Everything's set up; send the XML that was read in to b.

        OutputStream out = httpConn.getOutputStream();

        out.write(b);

        out.close();

// Read the response and write it to standard out.

        InputStreamReader isr =

                new InputStreamReader(httpConn.getInputStream());

        BufferedReader in = new BufferedReader(isr);

        String inputLine;

        while ((inputLine = in.readLine()) != null) {

            System.out.println(inputLine);

        }

        in.close();

    }

    public static void copy(InputStream in, OutputStream out)

            throws IOException {

// do not allow other threads to read from the

// input or write to the output while copying is

// taking place

        synchronized (in) {

            synchronized (out) {

                byte[] buffer = new byte[256];

                while (true) {

                    int bytesRead = in.read(buffer);

                    if (bytesRead == -1) {

                        break;

                    }

                    out.write(buffer, 0, bytesRead);

                }

            }

        }

    }

   

    public static void main(String[] args) throws Exception {

        TallyRequest r = new TallyRequest();

        r.SendToTally();

    }

}

3: Response by the Tally Web Service Architecture

4: Voucher inserted inside Tally