Tuesday, August 25, 2009

How to export Party Name's and Addresses from Tally to MS-Excel

Tally to MS-Excel

Query
"How do I export the Party Names and their addresses from Tally to MS-Excel ?"

Ans:
You can get the aforesaid details in Tally using UDIMagic Free Edition.

Steps :-
1) Download and install UDIMagic from this link
http://www.rtslink.com/images/udimagic-free-edition-setup.zip

2) Use the following SELECT statement to retrieve Party Names and addresses.

Select $Name,$_Address1,$_Address2,$_Address3,$_Address4,$_Address5,
$StateName,$PinCode,$LedgerPhone,$Email,$ClosingBalance From LEDGER
where $IsChildOf:$GroupSundryDebtors

OR

Select $Name,$_Address1,$_Address2,$_Address3,$_Address4,$_Address5,
$StateName,$PinCode,$LedgerPhone,$Email,$ClosingBalance From LEDGER
where $IsBelongsTo:$GroupSundryDebtors

Remarks:-
The $$IsBelongsTo:$$GroupSundryDebtors function is used to retrieve Ledgers which fall directly under the group "Sundry Debtors" or sub-groups created under "Sundry Debtors"

No comments: