Posts

Showing posts from October, 2014

Get Tally Ledger list in MS-Excel

Image
Global Help List | Get Tally Ledgers in Excel This feature allows you to get the Tally Ledger list in MS-Excel by pressing ~ (tilde key) You can activate or deactivate the Global Help List  feature using the "Settings" button in udiMagic. By default, it is disabled. The "Global Help List" feature provides a Help-list directly in MS-Excel or Word by simply pressing ~ (tilde key). It is useful in entering Ledgers; Stockitem-names in Excel or Word. Using the Global Help List Step 1 : Start udiMagic Step 2 : Start MS-Excel or Word Step 3 : Press ~    (i.e. tilde key without shift) This will bring forth the UDIMagic screen with Ledger Masters for the currently selected Company in Tally as shown below :- Step 4 : Type-in the Ledger Name and press enter-key to return to MS-Excel. Notes: You can click the Plus (+) button   next to the text-box to select any other Master or type in any SQL SELECT Statement. Example of SQL SELECT statements ...

INTRODUCING UDIMAGIC V6.0

We are pleased to announce the launch of UDIMagic v6.0. The details are as under :- UDIMagic v6.0 is now more Faster In-memory computing , a new technique is now used that makes processing and uploading of records into Tally much faster. For your reference, here are the results of uploading a sample Excel  Sheet with 5200 Voucher records using different versions of UDIMagic :   Version Time to upload (5200 Voucher records) Remarks UDIMagic v3.0 50 min 40 secs   UDIMagic v4.0 4 min 33 secs Bulk record processing feature introduced UDIMagic v5.0 3 min 10 secs Minor modifications UDIMagic v6.0 1 min 11 secs In-Memory Computing feature introduced Remarks: a) We uploaded the same Excel file  (5200 vouchers) into Tally using different versions of UDIMagic. b) System: Dell i3; 4 GB Ram, 1.80 GHz; Windows 8.1 64 bit c) UDIMagic v6.0 took 97.66 % le...

Excel #N/A error

While working in Excel, have you ever encountered  #N/A or #REF! or #VALUE! or any other error starting with # ? Here's a good article that provide details on why such errors appear in Excel. PS: You must remove all such errors from your Excel data before trying to import data into Tally.