Sunday, November 30, 2008

Import data into Tally from multiple Excel Sheets

Batch Processing
UDIMagic v3.0 Release 1.67 supports "Batch Processing". In simple words, it allows you to "Import of data from multiple Excel sheets" in one-go.

Before going into the details of this feature, let's have a look at the Auto-Run feature of UDI-Magic which was introduced some-time back (UDIMagic v3.0 Release 1.60).

Auto Run
The Auto-Run feature allows import of data into Tally without any user-intervention. The auto-run status report is generated in autorun.txt file.

Scheduling UDIMagic to run a specific time
With the Auto-Run and Batch-Processing features, you can automate your tasks. In simple words, you can schedule UDIMagic in such a way that it automatically runs at a specified time (daily or weekly...) and imports data from one or more Excel (CSV) sheets into Tally.

For detailed description, please refer Import data into Tally from multiple Excel Sheets



Tuesday, November 18, 2008

Import Branch Office Tally data into Head Office Tally

In UDIMagic v3.0 Release 1.64, the Branch to Head Office feature supports data transformation also. Here are some examples of data transformation :-

Example 1 : Transform Sales vouchers as "Branch Sales"
Assuming that at your Branch Office, "Sales" vouchers are entered. Your requirement is that when the Branch-data is imported into the Head Office Tally, it must be imported as "Branch Sales" vouchers.

Example 2: Import specific Voucher-types only
At you Branch-Office, various type of entries like "Sales", "Receipt", "Payment" etc are done in Tally. You need to import the Branch-Office data in your Head-Office Tally, but only the "Sales" entries are to be imported, that too as "Branch Sales".

Remarks:-
1) We have listed some examples of data transformation.
2) UDIMagic [Professional] provides two features viz Tally-to-Tally and Branch-to-HO which support Data-transformation.
3) Almost all-types of Data-transformation can be done.



Monday, November 17, 2008

No Company is Open in Tally

FAQ's - Excel to Tally

I am using UDI-Magic to import data into Tally. Even though I have started Tally and opened one Company, UDI-Magic still shows error message "No company is opened in Tally". How do I solve this problem ?

Temporary Solution

Those who are using UDI-Magic Demo for evaluation purpose, are requested to follow these steps :-

1) Close the Tally Software.
2) Next, press Ctrl+Alt+Del.
3) Next select "Task Manager"
4) Next, search for Tally9.exe (or Tally72.exe under processes-tab) and click on the End-Process button to close it.
5) Next, search for TallyLicServer.exe (under processes-tab) and click on the End-Process button to close it.
6) Next, start Tally Software and open your Company.
7) Run UDI-Magic and try importing data in Tally Software.

Remarks:-
Re-start the Computer afterwards so that workstations can access the Tally-license Server which we had terminated manually.



Friday, November 14, 2008

Excel to Tally || Mapping of fields

FAQs

"How is the mapping of Excel sheet cells done with the Tally fields ?"

UDIMagic uses XML tags for mapping Excel Sheet cells with the Tally fields. The XML tags can be written using any text-editor like NOTEPAD.

There are two ways of writing XML tags viz
1) In the Comments of Cell A1 (or any other cell in 1st row) in the Excel sheet itself
2) In a separate file with extension XML.

For those who are totally new to XML, initially it may be difficult to digest all these things. But then, it is not very difficult.

We have provided several tutorials at Learn-Tally-XML-Tags blog-site

There is one more tutorial which covers the basics of "Writing XML tags" with step-by-step Instructions.

You can get several other good reference / links from our web-site at www.rtslink.com/udimagic-standard.html

PS: End-users need not worry about learning XML tags to use UDIMagic. Shweta Softwares provides the XML tags. Refer www.rtslink.com/orderinfo.html for more information.


Tips:
You can open XML files in IE (Internet Explorer) or any other browser. However, to edit it you must use a Text-editor or XML-editor.



Tally to Tally || Convert Sales vouchers to Purchase

This Post provides Tally-to-Tally Rules for converting Sales vouchers to Purchase.

Download
1) Sales-to-Purchase Rules (zip file)
2) Instructions for using Tally-to-Tally feature (PDF file)

What is Tally to Tally ?

UDIMagic v3.0 [Professional] comes with a feature called Tally-to-Tally that allows you to transform Tally data. As the name suggests, the Tally-to-Tally feature allows you to retrieve data from one Tally Company; apply transformation rules; and then send it to another Tally Company.

For more information, refer Tally-to-Tally


FAQs

I am having X records (say 10,000 records) in my Excel Sheet. I am using the licensed version of UDI Magic. However, UDI Magic processes only few records (say 100 records). What could be the reason ?

It is likely that your Excel Sheet has a BLANK-ROW or HIDDEN-ROW at or near the ROW-number 100 in the Excel Sheet. Remove that and try again. It should work.

PS:
1) UDI Magic stops processing if it finds a BLANK-ROW or a HIDDEN-ROW.
2) If you are using DEMO version of UDI Magic, then only 5 or 10 records (Vouchers and Masters resp.) shall be processed.


Thursday, November 13, 2008

Branch to Head Office - Transform Tally data

UDIMagic v3.0 Release 1.62



UDIMagic v3.0 Release 1.62 allows you to transform (Branch office) data before importing it into Head-Office Tally Accounting Software.

Illustration

Branch Office
Assuming, you have a Branch Office wherein Accounting is done in Tally. Here, at the Branch Office, only SALES vouchers entries are done. Now, you need to transfer the Branch Office data to Head-Office.

Head Office
At the Head-Office, you need to maintain consolidated data and hence will be importing the Branch-office data into the Head-Office (Tally). However, you want that the SALES vouchers (of Branch Office) be transformed/renamed as "BRANCH SALES" and then the same to be imported into the Head-Office Tally.

In simple words, this allows you to have TWO different Sales Voucher-types. i.e. one for Head-Office Sales and another for Branch-Office sales (BRANCH SALES voucher-type).

UDIMagic v3.0 Release 1.62 allows you to apply transformation rules to the Branch Office data before importing it at Head-Office. This allows you to do almost anything as per your requirement.

PS:
Support for writing transformation rules is available to UDIMagic [Professional version] users only.


Monday, November 10, 2008

Import selected data into Tally

UDIMagic - Excel to Tally


The UDIMagic v3.0 Release 1.61
allows you to import specific rows from MS-Excel into Tally Software.

To import part-data, you need to specify the FROM and TO rows.

By default, all rows are processed by UDIMagic. However, UDIMagic stops processing when it finds a BLANK row or a HIDDEN row.


Thursday, November 6, 2008

Posting multiple Vouchers from a single Excel Sheet

FAQ's : Excel to Tally

I want to import MS-Excel data into Tally such that TWO Vouchers are passed for each record in the MS-Excel sheet. Is it possible using UDIMagic Software?

Yes. It can be done.

Information for UDIMagic Partners
All you need to do is to write XML tags that contain TWO <VOUCHER> tags. Each <VOUCHER> tag will post one Voucher into Tally.

The XML tags file will look like this :-

<-- XML tags to create 1st Voucher -->
<VOUCHER>
.... XML tags .....
</VOUCHER>

<-- XML tags to create the 2nd Voucher -->
<VOUCHER>
.... XML tags .....
</VOUCHER>

Remarks:-
As you can see, we have specified TWO <VOUHCER> tags in the XML tags file for posting TWO vouchers for a single Excel-sheet record.

Tally error : Can't Import. Please check tally.imp file

FAQs : Excel to Tally

I am trying to import Vouchers into Tally Software using UDI-Magic Software. Though UDI-Magic shows no errors still no data is imported into Tally and the Tally screen (calculator panel) shows error "Cant' Import. Please check Tally.imp file"

The above error generally appears if you are using the Tally Demo (Educational) version and the Vouchers in the Excel Sheet have DATE's other than 1st or 2nd (of any month).

The Educational version of Tally accepts Vouchers for the 1st and 2nd of each month. i.e. You cannot import Vouchers having date other than the 1st or 2nd of any month.


Tuesday, November 4, 2008

Tally Error: Voucher Totals do not match

"Voucher Totals do not match. Dr 122.00 Cr 122.00 Diff 0.00"

Surprised. Even though the Debit and Credit figures shown in the error are same, Tally Software still shows Dr and Cr mismatch.


Cause of the Problem:-
It is likely that the Excel sheet that you are using contains some FORMULA's. Though the display format (may) have been set to 2 decimals, MS-Excel internally does not round it off to 2 decimals until you use the =ROUND() function.

Solution :-
Search for FORMULA's used in the Excel sheet and use the =ROUND() function wherever decimal points are required.

For example, let us assume, cell D2 has a FORMULA. i.e. =+A2 / B2.
You must change it to =Round(+A2 / B2,2)

Remarks:-
1) You can set the number of decimals places DISPLAYED in Excel-sheet using option "Format >> Cell >> Number". However, when UDIMagic programmatically retrieves the cell-data, MS-Excel may return a different value which is not rounded-off to two decimals.

2) Hence, you must use the =Round() function in Excel sheet wherever required, so that when UDIMagic programmatically retrieves the cell-data, the figure rounded-off to 2 decimals is returned.