tally.erp

Alternate Units in Price List – Tally

There was a problem while using alternate units in Price List (upto Tally ERP 9 Release 3.2)

We had sent a query on this subject matter to Tally Solutions, Bangalore on 22nd March, 2011, which is given underneath for your reference :-

• I have created a Price Level named “Cash Price”. Next, I entered the rate for Price Level “Cash Price”  for Item “ABC” for 1-3-2011. This works fine. Next, I entered rate for “Cash Price” for Item “XYZ” which has alternate units. The “XYZ” details are as follows:-
  Base Units : Nos
  Alternate Units : Box (where 1 Box = 10 Nos)

  In the Price Level, I entered the rate for “Cash Price” level for Item “XYZ” as 800/Box. The entry is accepted. However, when we again view it from “Gateway of Tally >> Inventory Info >> Price Level”, the Price level rate is not shown for Item “XYZ”. Next, I exported the data using “Display >> List of Accounts >> StockItems” and found that the Rate is exported correctly in XML format i.e. 800/Box.

  In Brief
  Price Level rates when entered for Alternate Units (say 800/Box – where Box is alternate unit), the same is not displayed in “Gateway of Tally >> Inventory Info >> Price List”

Update

The aforesaid issue has now been resolved in Tally ERP 9 Release 3.3 (as intimated to us by Tally Solutions, Bangalore)

Tally ERP – Security Issues

Tally ERP Security

If more than one person has to work on the same Company in Tally, then you need to use the security features available in Tally. You can enable the security feature while creating a new Company or using the Company Alteration screen. Next, you can create any number of Users and assign them the user-rights as required. For example, you may disallow “Voucher alteration” or “Back-dated Voucher entry” for a specific user.

Security Issues

How secure is Tally ERP ? Can a user with only data-entry rights make changes or view reports which he/she is not allowed to do so ? Well, here are few lines of TDL code with which it  can be done :-

[#Menu : Gateway of Tally]
Add    : Item : Before : @@locQuit : Reset Security : Call : ResetSecurity

[Function : ResetSecurity]
10 : Modify Object : (Company,##SVCurrentCompany).IsSecurityOn : No
20 : MsgBox:"Tally Security":"The Security feature has been disabled now"

What happens with the above code ?

1) You get a new option in Gateway of Tally

When you start Tally ERP and open your Company, you get a new option in the Gateway of Tally. The new option “Reset Security” appears just above the QUIT option.

2) Using the new option, you can disable the Security features

Assuming, you are logged-in as a User with data-entry rights, you can use this option to disable the security feature itself. As you can see in the TDL code, this is done by setting the field  ISSECURITYON as NO. Thats all.

Next time when you start Tally ERP, open your Company and log-in as data-entry user, you can do anything, as security has been disabled.

In brief, a few lines of TDL code can be used to change the value in Tally database. i.e. to disable the security feature itself.

Update : 2011-09-29

Please see the comments for the response of Tally Solutions, Bangalore relating to the aforesaid subject matter.

PS:

If you are new to TDL, please refer this link for How to customize Tally using plain TEXT files ?

Merge two Ledgers in Tally.ERP 9

How to merge two Ledgers in Tally.ERP ?

Merging two Ledgers in Tally.ERP 9

It is assumed that you have two Ledgers viz “Ledger 1″ and “Ledger 2″ and you need to merge the “Ledger 2″ into “Ledger 1″ such that all the Vouchers having “Ledger 2″ would show “Ledger 1″ after the merge-process.

PS:
a) Take backup of your Tally data for safety purpose before trying out the underneath steps.
b) We have tested Merging of two Ledgers with Tally.ERP 9 Release 3.0 only

Step-by-step instructions:-

1. Change Tally.ERP 9 configuration settings
   a) Select option “Gateway of Tally >> F12 >> General”
   b) Set the option “Overwrite Vouchers during Import” to Yes
2. Set the period in Tally.ERP 9
   Select option “Gateway of Tally >> Alt+F2″ and set the period. Example if you have vouchers for three years, set the period accordingly so that the whole data is accessible.
3. Export Tally.ERP 9 data in XML
   a) Select option “Gateway of Tally >> Display >> Daybook >> Alt+F2″ and set the full-period
   b) Next, export Tally.ERP 9 data using “Alt+E” in XML format.
4. Make changes in XML data
   a) Open the file “Daybook.xml” in Notepad and find/replace all occurrences of the “Ledger 2″ with “Ledger 1″.
   Remarks: The file daybook.xml is created in step-3 on exporting data using Alt+E
   b) Save the Daybook.xml file
5. Import data in Tally.ERP 9
   a) Select option “Gateway of Tally >> Import of Data >> Vouchers”.
   b) Specify the file-name (ex: daybook.xml) and press enter to import it.
6. Verify the Vouchers in Tally.ERP 9
   Select option “Gateway of Tally >> Display >> Daybook” and check vouchers to verify the merging-process.

E-VAT Annual Return Form 205 for Gujarat

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.

Purchase Invoice with Cost Centre and Cost Category

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.

Recycle bin for Tally ERP 9

Download the Source code of Recycle bin for Tally ERP 9

Tally ERP 9 – Client without ODBC

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 :-

1. Start Tally ERP 9
2. Press Ctrl + K to invoke Control Centre feature
3. Enter your Tally.NET user id and password
4. Select the option “Licensing & configuration“
5. Select the option  “License Management“
6. Press F9 to select option “Gen Config List“
7. 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
8. Press Ctrl+A to save it.
9. Next, select “Gateway  of Tally >> F12 >> Licensing >> Update License”
10. 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.

Tally.ERP – Master Name and Alias

Master Name and Alias both must be unique in Tally.ERP.Those shifting from other software to Tally.ERP find this to grasp. Here are some common issues faced while migrating data from other softwares into Tally.ERP

Automobile Industry
In Automobile Industries, the Part Numbers are unique but the Stock-Item Name i.e. Part-Name may be duplicate. Example :-

Part Number   Part Name
1001             O-Ring
1002             O-Ring

Solution
To import such Master data into Tally, a work-around is to concatenate the “Name – PartNumber” as shown below :-

Part Number      Part Name
1001             O-Ring - 1001
1002             O-Ring - 1002

However, there are lot many other things that need to be taken care-of else you may spend lot of pulling your hair. Consider the following Stock Item Names :-

Part Name
Oil Can 1.5 Ltrs
Oil Can 15 ltrs

Are the aforesaid two Stock Items same ? No. The first is “1.5 ltrs” can whereas the second is “15 ltrs“. However, Tally ERP considers both as same. Try creating the above two Stock Items in Tally.ERP and you get message “Duplicate Entry” while trying to enter the second item.

In brief, there are several characters like dot (.), hash (-) , spaces which are ignored by Tally.ERP in Master Names and Alias. This is applicable to all Masters including Stock Item Masters.