Pages

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 Free Edition from this link
http://download.cnet.com/UDI-Magic-Free-Edition/3000-2066_4-77717736.html

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: