This is further to my earlier post on the above subject-matter.
Multiple Price Levels in Tally
Tally Accounting Software allows you to maintain "Multiple Price levels". This feature is useful in situations wherein you have different types of Customers like "Wholesale Customers", "Retail customers", "Export Customers" etc. Using the "Multiple Price Levels" feature you can assign different prices (or discounts) to different types of Customers.
UDIMagic and "Multiple Price Levels" in Tally
UDIMagic allows you to Import "Multiple Price Levels" data into Tally. Here's a detailed writeup on how you can import "Multiple Price Levels (Price List)" data into Tally Software along with sample Excel sheet and XML tags.
Sunday, December 14, 2008
Saturday, December 13, 2008
Error: XML tag SVCURRENTCOMPANY not found
FAQs: Tally-to-Tally
While using the UDIMagic Tally-to-Tally feature to transfer "Sales vouchers" from source-company as "Purchase vouchers" into the destination-company, I get the following error :-
XML tags <SVCURRENTCOMPANY> not found.
Cause of Error:-
The aforesaid generally occurs when you have NOT specified the UDIMagic TCP file in your Tally.ini file.
Solution:-
Open the Tally.ini (which is there in Tally folder) and add the following lines depending upon Tally version you are using.
;;For Tally 7.2 users
User TDL = Yes
TDL = C:\tally\udimagic72.tcp
;;For Tally 9 users
User TDL = Yes
TDL = C:\tally\udimagic9.tcp
;;For Tally 9 Release 3 [Beta]
User TDL = Yes
TDL = C:\tally\udimagic9-R3.tcp
Remarks:-
1) Ensure that the UDIMagic TCP file exists in your Tally folder.
2) The aforesaid UDIMagic TCP files get copied into "c:\udi-magic" folder when you install the UDIMagic software.
3) You must use the udimagic9-r3.tcp file with Tally 9 Release 3 [Beta]. This file is provided with the latest release of UDIMagic v3.0 Release 1.75 which can be downloaded from http://www.rtslink.com/downloads.html
While using the UDIMagic Tally-to-Tally feature to transfer "Sales vouchers" from source-company as "Purchase vouchers" into the destination-company, I get the following error :-
XML tags <SVCURRENTCOMPANY> not found.
Cause of Error:-
The aforesaid generally occurs when you have NOT specified the UDIMagic TCP file in your Tally.ini file.
Solution:-
Open the Tally.ini (which is there in Tally folder) and add the following lines depending upon Tally version you are using.
;;For Tally 7.2 users
User TDL = Yes
TDL = C:\tally\udimagic72.tcp
;;For Tally 9 users
User TDL = Yes
TDL = C:\tally\udimagic9.tcp
;;For Tally 9 Release 3 [Beta]
User TDL = Yes
TDL = C:\tally\udimagic9-R3.tcp
Remarks:-
1) Ensure that the UDIMagic TCP file exists in your Tally folder.
2) The aforesaid UDIMagic TCP files get copied into "c:\udi-magic" folder when you install the UDIMagic software.
3) You must use the udimagic9-r3.tcp file with Tally 9 Release 3 [Beta]. This file is provided with the latest release of UDIMagic v3.0 Release 1.75 which can be downloaded from http://www.rtslink.com/downloads.html
Error: Parameter has no default value
FAQs: Import data from Foxpro DBF into Tally
I am using the UDIMagic software to import data from my Foxpro DBF into Tally. While running UDIMagic, I am getting the following error :-
"Parameter has no default value"
Cause of Error:-
The above error generally errors when incorrect field-name is specified in the SQL-SELECT statement.
Solution:-
1) Check (and rectify) the field-name(s) specified in the SQL-SELECT statement.
2) Also ensure that you have specified the correct folder-name which contains the DBF's from which data is to be imported into Tally. The steps to specify the folder-name are as follows :-
I am using the UDIMagic software to import data from my Foxpro DBF into Tally. While running UDIMagic, I am getting the following error :-
"Parameter
Cause of Error:-
The above error generally errors when incorrect field-name is specified in the SQL-SELECT statement.
Solution:-
1) Check (and rectify) the field-name(s) specified in the SQL-SELECT statement.
2) Also ensure that you have specified the correct folder-name which contains the DBF's from which data is to be imported into Tally. The steps to specify the folder-name are as follows :-
STEP 2a
STEP 2b
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
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.
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.
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.
"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
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.
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.
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.
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.
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.
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.
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.
Wednesday, September 24, 2008
Importing CSV data into Tally Software using UDIMagic
CSV (Comma Separated values) files are plain-text files having extension (.csv or .txt) that contains data-values that are separated by commas. The first line in the file must be the Header-line and is followed by data-rows.
CSV files can be directly opened/ viewed in MS-Excel.
This post provides a CSV file that contains Ledger-Master records. Follow the steps given underneath to import data from the CSV file into Tally 9 :-
STEPS:-
1) Download and unzip the ledger-master-csv.zip file.
The zip file contents are :-
a) Ledger-Master.csv (Can be directly opened in MS-Excel)
b) Ledger-Master.xml (Use Internet Explorer to view this file)
2) Next, start Tally and create/open any Dummy Company
3) Next, minimize Tally
4) Start UDIMagic Software
5) Select option "Excel to Tally"
6) Select option "Masters"
7) Next, select the CSV file by clicking on the Browse button. By default, only Excel-files are displayed in the list-box. You need to set the option "Files of Type" as "All Files" as shown below:-
After setting option "Files of Type" as "All files", select the CSV file named "Ledger-master".
8) Next, select the XML tags file "Ledger-Master.xml".
Remarks: The XML tags file is to be selected in the same screen in which you are prompted to select the Excel/CSV file
9) Next, click on the START button to import data into Tally.
If everything goes fine, then ONE Ledger-Master record (named Shweta Softwares) will be imported into Tally. You can view the same using option "Gateway of Tally >> Accounts Info >> Ledger >> Alter" and check for Ledger named "Shweta Softwares".
Remarks:-
1) The "Excel to Tally" feature can be used to import data from both MS-Excel files or CSV files.
2) For importing data from other sources like SQL-Server; MySQL; Access; DBF-files and popular databases, you must use the "Advanced Usage" option in UDIMagic software.
3) UDIMagic identifies data in the source-file (MS-Excel or CSV or Database-files) based upon the mapping given in the XML-file and constructs proper XML tags which are supported by Tally Software.
CSV files can be directly opened/ viewed in MS-Excel.
This post provides a CSV file that contains Ledger-Master records. Follow the steps given underneath to import data from the CSV file into Tally 9 :-
STEPS:-
1) Download and unzip the ledger-master-csv.zip file.
The zip file contents are :-
a) Ledger-Master.csv (Can be directly opened in MS-Excel)
b) Ledger-Master.xml (Use Internet Explorer to view this file)
2) Next, start Tally and create/open any Dummy Company
3) Next, minimize Tally
4) Start UDIMagic Software
5) Select option "Excel to Tally"
6) Select option "Masters"
7) Next, select the CSV file by clicking on the Browse button. By default, only Excel-files are displayed in the list-box. You need to set the option "Files of Type" as "All Files" as shown below:-
Set option "Files of Type" as "All files"After setting option "Files of Type" as "All files", select the CSV file named "Ledger-master".
8) Next, select the XML tags file "Ledger-Master.xml".
Remarks: The XML tags file is to be selected in the same screen in which you are prompted to select the Excel/CSV file
9) Next, click on the START button to import data into Tally.
If everything goes fine, then ONE Ledger-Master record (named Shweta Softwares) will be imported into Tally. You can view the same using option "Gateway of Tally >> Accounts Info >> Ledger >> Alter" and check for Ledger named "Shweta Softwares".
Remarks:-
1) The "Excel to Tally" feature can be used to import data from both MS-Excel files or CSV files.
2) For importing data from other sources like SQL-Server; MySQL; Access; DBF-files and popular databases, you must use the "Advanced Usage" option in UDIMagic software.
3) UDIMagic identifies data in the source-file (MS-Excel or CSV or Database-files) based upon the mapping given in the XML-file and constructs proper XML tags which are supported by Tally Software.
Monday, September 22, 2008
UDIMagic with Auto Run feature
UDIMagic v3.0 Release 1.60 comes with a new feature called Auto-Run.
What is Auto Run ?
The Auto Run feature allows you to setup UDIMagic to run automatically without any User-intervention.
Once this feature is enabled, you can add UDIMagic to "Windows Scheduler" to run UDIMagic at scheduled timings.
How to enable the Auto Run mode in UDIMagic ?
1) Start UDIMagic and follow the wizard instructions to import data as you normally do.
2) In the Settings screen, click on the "Enable Auto Run" check-box to enable it.
3) Next, click on the Start button to import data into Tally.
This now enables Auto-Run mode; and few lines are added to the UDIMagic.ini (configuration) file. You can also manually edit the UDIMagic.ini (configuration) to enable/disable the Auto-Run feature.
How do I add UDIMagic to Windows Scheduler ?
1) From the Windows Start menu, select "Settings >> Control Panel"
2) Next, select Scheduled Tasks
This displays all the currently scheduled tasks.
3) Next, select "File >> New >> Scheduled Task"
4) Give a name to the Task, say UDIMAGIC.
5) Next, double-click on UDIMAGIC scheduled task to modify the settings
This will auto-run UDIMagic at the schedule timings.
Remarks:-
1) In the Auto-Run mode, a file named "Autorun.log" is created which records the UDIMagic process activites. This is generally useful for keeping track of Data imported; or errors (if any).
2) When the Auto-Run mode is enabled, manually starting UDIMagic will display a AUTO-RUN Splash screen that allows you to Skip or Disable the Auto-Run mode.
What is Auto Run ?
The Auto Run feature allows you to setup UDIMagic to run automatically without any User-intervention.
Once this feature is enabled, you can add UDIMagic to "Windows Scheduler" to run UDIMagic at scheduled timings.
How to enable the Auto Run mode in UDIMagic ?
1) Start UDIMagic and follow the wizard instructions to import data as you normally do.
2) In the Settings screen, click on the "Enable Auto Run" check-box to enable it.
3) Next, click on the Start button to import data into Tally.
This now enables Auto-Run mode; and few lines are added to the UDIMagic.ini (configuration) file. You can also manually edit the UDIMagic.ini (configuration) to enable/disable the Auto-Run feature.
How do I add UDIMagic to Windows Scheduler ?
1) From the Windows Start menu, select "Settings >> Control Panel"
2) Next, select Scheduled Tasks
This displays all the currently scheduled tasks.
3) Next, select "File >> New >> Scheduled Task"
4) Give a name to the Task, say UDIMAGIC.
5) Next, double-click on UDIMAGIC scheduled task to modify the settings
This will auto-run UDIMagic at the schedule timings.
Remarks:-
1) In the Auto-Run mode, a file named "Autorun.log" is created which records the UDIMagic process activites. This is generally useful for keeping track of Data imported; or errors (if any).
2) When the Auto-Run mode is enabled, manually starting UDIMagic will display a AUTO-RUN Splash screen that allows you to Skip or Disable the Auto-Run mode.
Thursday, August 28, 2008
Tally 9 Release 3 BETA issues
Tally Solutions, Bangalore has come out with a new Release of Tally Software. i.e. Tally 9 Release 3 Beta.
What is BETA Software?
Beta is a nickname for software which has passed the alpha testing stage of development and has been released to a limited amount of users for software testing before its official release.
Tally 9 Release 3 BETA
Some new and advanced features have been introduced in the Tally 9 Release 3 which relate to :-
a) Tally Synchronization
b) Accessing Tally data over Internet
The new features and functionality are applaudable. However, this is a BETA version and many problems have been reported with this new Release 3 BETA. As there are several issues; I am not putting up all the problems / issues here.
As a result we advice all our Customers (users of RTSlink DLL and UDIMagic software) to wait till Tally Solutions, Bangalore comes out with a stable Release.
What is BETA Software?
Beta is a nickname for software which has passed the alpha testing stage of development and has been released to a limited amount of users for software testing before its official release.
Tally 9 Release 3 BETA
Some new and advanced features have been introduced in the Tally 9 Release 3 which relate to :-
a) Tally Synchronization
b) Accessing Tally data over Internet
The new features and functionality are applaudable. However, this is a BETA version and many problems have been reported with this new Release 3 BETA. As there are several issues; I am not putting up all the problems / issues here.
As a result we advice all our Customers (users of RTSlink DLL and UDIMagic software) to wait till Tally Solutions, Bangalore comes out with a stable Release.
Sunday, August 10, 2008
Branch Office to Head Office
UDIMagic v3.0 Release 1.56 comes with a new feature "Branch to Head Office". This module allows you to transfer Tally Accounting data from your Branch Office to Head Office without using the Tally Synchronization feature.
UDIMagic "Branch to HO" module is an alternative to Tally Synchronization feature. The primary objective herein is one-way transfer of data. i.e. from Branch Office to H.O.For more information, please refer "Transfer Branch Office [Tally] data to Head Office".
UDIMagic "Branch to HO" module is an alternative to Tally Synchronization feature. The primary objective herein is one-way transfer of data. i.e. from Branch Office to H.O.For more information, please refer "Transfer Branch Office [Tally] data to Head Office".
Tuesday, July 8, 2008
Excel Sheet templates
You can now access all the Excel Sheet templates for importing Masters and Vouchers into Tally from this link :-
http://www.rtslink.com/download-excel-sheets.html
http://www.rtslink.com/download-excel-sheets.html
Wednesday, July 2, 2008
Online Demo for UDIMagic
Write to us for Online Demonstration of UDIMagic. The Demo shall be provided right in your System, by our staff sitting in our Office at Gandhidham, Gujarat.
For more information, refer http://www.rtslink.com/contact.html
For more information, refer http://www.rtslink.com/contact.html
Stock Item Master with UDF XML tags
Here's a sample Excel sheet which contains Stock Item Master records with the following details:-
a) UDF (User-defined-field) named UPDATEDDT
b) Standard Cost
c) Standard Price
d) Alternate Units
e) Default Ledger
f) Multiple Godowns
g) Batch Expiry
Download the Excel sheet with XML tags.
Remarks:-
The primary objective of this sample Excel sheet and XML tags is to provide basic understanding as to how you can use UDF's (User-defined-fields created using Tally definition language) with UDIMagic. The XML tags relating to the UDF will be ignored if the TDL does not exist.
a) UDF (User-defined-field) named UPDATEDDT
b) Standard Cost
c) Standard Price
d) Alternate Units
e) Default Ledger
f) Multiple Godowns
g) Batch Expiry
Download the Excel sheet with XML tags.
Remarks:-
The primary objective of this sample Excel sheet and XML tags is to provide basic understanding as to how you can use UDF's (User-defined-fields created using Tally definition language) with UDIMagic. The XML tags relating to the UDF will be ignored if the TDL does not exist.
Sunday, June 29, 2008
Importing Standard Cost / Price data into Tally 9
When we import the Stock-Item Masters with Standard Cost /Price data into Tally 9, the existing Standard Cost / Price data gets overwritten.
For more information, please refer :-
Tally 9 Bug: Importing Stock Masters with Standard Cost / Price
UDIMagic v3.0 Release 1.50 comes with new functionality that allows you to import Stock Item Masters (with Standard Cost / Price data) into Tally 9 without overwriting the existing data.
For more information, please refer :-
Tally 9 Bug: Importing Stock Masters with Standard Cost / Price
UDIMagic v3.0 Release 1.50 comes with new functionality that allows you to import Stock Item Masters (with Standard Cost / Price data) into Tally 9 without overwriting the existing data.
Sunday, June 8, 2008
Introducing UDI Magic [Light] version
UDI Magic [Light] is light-weight version of UDI Magic [Standard] . It supports Import of MASTER's from MS-Excel into Tally Accounting Software.
UDI Magic [Light] is a low-priced utility which is particularly useful for Customers who wish to Import only Masters from MS-Excel into Tally. It is also useful for Tally Professionals who wish to provide solutions to end-users for importing Masters data from Excel into Tally. However, it does NOT support import of Vouchers from MS-Excel into Tally.
Features
- Supports import of all Masters from MS-Excel into Tally Software
- Supports user-defined-fields created using TDL
- Supports VBA (Visual Basic for Applications)
(a powerful feature that is useful for performing calculations and manipulating Excel data at runtime)
For Cost details, please refer www.rtslink.com/buy.html
For other terms and conditions, please refer www.rtslink.com/orderinfo.html
For learning "How to write XML tags ?", please refer www.learn-tally-xml-tags.blogspot.com
UDI Magic [Light] is a low-priced utility which is particularly useful for Customers who wish to Import only Masters from MS-Excel into Tally. It is also useful for Tally Professionals who wish to provide solutions to end-users for importing Masters data from Excel into Tally. However, it does NOT support import of Vouchers from MS-Excel into Tally.
Features
- Supports import of all Masters from MS-Excel into Tally Software
- Supports user-defined-fields created using TDL
- Supports VBA (Visual Basic for Applications)
(a powerful feature that is useful for performing calculations and manipulating Excel data at runtime)
For Cost details, please refer www.rtslink.com/buy.html
For other terms and conditions, please refer www.rtslink.com/orderinfo.html
For learning "How to write XML tags ?", please refer www.learn-tally-xml-tags.blogspot.com
Saturday, June 7, 2008
Purchase Vouchers with multiple VAT rates
Here's a sample Excel file that contains "Purchase" Vouchers with multiple VAT rates which are to be imported into Tally.
Follow these steps to Import the Excel sheet data into Tally Software.
1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
2) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) purchase-vouchers-with-multiple-vat-rates.xls (Excel sheet)
2) purchase-vouchers-with-multiple-vat-rates-xml-tags.xml (XML tags file)
3) purchase-vouchers-with-multiple-vat-rates-macro.txt (contains macros)
Follow these steps to Import the Excel sheet data into Tally Software.
1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
2) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) purchase-vouchers-with-multiple-vat-rates.xls (Excel sheet)
2) purchase-vouchers-with-multiple-vat-rates-xml-tags.xml (XML tags file)
3) purchase-vouchers-with-multiple-vat-rates-macro.txt (contains macros)
Thursday, June 5, 2008
Shares Sales/Purchase transactions
Here's a sample Excel file that contains "Shares sale and purchase" transactions which are to be imported into Tally.
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
2) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally >> Voucher".
6) Next, select the XML-tags file and the Excel sheet when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) shares-sales-purchase-transactions.xls (Excel sheet)
2) shares-sales-purchase-transactions-xml-tags.xml (XML tags file)
3) shares-sales-purchase-transactions-macro.txt (contains macros)
Remarks:-
1) The following settings / options have been kept for Stock-Item masters:-
a) COSTING METHOD: FIFO
b) MARKET VALUATION METHOD: Avg. Cost
This can be changed as per requirement.
2) The Shares (per unit) cost is computed as follows:-
Purchase Price + Brokerage + ServiceTax + STT
3) The Shares (per unit) net Sales-realization value is computed as follows:-
Sales Price - Brokerage - ServiceTax - STT
4) The Firm-name (Share Broker-firm name) can be changed as per requirement.
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
2) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally >> Voucher".
6) Next, select the XML-tags file and the Excel sheet when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) shares-sales-purchase-transactions.xls (Excel sheet)
2) shares-sales-purchase-transactions-xml-tags.xml (XML tags file)
3) shares-sales-purchase-transactions-macro.txt (contains macros)
Remarks:-
1) The following settings / options have been kept for Stock-Item masters:-
a) COSTING METHOD: FIFO
b) MARKET VALUATION METHOD: Avg. Cost
This can be changed as per requirement.
2) The Shares (per unit) cost is computed as follows:-
Purchase Price + Brokerage + ServiceTax + STT
3) The Shares (per unit) net Sales-realization value is computed as follows:-
Sales Price - Brokerage - ServiceTax - STT
4) The Firm-name (Share Broker-firm name) can be changed as per requirement.
Tuesday, June 3, 2008
Sales vouchers with Multi-currency and Cost Category / centres
Here's a sample Excel file that contains "Sales" Vouchers with Multi-currency ; Cost Category and Cost Centres which are to be imported into Tally.
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Enable the following features in Tally 9
a) F11 -> Accounting Features -> Allow Multi-Currency
b) F11 -> Accounting Features -> Maintain Cost Centres
c) F11 -> Accounting Features -> More than ONE Payroll / Cost Category
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) sales-vouchers-with-multi-currency.xls (Excel sheet)
2) sales-vouchers-with-multi-currency-xml-tags.xml (XML tags file)
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Enable the following features in Tally 9
a) F11 -> Accounting Features -> Allow Multi-Currency
b) F11 -> Accounting Features -> Maintain Cost Centres
c) F11 -> Accounting Features -> More than ONE Payroll / Cost Category
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) sales-vouchers-with-multi-currency.xls (Excel sheet)
2) sales-vouchers-with-multi-currency-xml-tags.xml (XML tags file)
Learn Tally XML tags
Want to learn Tally XML tags and import Excel data into Tally...
Here's our new blog Learn Tally XML tags that attempts to teach you write XML tags to import data into Tally Software.
Here's our new blog Learn Tally XML tags that attempts to teach you write XML tags to import data into Tally Software.
Sales Vouchers with multiple VAT rates
Here's a sample Excel file that contains "Sales" Vouchers with multiple VAT rates which are to be imported into Tally.
Follow these steps to Import the Excel sheet data into Tally Software.
1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
2) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) sales-vouchers-with-multiple-vat-rates.xls (Excel sheet)
2) sales-vouchers-with-multiple-vat-rates-xml-tags.xml (XML tags file)
3) sales-vouchers-with-multiple-vat-rates-macro.txt (contains macros)
Follow these steps to Import the Excel sheet data into Tally Software.
1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
2) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) sales-vouchers-with-multiple-vat-rates.xls (Excel sheet)
2) sales-vouchers-with-multiple-vat-rates-xml-tags.xml (XML tags file)
3) sales-vouchers-with-multiple-vat-rates-macro.txt (contains macros)
Friday, May 30, 2008
Advanced Macros : Lookup Masters from a different Sheet
Here's a sample Excel file that contains "Journal" Vouchers which are to be imported into Tally.
In this sample, macros have been used to lookup the Masters data. The sample Excel-file contains two sheets as shown below:-
1) Vouchers
2) Masters
Here's how the "Vouchers" sheet looks like:-
Remarks:-
1) The "Vouchers" sheet contains a Column "Bank Name". The values in this Column are replaced at run-time using VBA (macros). Example :- "Axis" is replaced with "Axis bank Ltd" at runtime.
2) In the "Masters" sheet, we have specified the Group-Name under which the Account is to be created.
3) In case, if a Master is not specified in the "Masters" sheet, UDI-Magic automatically creates that Ledger under a Group called "New Ledger Items".
Follow these steps to Import the Excel sheet data into Tally Software.
1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
2) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) journal-vouchers-with-service-tax.xls (Excel sheet)
2) journal-vouchers-with-service-tax-xml-tags.xml (XML tags file)
3) journal-vouchers-with-service-tax-macro.txt (contains macros)
In Brief
UDIMagic supports VBA (Visual Basic for Applications), a powerful feature that allows you to automate and perform almost all tasks that can be done manually in MS-Excel. In this sample, we use VBA to lookup the Master's Full-Name and the Group-Name from the "Masters" sheet.
In this sample, macros have been used to lookup the Masters data. The sample Excel-file contains two sheets as shown below:-
1) Vouchers
2) Masters
Here's how the "Vouchers" sheet looks like:-
Here's how the "Masters" sheet looks like:-
Remarks:-
1) The "Vouchers" sheet contains a Column "Bank Name". The values in this Column are replaced at run-time using VBA (macros). Example :- "Axis" is replaced with "Axis bank Ltd" at runtime.
2) In the "Masters" sheet, we have specified the Group-Name under which the Account is to be created.
3) In case, if a Master is not specified in the "Masters" sheet, UDI-Magic automatically creates that Ledger under a Group called "New Ledger Items".
Follow these steps to Import the Excel sheet data into Tally Software.
1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project
2) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) journal-vouchers-with-service-tax.xls (Excel sheet)
2) journal-vouchers-with-service-tax-xml-tags.xml (XML tags file)
3) journal-vouchers-with-service-tax-macro.txt (contains macros)
In Brief
UDIMagic supports VBA (Visual Basic for Applications), a powerful feature that allows you to automate and perform almost all tasks that can be done manually in MS-Excel. In this sample, we use VBA to lookup the Master's Full-Name and the Group-Name from the "Masters" sheet.
Sample Excel Sheets : Correction in Voucher Date
When you Download and install UDIMagic Demo version, few sample Excel sheets get created when you run it for the first time.
We have noticed that the Excel sheets containing Voucher records (Sales; Purchase; Payment; Receipt etc) had Voucher Date as 01-04-2007 (dd-mm-yyyy). This generated error if you imported the Vouchers data into your Tally Company with Books beginning date as 01-04-2008 (dd-mm-yyyy). The error message is given below for your reference :-
"The date 1-4-2007 is Out of Range"
Remarks:-
The Voucher Date in the Excel sheets is 1-4-2007 whereas the Books Beginning-Date in the Tally (Company) is specified as 1-4-2008.
Now, the Voucher Date in the sample Excel Sheets has been corrected and changed to 01-04-2008 in UDIMagic v3.0 Release1.45. Alternatively, you can manually change the Date in the Excel Sheets which get created in the "C:\udiMagic" folder.
We have noticed that the Excel sheets containing Voucher records (Sales; Purchase; Payment; Receipt etc) had Voucher Date as 01-04-2007 (dd-mm-yyyy). This generated error if you imported the Vouchers data into your Tally Company with Books beginning date as 01-04-2008 (dd-mm-yyyy). The error message is given below for your reference :-
"The date 1-4-2007 is Out of Range"
Remarks:-
The Voucher Date in the Excel sheets is 1-4-2007 whereas the Books Beginning-Date in the Tally (Company) is specified as 1-4-2008.
Now, the Voucher Date in the sample Excel Sheets has been corrected and changed to 01-04-2008 in UDIMagic v3.0 Release1.45. Alternatively, you can manually change the Date in the Excel Sheets which get created in the "C:\udiMagic" folder.
Monday, May 19, 2008
Using UDIMagic to Import Price List into Tally 9
Here's a sample Excel sheet that contains StockItem Master records with multiple Price Levels.
For those who are not familiar with the Price List (Multiple Price Level) feature of Tally, here's a brief introduction:-
Price List in Tally 9
Tally Software allows you to maintain different Price Levels for a single Stock-Item. For example, a stock-item may be sold at different rates to :-
a) Whole-sale Dealers
b) Retailers
c) End-users
Tally Software provides "Multiple Price Levels" feature that allows you to accomplish this task.
Enabling the Multiple Price Level feature
To import Stock-Item Masters with multiple Price Level from the sample Excel sheet, you must first enable the Multiple Price-level feature in Tally using the underneath option :-
Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels=Yes
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Enable the Multiple Price Level feature using F11 -> Inventory Features option. Next, add two Price Levels viz a) MRP b) ListPrice
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Master".
6) Next, select the Excel sheet prompted.
7) Next, follow the instructions in the wizard to import data into Tally.
Notes:-
1) XML tags are written in the comments section of Cell c1 of the Excel Sheet. These XML tags are used by UDIMagic to identify and read data from the Excel sheet and send it to Tally Software.
2) XML tags for using Price-List feature are given below:-
<FULLPRICELIST.LIST>
<DATE>20080401</DATE>
<!-- Specify the Price Level here -->
<PRICELEVEL>MRP</PRICELEVEL>
<PRICELEVELLIST.LIST>
<!-- Specify the Rate here. Ex: <RATE>50.00 / Nos</RATE> -->
<RATE FORMULA="=+F# & "/" & E#"/>
</PRICELEVELLIST.LIST>
</FULLPRICELIST.LIST>
For those who are not familiar with the Price List (Multiple Price Level) feature of Tally, here's a brief introduction:-
Price List in Tally 9
Tally Software allows you to maintain different Price Levels for a single Stock-Item. For example, a stock-item may be sold at different rates to :-
a) Whole-sale Dealers
b) Retailers
c) End-users
Tally Software provides "Multiple Price Levels" feature that allows you to accomplish this task.
Enabling the Multiple Price Level feature
To import Stock-Item Masters with multiple Price Level from the sample Excel sheet, you must first enable the Multiple Price-level feature in Tally using the underneath option :-
Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels=Yes
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Enable the Multiple Price Level feature using F11 -> Inventory Features option. Next, add two Price Levels viz a) MRP b) ListPrice
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Master".
6) Next, select the Excel sheet prompted.
7) Next, follow the instructions in the wizard to import data into Tally.
Notes:-
1) XML tags are written in the comments section of Cell c1 of the Excel Sheet. These XML tags are used by UDIMagic to identify and read data from the Excel sheet and send it to Tally Software.
2) XML tags for using Price-List feature are given below:-
<FULLPRICELIST.LIST>
<DATE>20080401</DATE>
<!-- Specify the Price Level here -->
<PRICELEVEL>MRP</PRICELEVEL>
<PRICELEVELLIST.LIST>
<!-- Specify the Rate here. Ex: <RATE>50.00 / Nos</RATE> -->
<RATE FORMULA="=+F# & "/" & E#"/>
</PRICELEVELLIST.LIST>
</FULLPRICELIST.LIST>
Friday, May 9, 2008
XML tags with Formula's
UDIMagic || Excel to Tally
This post illustrates how to write XML tags that include formula's. For those who are new, here's a brief introduction to UDIMagic.
"UDIMagic is a software utility that allows you to Import Excel data into Tally Software. It can process any type of data (Masters or Vouchers) irrespective of the format in which it is arranged in the Excel sheet. All you need to do is to specify what data you have in the Excel sheet and where is it stored. This is done using XML tags."
In simple words, UDIMagic uses the XML tags to read the Excel sheet data and then Import it into the Tally Software.
Now, let's us try to understand how to write the XML tags. For illustrative purpose, we have taken up a single tag i.e. the NARRATION tag which is used to specify the Narration in Voucher-entries.
Format 1
<NARRATION> This is a Static Narration </NARRATION>
Remarks:-
The above XML tag instruct UDIMagic that NARRATION tag has a static / fixed value.
Format 2
<NARRATION COLUMNREFERENCE="B"/>
Remarks:-
In the above XML tag, we have used an attribute named COLUMNREFERENCE which instructs UDIMagic to fetch the value of NARRATION tag from Column B of the Excel sheet.
Format 3
<NARRATION FORMULA="=+B# & " " & C#"/>
Remarks:-
In the above XML tag, we have used an attribute named FORMULA which instructs UDIMagic that NARRATION tag value is to be taken from TWO columns viz Column B and Column C.
Writing FORMULA's
Before you write any formula in XML, it is advised that you test the same in MS-Excel. Here are the steps for writing / testing the Formula that we require :-
1) Start Excel and open a new workbook
2) Enter "Shweta" in Cell B2
3) Enter "Computers" in Cell C2
4) Enter a formula in Cell D2 as shown below:-
=B2 & " " & C2
If you correctly enter the aforesaid formula, then you will get "Shweta Computers" in Cell D2. After you get the correct result, you can then write the formula in your XML tags with some modifications.
The aforesaid formula in XML format is as follows:-
Formula in XML
=B# & " " & C#
Formula in Excel
=B2 & " " & C2
Remarks:-
1) The ampersand sign (&) and quote (") are special characters and must be written differently in XML. The ampersand sign (&) is written as & and the quote (") is written as " in XML.
2) For more details on XML Escape sequences, please refer http://www,rtslink.com/introductionxmlsoap.html
This post illustrates how to write XML tags that include formula's. For those who are new, here's a brief introduction to UDIMagic.
"UDIMagic is a software utility that allows you to Import Excel data into Tally Software. It can process any type of data (Masters or Vouchers) irrespective of the format in which it is arranged in the Excel sheet. All you need to do is to specify what data you have in the Excel sheet and where is it stored. This is done using XML tags."
In simple words, UDIMagic uses the XML tags to read the Excel sheet data and then Import it into the Tally Software.
Now, let's us try to understand how to write the XML tags. For illustrative purpose, we have taken up a single tag i.e. the NARRATION tag which is used to specify the Narration in Voucher-entries.
Format 1
<NARRATION> This is a Static Narration </NARRATION>
Remarks:-
The above XML tag instruct UDIMagic that NARRATION tag has a static / fixed value.
Format 2
<NARRATION COLUMNREFERENCE="B"/>
Remarks:-
In the above XML tag, we have used an attribute named COLUMNREFERENCE which instructs UDIMagic to fetch the value of NARRATION tag from Column B of the Excel sheet.
Format 3
<NARRATION FORMULA="=+B# & " " & C#"/>
Remarks:-
In the above XML tag, we have used an attribute named FORMULA which instructs UDIMagic that NARRATION tag value is to be taken from TWO columns viz Column B and Column C.
Writing FORMULA's
Before you write any formula in XML, it is advised that you test the same in MS-Excel. Here are the steps for writing / testing the Formula that we require :-
1) Start Excel and open a new workbook
2) Enter "Shweta" in Cell B2
3) Enter "Computers" in Cell C2
4) Enter a formula in Cell D2 as shown below:-
=B2 & " " & C2
If you correctly enter the aforesaid formula, then you will get "Shweta Computers" in Cell D2. After you get the correct result, you can then write the formula in your XML tags with some modifications.
The aforesaid formula in XML format is as follows:-
Formula in XML
=B# & " " & C#
Formula in Excel
=B2 & " " & C2
Remarks:-
1) The ampersand sign (&) and quote (") are special characters and must be written differently in XML. The ampersand sign (&) is written as & and the quote (") is written as " in XML.
2) For more details on XML Escape sequences, please refer http://www,rtslink.com/introductionxmlsoap.html
UDIMagic Multi-user version
Multi-user version of UDIMagic is now available. For cost details, please refer http://www.rtslink.com/buy.html
Tuesday, May 6, 2008
Stock Item Masters with Batch expiry
Here's a sample Excel-sheet that contains StockItem Masters with Batch expiry and Multiple Locations.
As we are using Multiple-Godown and Batch-wise expiry features, the StockItem Master records may span to multiple rows, as seen in the sample Excel-sheet. The NAME field (i.e. StockItem Name) is used as the Key-field.
We are also using a Macro file which is required to do some calculations at run-time. Due to this, you may get an error message, if you are using Excel 2003 or higher. To solve this issue, refer FAQ: "Programmatic access to Visual basic project is not trusted".
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Enable the following features using F11 key :-
a) Maintain Multiple Godowns
b) Maintain Batch-wise details
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Master".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) stockitem-with-batch-expiry.xls (Excel sheet)
2) stockitem-with-batch-expiry-xml-tags.xml (XML tags file)
3) stockitem-with-batch-expiry-macro.txt (contains macros)
As we are using Multiple-Godown and Batch-wise expiry features, the StockItem Master records may span to multiple rows, as seen in the sample Excel-sheet. The NAME field (i.e. StockItem Name) is used as the Key-field.
We are also using a Macro file which is required to do some calculations at run-time. Due to this, you may get an error message, if you are using Excel 2003 or higher. To solve this issue, refer FAQ: "Programmatic access to Visual basic project is not trusted".
Follow these steps to Import the Excel sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Enable the following features using F11 key :-
a) Maintain Multiple Godowns
b) Maintain Batch-wise details
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally -> Master".
6) Next, select the Excel sheet and the XML-tags file when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
7) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents
1) stockitem-with-batch-expiry.xls (Excel sheet)
2) stockitem-with-batch-expiry-xml-tags.xml (XML tags file)
3) stockitem-with-batch-expiry-macro.txt (contains macros)
Thursday, May 1, 2008
Set / Modify default Ledger for Stock Items in Tally 9
Here's a case wherein the Customer already had few thousand Stock-Item Master records in Tally 9. The requirement was to set the Default Ledger for these Stock-Items.
As all the Stock-Items were of similar type (i.e. spares parts), a common ledger was to be assigned to all the Stock-Items. Example:-
Stock-Item Name : Bush
Ledger Name : Sales @ 12.5%
VAT : Sales @ 12.5%
Posting : 100%
Though this could be easily done if we could directly access the Tally database, like using REPLACE or UPDATE (SQL) in other programming languages to update any database/table.
Herein, we had follow these steps:-
1) Export the Stock-Item Masters from Tally 9 into Excel sheet
2) Add the Ledger Name; VAT; Posting details in Excel sheet
3) Copy/paste the Ledger-name;VAT; Posting details to all Stock-Items in the Excel-sheet.
4) Next, import the data into Tally 9 using UDIMagic utility.
Download the Excel sheet and XML tags for Set-default-Ledger-for-StockItems.zip
As all the Stock-Items were of similar type (i.e. spares parts), a common ledger was to be assigned to all the Stock-Items. Example:-
Stock-Item Name : Bush
Ledger Name : Sales @ 12.5%
VAT : Sales @ 12.5%
Posting : 100%
Though this could be easily done if we could directly access the Tally database, like using REPLACE or UPDATE (SQL) in other programming languages to update any database/table.
Herein, we had follow these steps:-
1) Export the Stock-Item Masters from Tally 9 into Excel sheet
2) Add the Ledger Name; VAT; Posting details in Excel sheet
3) Copy/paste the Ledger-name;VAT; Posting details to all Stock-Items in the Excel-sheet.
4) Next, import the data into Tally 9 using UDIMagic utility.
Download the Excel sheet and XML tags for Set-default-Ledger-for-StockItems.zip
Thursday, April 10, 2008
Using VBA to manipulate Excel sheet data at run-time
Here's a sample Excel sheet named (v-link-collection.xls) that contains Receipt Voucher entries which are to be posted into the Tally Software.
Understanding the Excel sheet data
The Excel sheet contains details of Cash received from various parties. Though there are several entries (parties), a single entry is to be passed as shown below:-
Cash a/c Debit
Party A a/c Credit
Party B a/c Credit
Party C a/c Credit
For this purpose, we have written a MACRO (v-link-collection-macro.txt) which calculates the TOTAL AMOUNT that is to be posted to the Cash A/c in this case. Note that this is calculated at runtime using the commands specified in the macro-file.
How does UDIMagic function ?
When you run UDIMagic, you are prompted to select
a) the Excel sheet which contains the data and
b) the XML tags for it.
Next, when you click the START button, UDIMagic loads the Excel file and the XML tags. If you view the XML tags file (in Internet Explorer), you will notice that we have specified a tag that load VBA macro file. It is shown herewith for your reference :-
<VBA LOADFILE="v-link-collection-macro.txt" RUNMACROATSTARTUP="NewColumns"/>
UDIMagic processes /executes the Macro file which calculates the Total Amount and stores it in Column AB. Though this may sound simple, using VBA you can almost do anything that you could manually do in MS-Excel. That's the power of VBA. In case, if you using Excel 2003 or higher, you may get an error-message, and if so please refer this FAQ: "Programmatic access to Visual basic project is not trusted" to solve this issue.
For more information on VBA, please refer this FAQs: "Using VBA with UDIMagic"
Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents:-
v-link-collection.xls (Excel sheet)
v-link-collection-xml-tags.xml (XML tags)
v-link-collection-macro.txt (Macro file)
Understanding the Excel sheet data
The Excel sheet contains details of Cash received from various parties. Though there are several entries (parties), a single entry is to be passed as shown below:-
Cash a/c Debit
Party A a/c Credit
Party B a/c Credit
Party C a/c Credit
For this purpose, we have written a MACRO (v-link-collection-macro.txt) which calculates the TOTAL AMOUNT that is to be posted to the Cash A/c in this case. Note that this is calculated at runtime using the commands specified in the macro-file.
How does UDIMagic function ?
When you run UDIMagic, you are prompted to select
a) the Excel sheet which contains the data and
b) the XML tags for it.
Next, when you click the START button, UDIMagic loads the Excel file and the XML tags. If you view the XML tags file (in Internet Explorer), you will notice that we have specified a tag that load VBA macro file. It is shown herewith for your reference :-
<VBA LOADFILE="v-link-collection-macro.txt" RUNMACROATSTARTUP="NewColumns"/>
UDIMagic processes /executes the Macro file which calculates the Total Amount and stores it in Column AB. Though this may sound simple, using VBA you can almost do anything that you could manually do in MS-Excel. That's the power of VBA. In case, if you using Excel 2003 or higher, you may get an error-message, and if so please refer this FAQ: "Programmatic access to Visual basic project is not trusted" to solve this issue.
For more information on VBA, please refer this FAQs: "Using VBA with UDIMagic"
Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
ZIP file contents:-
v-link-collection.xls (Excel sheet)
v-link-collection-xml-tags.xml (XML tags)
v-link-collection-macro.txt (Macro file)
Friday, April 4, 2008
Fetch/Export data from Ledger Master
FAQs: Tally to Excel
"I am using UDI-Magic 'Tally to Excel' option to retrieve Ledger Master data from Tally 9 into Excel. This generates an XML parse error. The SELECT-statement and error message are given below".
SELECT statement
SELECT $Name, $Parent FROM Ledger
Error Message
XML parse Error (Invalid unicode character)
Problem cause and Solution
Though the SELECT-statement show above is correct, still udi-Magic generates error message. This is because the data that is returned by Tally contains some Invalid Unicode characters (as the said error message suggests)
On further analysis, we found that Tally has a Ledger named "Profit & Loss a/c" which falls under Group "# Primary". The Group name contains an invalid unicode character as the first character (although we have show # hash). On further analysis we found that the Group Name returned by Tally was " Primary".
Solution
As the cause of this problem is invalid unicode character which relates to Ledgers created under the Group "Primary", we filtered out the list using WHERE clause.
Here is the new SELECT-SQL that works fine:-
SELECT $Name, $Parent FROM Ledger WHERE not $Name="Profit & Loss a/c"
"I am using UDI-Magic 'Tally to Excel' option to retrieve Ledger Master data from Tally 9 into Excel. This generates an XML parse error. The SELECT-statement and error message are given below".
SELECT statement
SELECT $Name, $Parent FROM Ledger
Error Message
XML parse Error (Invalid unicode character)
Problem cause and Solution
Though the SELECT-statement show above is correct, still udi-Magic generates error message. This is because the data that is returned by Tally contains some Invalid Unicode characters (as the said error message suggests)
On further analysis, we found that Tally has a Ledger named "Profit & Loss a/c" which falls under Group "# Primary". The Group name contains an invalid unicode character as the first character (although we have show # hash). On further analysis we found that the Group Name returned by Tally was " Primary".
Solution
As the cause of this problem is invalid unicode character which relates to Ledgers created under the Group "Primary", we filtered out the list using WHERE clause.
Here is the new SELECT-SQL that works fine:-
SELECT $Name, $Parent FROM Ledger WHERE not $Name="Profit & Loss a/c"
Wednesday, April 2, 2008
Introducing Tally to Tally feature
UDIMagic v3.0 [Professional] Release 1.40 comes with a new 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. This is particularly useful in case of concerns wherein Sales of one firm becomes Purchase of another sister concern firm. Herein, UDIMagic picks data from the Source company; transforms it and then sends it to the Destination Company, thus saving your precious time and avoiding typographical mistakes.
Know more about Tally to Tally feature...
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. This is particularly useful in case of concerns wherein Sales of one firm becomes Purchase of another sister concern firm. Herein, UDIMagic picks data from the Source company; transforms it and then sends it to the Destination Company, thus saving your precious time and avoiding typographical mistakes.
Know more about Tally to Tally feature...
Working with UDFs - Singapore GST
FAQs: Excel to Tally
"Can I use UDIMagic to import UDF's (user-defined-fields) data from Excel into Tally ?"
Yes. UDIMagic supports all Tally Masters and Voucher-types including Tally UDFs (User-defined-fields). To be more specific, UDIMagic can process whatever data that you can manually enter in Tally Software for any Master or Voucher.
Herein, we shall take up sample Excel sheets which contain Purchase and Sales Vouchers data including UDF data that is to be imported into Tally.
Singapore GST
A TCP file (GST72.TCP) has been provided by Tally Solutions, Bangalore that provides new reports/fields required by Tally Customers in Singapore.
The sample Excel-sheets provided herewith contain a field for GST (Goods and Service Tax) that is to be imported into a UDF which is created using TDL (i.e. GST72.TCP file). GST is applicable in Signpore and is similar to VAT that is applicable in INDIA.
Learn more about "Using UDIMagic to import data including UDF (Singapore GST) into Tally Software".
"Can I use UDIMagic to import UDF's (user-defined-fields) data from Excel into Tally ?"
Yes. UDIMagic supports all Tally Masters and Voucher-types including Tally UDFs (User-defined-fields). To be more specific, UDIMagic can process whatever data that you can manually enter in Tally Software for any Master or Voucher.
Herein, we shall take up sample Excel sheets which contain Purchase and Sales Vouchers data including UDF data that is to be imported into Tally.
Singapore GST
A TCP file (GST72.TCP) has been provided by Tally Solutions, Bangalore that provides new reports/fields required by Tally Customers in Singapore.
The sample Excel-sheets provided herewith contain a field for GST (Goods and Service Tax) that is to be imported into a UDF which is created using TDL (i.e. GST72.TCP file). GST is applicable in Signpore and is similar to VAT that is applicable in INDIA.
Learn more about "Using UDIMagic to import data including UDF (Singapore GST) into Tally Software".
Monday, March 31, 2008
Import Stock-Item master data from Excel into Tally
UDIMagic || Excel to Tally
Here's a sample Excel-sheet that contains Stock-Item Master data along with some advanced features as given below:-
a) Price List
Tally Software provides a feature called Price-list wherein users can define different price structures/level for different purposes, generally for different Group of Customers requiring different discounts. To enable this feature in Tally 9, use option:-
"Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels" and set it to YES.
This prompts you for "Company Price Levels" dialog-box. Create a PRICE-LEVEL called MRP, that will be used while importing data from Excel sheet. The sample Excel sheet provided herewith contains MRP (Column R) and Discount (Column Q) which is imported into the PRICE-LEVEL feature using UDI-Magic.
b) Specify default Ledger Allocation for Invoicing
This feature allows you to specify the default Ledger Allocation for each Stock-item along with the VAT-classification for it. The sample Excel sheet provided herewith contains the default Ledger-name (see Column D); VAT-class (see Column E) and Posting (see Column F).
Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Master".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
PS:
a) You must manually enable the features "Price-List" and "Specify default ledger allocation for Invoicing" as specified above.
b) The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.
Unleash the power of UDIMagic
UDI-Magic is a simple yet powerful utility that allows you to Import any type of data into Tally Software that can be manually entered into Tally Software.
Here's a sample Excel-sheet that contains Stock-Item Master data along with some advanced features as given below:-
a) Price List
Tally Software provides a feature called Price-list wherein users can define different price structures/level for different purposes, generally for different Group of Customers requiring different discounts. To enable this feature in Tally 9, use option:-
"Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels" and set it to YES.
This prompts you for "Company Price Levels" dialog-box. Create a PRICE-LEVEL called MRP, that will be used while importing data from Excel sheet. The sample Excel sheet provided herewith contains MRP (Column R) and Discount (Column Q) which is imported into the PRICE-LEVEL feature using UDI-Magic.
b) Specify default Ledger Allocation for Invoicing
This feature allows you to specify the default Ledger Allocation for each Stock-item along with the VAT-classification for it. The sample Excel sheet provided herewith contains the default Ledger-name (see Column D); VAT-class (see Column E) and Posting (see Column F).
Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Master".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
PS:
a) You must manually enable the features "Price-List" and "Specify default ledger allocation for Invoicing" as specified above.
b) The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.
Unleash the power of UDIMagic
UDI-Magic is a simple yet powerful utility that allows you to Import any type of data into Tally Software that can be manually entered into Tally Software.
Import Purchase Vouchers data from Excel into Tally
UDIMagic || Excel to Tally
Here's a sample Excel-sheet that contains Purchase Vouchers with VAT and Discount. Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet.
Remarks:- The XML tags in this case have been written in the Excel-sheet itself. Hence, you must uncheck the option "Use separate file for XML tags" while using UDI-Magic.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
Here's a sample Excel-sheet that contains Purchase Vouchers with VAT and Discount. Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet.
Remarks:- The XML tags in this case have been written in the Excel-sheet itself. Hence, you must uncheck the option "Use separate file for XML tags" while using UDI-Magic.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
Thursday, March 20, 2008
Import Customers and Suppliers Masters from Excel into Tally
UDIMagic || Excel to Tally
Here's a sample Excel-sheet that contains Customer and Supplier Ledger Masters. Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Master".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
PS:
The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.
Here's a sample Excel-sheet that contains Customer and Supplier Ledger Masters. Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Master".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
PS:
The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.
Monday, March 17, 2008
Import Credit Notes from Excel into Tally
UDI-Magic || Excel to Tally
Here's a sample Excel-sheet that contains Credit Note Vouchers of an Advertisement firm. Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
Remarks:-
The ZIP file contains 3 files viz:-
a) circulation-credit-notes.xls (Excel-sheet)
b) circulation-credit-notes-xml-tags.xml (XML-tags file)
c) circulation-credit-notes-macro.txt (Macro file)
XML-Tags
Normally, in the previous samples the XML tags were written in the Excel-sheet itself (i.e. in the comments section of cell A1). However, in this case the XML-tags are provided in a separate file, hence you must specify the XML-tags file when prompted in the UDIMagic wizard screen.
Macro-file
This sample contains a macro-file which does some calculations at run-time. This is required as the Voucher-totals are not manually added and are calculated at run-time. VBA (or Macros) is a very powerful feature in MS-Office applications that allows you to automate tasks. UDIMagic uses this feature to manipulate Excel-sheet data at run-time to perform calculations; add new columns etc.
Here's a sample Excel-sheet that contains Credit Note Vouchers of an Advertisement firm. Follow these steps to import the Excel-sheet data into Tally Software.
1) Download and unzip the files into "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.
Remarks:-
The ZIP file contains 3 files viz:-
a) circulation-credit-notes.xls (Excel-sheet)
b) circulation-credit-notes-xml-tags.xml (XML-tags file)
c) circulation-credit-notes-macro.txt (Macro file)
XML-Tags
Normally, in the previous samples the XML tags were written in the Excel-sheet itself (i.e. in the comments section of cell A1). However, in this case the XML-tags are provided in a separate file, hence you must specify the XML-tags file when prompted in the UDIMagic wizard screen.
Macro-file
This sample contains a macro-file which does some calculations at run-time. This is required as the Voucher-totals are not manually added and are calculated at run-time. VBA (or Macros) is a very powerful feature in MS-Office applications that allows you to automate tasks. UDIMagic uses this feature to manipulate Excel-sheet data at run-time to perform calculations; add new columns etc.
Thursday, March 13, 2008
Sales Vouchers with Salesman UDF
UDIMagic supports import of Masters and Vouchers data from Excel to Tally. It also supports UDF (user-defined fields) created using Tally Definition Language (TDL).
A sample Excel sheet "Vouchers - Sales Transactions with Salesman UDF" has been provided for evaluation. To use it, you must download both the Excel sheet and the TDL file. The links for downloading the Excel sheet; TDL file are given in my earlier post "Sales Vouchers with Salesman UDF".
Further, you need to enable the Salesman UDF using the F11 [features] key. For more details in this TDL (Salesman UDF), refer our blogsite tdlplayground.
A sample Excel sheet "Vouchers - Sales Transactions with Salesman UDF" has been provided for evaluation. To use it, you must download both the Excel sheet and the TDL file. The links for downloading the Excel sheet; TDL file are given in my earlier post "Sales Vouchers with Salesman UDF".
Further, you need to enable the Salesman UDF using the F11 [features] key. For more details in this TDL (Salesman UDF), refer our blogsite tdlplayground.
Friday, March 7, 2008
Error: Programmatic access to visual basic project is not trusted
If you are using macros (VBA code) with UDIMagic, you may get the above error-message if you are using Office 2003 or above.
Here's how you can solve this issue:-
Here's how you can solve this issue:-
- Open Excel
- Goto Tools -> Macros ->Security
- In the Security Window choose the Trusted Publisher Tab
- Click "Trust Access to Visual basic Project" and enable it.
- Click OK.
- Close Excel.
Wednesday, March 5, 2008
Import multiple user-defined Receipt Vouchers from Excel to Tally
UDIMagic || Excel to Tally
This is in continuation of my previous post wherein we had provided a sample Excel sheet with Receipt Vouchers.
Herein, a sample Excel-sheet containing multiple user-defined Receipt Vouchers is being provided. Follow these steps to import data from this Excel-sheet into Tally Software.
1) Download the Excel sheet and copy it to "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted.
5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally.
Remarks:-
The XML tags are written in cell A1 (comments section) of the Excel sheet. Alternatively, we can write the XML tags in a separate file also.
This is in continuation of my previous post wherein we had provided a sample Excel sheet with Receipt Vouchers.
Herein, a sample Excel-sheet containing multiple user-defined Receipt Vouchers is being provided. Follow these steps to import data from this Excel-sheet into Tally Software.
1) Download the Excel sheet and copy it to "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted.
5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally.
Remarks:-
The XML tags are written in cell A1 (comments section) of the Excel sheet. Alternatively, we can write the XML tags in a separate file also.
Tuesday, March 4, 2008
Import Receipt Vouchers from Excel into Tally
UDIMagic || Excel to Tally
Here's a sample Excel-sheet that contains Receipt Vouchers of an Advertisement firm. Follow these steps to import Receipts Vouchers from this Excel-sheet in Tally Software.
1) Download the Excel sheet and copy it to "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted.
5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally.
UDIMagic is a simple and robust utility. It allows you to import any data from Excel into Tally including both Masters and Vouchers.
How does UDIMagic work ?
You may have Excel-sheet format with any type of Vouchers or Masters. UDIMagic can process it and send it to Tally within seconds.
UDIMagic uses XML tags to identify and read the Excel sheet data. End-users who are not familiar with XML tags, can take assistance of our professionals who provide XML tags for any type of data that you may have in your Excel-sheet.
The XML tags basically tell UDIMagic what data you have in you Excel sheet and where is it stored ? To get more information on XML tags, refer topic Understanding UDIMagic XML tags
Here's a sample Excel-sheet that contains Receipt Vouchers of an Advertisement firm. Follow these steps to import Receipts Vouchers from this Excel-sheet in Tally Software.
1) Download the Excel sheet and copy it to "c:\udi-magic" folder.
2) Start the Tally software and create/open a Dummy Company.
3) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted.
5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally.
UDIMagic is a simple and robust utility. It allows you to import any data from Excel into Tally including both Masters and Vouchers.
How does UDIMagic work ?
You may have Excel-sheet format with any type of Vouchers or Masters. UDIMagic can process it and send it to Tally within seconds.
UDIMagic uses XML tags to identify and read the Excel sheet data. End-users who are not familiar with XML tags, can take assistance of our professionals who provide XML tags for any type of data that you may have in your Excel-sheet.
The XML tags basically tell UDIMagic what data you have in you Excel sheet and where is it stored ? To get more information on XML tags, refer topic Understanding UDIMagic XML tags
Friday, February 29, 2008
UDIMagic v1.0 to retire from 31/3/2008
It has been an year since UDIMagic v1.0 was launched.
UDIMagic v1.0
UDIMagic v1.0 supported transfer of Masters data from Excel to Tally. It had limited functionality for even transferring the Master's data too. i.e. the fields were limited.
UDIMagic v2.0 and v3.0
Later on UDIMagic v2.0 was introduced which supported transfer of Vouchers from Excel to Tally.
UDIMagic v 3.0 followed which added support for VBA (Visual basic for Applications). It also supported all Tally features like Cost Centres; Cost Categories; Multiple Currencies; Multiple Godowns etc. The UDIMagic v3.0 also supports user-defined Voucher-types, and fields created using TDL (Tally Definition language).
In this fast-changing technology era, it has become crucial for us to concentrate on the latest technologies in order to make our products more robust and scalable. There have been several new releases for UDIMagic v3.0 till date, each one adding some new functionalities.
In view of the above, we have decided to withdraw support for UDIMagic v1.0 from 31/3/2008 only.
Users of UDIMagic v1.0 are adviced to upgrade to the latest version and reap the benefits of new functionalities.
UDIMagic v1.0
UDIMagic v1.0 supported transfer of Masters data from Excel to Tally. It had limited functionality for even transferring the Master's data too. i.e. the fields were limited.
UDIMagic v2.0 and v3.0
Later on UDIMagic v2.0 was introduced which supported transfer of Vouchers from Excel to Tally.
UDIMagic v 3.0 followed which added support for VBA (Visual basic for Applications). It also supported all Tally features like Cost Centres; Cost Categories; Multiple Currencies; Multiple Godowns etc. The UDIMagic v3.0 also supports user-defined Voucher-types, and fields created using TDL (Tally Definition language).
In this fast-changing technology era, it has become crucial for us to concentrate on the latest technologies in order to make our products more robust and scalable. There have been several new releases for UDIMagic v3.0 till date, each one adding some new functionalities.
In view of the above, we have decided to withdraw support for UDIMagic v1.0 from 31/3/2008 only.
Users of UDIMagic v1.0 are adviced to upgrade to the latest version and reap the benefits of new functionalities.
Sunday, February 24, 2008
UDIMagic DCP (Partners)
You can now buy UDIMagic from our Partners in your proximity.
Click here to view the UDIMagic Partners list.
Click here to view the UDIMagic Partners list.
Monday, February 4, 2008
How to get the Financial Year from a given Date ?
First of all, why do we require this thing ?
Let me clarify it. While importing Vouchers from Excel to Tally, we require a field which contains unique values. Normally, there is such a field (Invoice Number for Sales) which contains unique values. However, Invoice numbers are unique for a given year and the number restarts from 1 every year. This would create problems as the next year vouchers will overwrite the current year vouchers. Hence, we need to generate a unique value which is a combination of the "Invoice Number" and the "Financial Year".
Here's the Excel formula to get the FINANCIAL-YEAR from a given Date.
FORMULA
Example
1) To test the above formula, substitute the A# with the Excel-sheet Cell-reference (say A1).
2) To use this formula in UDI-Magic XML tags, you need to replace the special characters with their ESCAPE SEQUENCES.
Let me clarify it. While importing Vouchers from Excel to Tally, we require a field which contains unique values. Normally, there is such a field (Invoice Number for Sales) which contains unique values. However, Invoice numbers are unique for a given year and the number restarts from 1 every year. This would create problems as the next year vouchers will overwrite the current year vouchers. Hence, we need to generate a unique value which is a combination of the "Invoice Number" and the "Financial Year".
Here's the Excel formula to get the FINANCIAL-YEAR from a given Date.
FORMULA
=IF(AND(MONTH($A#)>=4,MONTH($A#)<=12),
YEAR($A#) & "-" & YEAR($A#)+1,YEAR($A#)-1 & "-" &YEAR($A#))Example
DATE FINANCIAL YEARRemarks:-
2007-04-01 2007-08
2008-04-01 2008-09
1) To test the above formula, substitute the A# with the Excel-sheet Cell-reference (say A1).
2) To use this formula in UDI-Magic XML tags, you need to replace the special characters with their ESCAPE SEQUENCES.
Wednesday, January 30, 2008
Ole Error 800A03EC
FAQs: Excel to Tally
"I am using udi-Magic to import Vouchers from Excel into Tally 9. While importing the data, udi-Magic shows an error message "Ole Error 800A03EC".
Solution:-
It is likely that you are using a FORMULA in the XML tags which is incorrect. In case if you are using several FORMULA's then you must test-check each FORMULA. This can be done by tying out the Formula directly in the MS-EXCEL sheet itself.
For Example, if the XML tags have a Formula as shown underneath:-
In the Excel sheet, enter the formula given underneath in any cell (say cell Z2).
=F2 & "/" & O2
You need to test-check each FORMULA that is used in your XML tags. If you get error message while testing the Formula in EXCEL, it means that Formula is incorrect.
Remarks:-
In XML, there are certain characters which have special meaning and are called ESCAPE SEQUENCES. You can get more information about Escape Sequences from this link:-
XML Escape sequences
In simple words, a formula used in Excel sheet is to be changed when used in XML tags as given underneath:-
Excel sheet formula:-
XML tags formula :-
"I am using udi-Magic to import Vouchers from Excel into Tally 9. While importing the data, udi-Magic shows an error message "Ole Error 800A03EC".
Solution:-
It is likely that you are using a FORMULA in the XML tags which is incorrect. In case if you are using several FORMULA's then you must test-check each FORMULA. This can be done by tying out the Formula directly in the MS-EXCEL sheet itself.
For Example, if the XML tags have a Formula as shown underneath:-
FORMULA="=F# & "/" & O#"You can test-check the above formula in EXCEL as given underneath:-
In the Excel sheet, enter the formula given underneath in any cell (say cell Z2).
=F2 & "/" & O2
You need to test-check each FORMULA that is used in your XML tags. If you get error message while testing the Formula in EXCEL, it means that Formula is incorrect.
Remarks:-
In XML, there are certain characters which have special meaning and are called ESCAPE SEQUENCES. You can get more information about Escape Sequences from this link:-
XML Escape sequences
In simple words, a formula used in Excel sheet is to be changed when used in XML tags as given underneath:-
Excel sheet formula:-
=F2 & "/" & O2
XML tags formula :-
FORMULA="=F# & "/" & O#"
Monday, January 28, 2008
UDI Magic Tutorials - Excel to Tally
Topic: Import UNIT Master data from Excel into Tally Software
This tutorial covers how to use UDIMagic utility to import UNIT Master records from MS-Excel into Tally Accounting Software.
Visit UDIMagic tutorials page at our site.
This tutorial covers how to use UDIMagic utility to import UNIT Master records from MS-Excel into Tally Accounting Software.
Visit UDIMagic tutorials page at our site.
Saturday, January 12, 2008
SQL Server to Tally Software
Tally Integration made Easy
New Release 1.3
udi-Magic v3.0 Release 1.3 [Professional] allows you to transfer data directly from MS SQL Server to Tally Accounting Software using few SQL-SELECT statements and XML tags.
Supports all versions of Microsoft SQL Server.
Click here for more details on MS SQL Server to Tally
Tuesday, January 8, 2008
XBase (DBF) to Tally Software
Tally Integration made Easy
New Release 1.2
udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags.
Supports
a) DBase
b) Fox 2.x
c) Visual Foxpro DBFs and DBC files
d) Other XBase file formats.
Click here for more details on XBase (DBF) to Tally
New Release 1.2
udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags.
Supports
a) DBase
b) Fox 2.x
c) Visual Foxpro DBFs and DBC files
d) Other XBase file formats.
Click here for more details on XBase (DBF) to Tally
Wednesday, January 2, 2008
Introducing udi-Magic v3.0 Professional version
Tally Integration made Easy
udi-Magic v3.0 Professional allows you to retrieve data from External databases and send it directly to Tally Software.
Useful for Software Developers
udi-Magic professional is particularly useful for Software Developers / programmers who wish to INTEGRATE their software with Tally Accounting Software. Instead of modifying the existing program code, Developers can integrate with Tally by merely writing few SQL-SELECT and XML tags.
Useful for End-Users
Users (i.e. end-users) who wish to Integrate software with Tally but do not have the source-code of the program can do it using udi-Magic professional. Full support is provided by for writing SQL-SELECT statements and XML tags for Tally Integration.
In the coming days/weeks, support for additional databases shall be included in the udiMagic professional version.
udi-Magic v3.0 Professional allows you to retrieve data from External databases and send it directly to Tally Software.
Useful for Software Developers
udi-Magic professional is particularly useful for Software Developers / programmers who wish to INTEGRATE their software with Tally Accounting Software. Instead of modifying the existing program code, Developers can integrate with Tally by merely writing few SQL-SELECT and XML tags.
Useful for End-Users
Users (i.e. end-users) who wish to Integrate software with Tally but do not have the source-code of the program can do it using udi-Magic professional. Full support is provided by for writing SQL-SELECT statements and XML tags for Tally Integration.
In the coming days/weeks, support for additional databases shall be included in the udiMagic professional version.
Introducing udiMagic v3.0
UDI-Magic in now available in two versions viz.
UDI-Magic v3.0 [Standard]
Supports transfer of data from Excel to Tally and vice versa. (i.e. push and pull Tally data from/to MS-Excel).
UDI-Magic v3.0 [Professional]
Supports transfer of data from external databases to Tally viz.
The professional version is a superset of the standard version and includes all the features of the standard version.
Other new features in udiMagic version 3.0
UDI-Magic v3.0 [Standard]
Supports transfer of data from Excel to Tally and vice versa. (i.e. push and pull Tally data from/to MS-Excel).
UDI-Magic v3.0 [Professional]
Supports transfer of data from external databases to Tally viz.
The professional version is a superset of the standard version and includes all the features of the standard version.
Other new features in udiMagic version 3.0
Subscribe to:
Posts (Atom)