Pages

Wednesday, October 22, 2014

Get Tally Ledger list in MS-Excel

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
a) To get list of Cost Centre Masters (ensure that you type COSTCENTRES and not COSTCENTRE)
SELECT $NAME FROM COSTCENTRES

b) To get list of Cost Categories
SELECT $NAME FROM COSTCATEGORY

c) To get list of Ledger Names and Aliases
SELECT $NAME,$$ALIAS FROM LEDGER

d) To get list of Ledgers under group Sundry Debtors and its sub-groups
SELECT $NAME FROM LEDGER WHERE $$ISBELONGSTO:$GROUPSUNDRYDEBTORS

e) To get list of Ledgers under group Sundry Debtors only
SELECT $NAME FROM LEDGER WHERE $PARENT=$GROUPSUNDRYDEBTORS

f) To get StockItem Names
SELECT $NAME FROM STOCKITEM

g) To get StockItem Name and Part Number
 SELECT $NAME,$MAILINGNAME FROM STOCKITEM

No comments: