How do I disable Service Tax rounding-off in Tally ERP 9 ?
If you are using Service Tax feature in Tally ERP 9, you may have faced the issue of Rounding-off of the EduCess and HigherSecEduCess values. To disable automatic round-off (which is default setting), follow these steps :-
1) Select the option “Gateway of Tally > F11 > Statutory & Taxation”.
2) Next, set the option “Enable Service Tax” to Yes
3) Next, set the option “Set/Alter Service Tax details” to Yes.
4) Next, set the option “Enable Service Tax Round off” to No.
For programmers:-
While programmatically pushing data, ensure that the tag ZERORATED is set to Yes .i.e. <ZERORATED>Yes</ZERORATED>
Tally ERP 9 includes the VAT format for Annual Return for Gujarat State viz Form 205. However, the corresponding E-VAT format for Form 205 is NOT available in Tally ERP 9 Release 3.1. This has been confirmed by Tally Solutions, Bangalore.
Recently on of our Clients raised the following issue :-
While entering Purchase entry with stockitems (in Invoice mode) in Tally ERP 9, we are unable to select / specify the Cost Category and Cost Centre as it can be done in Sales entry with stockitems (in Invoice mode).
On analysis, we found that in Purchase entry with stockitems (in Invoice mode), the Cost Category and Cost Centre allocation dialog box does NOT appear. However, it appears in (Voucher mode).
Prima facie this appears to be an issue with Tally Software. The Cost Category / Cost Centre dailog box should appear in Purchase entry with stockitems as it works in Sales entry with stockitems.
Here’s a XQUERY STATEMENT to get the Ledger Names and Amount from XML generated from Tally Software.
for $row in (//ENVELOPE/BODY/IMPORTDATA/REQUESTDATA/TALLYMESSAGE/VOUCHER)
let
$vchtype := ($row/VOUCHERTYPENAME),
$vchdate := ($row/DATE)
return
<voucher>
<vchtype>{data($vchtype)}</vchtype>
<date>{data($vchdate)}</date>
{
for $ledgername in distinct-values($row/descendant::LEDGERNAME)
let $amount := (sum($row/descendant::LEDGERNAME[.=$ledgername]/parent::node()/AMOUNT))
return
<row>
<ledger>{$ledgername}</ledger>
<amount>{$amount}</amount>
</row>
}
</voucher>
Download the Source code of Recycle bin for Tally ERP 9
Unable to connect to Tally ERP 9
In the last few days, several of our clients have reported the problem that they are unable to connect to Tally ERP 9 using UDIMagic.
On further analysis, we noticed the following :-
1) The Configuration box in the Gateway of Tally shows “Client without ODBC”
2) On using the option “Gateway of Tally >> F12 >> Advanced Configuration”, the options viz “Tally is acting as” and “Enable ODBC Server” are disabled.
To resolve the aforesaid issue, follow the underneath steps :-
- Start Tally ERP 9
- Press Ctrl + K to invoke Control Centre feature
- Enter your Tally.NET user id and password
- Select the option “Licensing & configuration“
- Select the option “License Management“
- Press F9 to select option “Gen Config List“
- Next, specify the values for the options as shown underneath :-
a) Tally is acting as = Server
b) Enable ODBC Server = Yes
Port = 9000
Can be overridden locally = Yes
- Press Ctrl+A to save it.
- Next, select “Gateway of Tally >> F12 >> Licensing >> Update License”
- Next, restart Tally ERP 9.
After following the aforesaid steps, the Configuration Box in Gateway of Tally must display Server with ODBC on Port 9000
In case, if the problem still remains, kindly report the issue to Tally Solutions, Bangalore with your Tally Serial Number.
Remarks:-
The aforesaid issue has been brought to our notice by our Customers within India and outside India.
It appears that some changes have been done by Tally Solutions, Bangalore relating to “Control Centre” default settings at their end which has caused this issue.
How to export Party addresses from Tally to Excel ?
Refer this link for exporting Party addresses from Tally into Excel.
How to merge data in Tally.ERP 9 ?
Assuming, you have two companies viz Company No 1 and Company No 2 and you wish to transfer all the data of Company No 1 into Company No 2.
Steps :-
- Open Company No 1 and Export data from Tally ERP 9 in XML format including dependent masters
a) Use option “Gateway of Tally >> Display >> Daybook”
b) Set the period using Alt+F2
c) Next, press Alt+E to export the Tally.ERP 9 data into XML format including dependent masters.
d) This will generate a file named “daybook.xml” in the Tally folder.
- Open Company No 2 and Import data into Tally.ERP 9 in Company No 2
a) Use option “Gateway of Tally >> Import of data >> Vouchers”
b) Specify the file-name as “daybook.xml” and press enter to import data into Tally.ERP 9
Remarks:-
a) Take backup of your Tally Companies before merging for safety purpose.
b) After merge, the Company No 2 contains the data of Company No 1
c) The above has been tested with Tally.ERP 9 Release 3.0 with some test-data.
Merging in Tally.ERP 9 vs Tally 9
Tally.ERP 9 Release 3.0 provides an option to export vouchers along with the dependent masters. Hence, there is no need to separately export the masters as it was required previously.
Related Posts :-
How to copy / paste entries from one company into another by ApniTally
How can I export Tally data into Excel ?
You can use Tally ODBC feature supported by Tally Accounting software to get data from Tally into Excel. Alternatively, you can use this FREE Tally to Excel utility to get Tally data into Excel.
Supported Tally versions : Tally.ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3
Remarks:-
Tally ODBC does not expose all the fields of all tables / objects in Tally. Hence, you will be able to retrieve only the first level fields (limited fields) from Tally database tables / objects.
How do I create a new field in Tally ERP 9 or other Tally versions ?
You can create new fields in Tally by writing TDL code in plain text file. Adding new fields or UDFs (User defined fields) is quite simple.
Here’s an article that teaches you how to create new fields in Tally.
To use the TDL code, you must specify the file-name in the Tally.ini file – refer Tally Customization using plain text files.
