In tally pakage how can I export Debtors list with name & address
In tally pakage how can I export Debtors list with name & address
You just need to go to the data screen and their you have to press Alt+e keys on keyboard or just click on export on top of the screen, then an export screen will popup and will come up, if you press N key on the keyboard then you can also get the customize key, whether you are on a .xml file or .xls file, just try out and let us know.
You can also download and install UDIMagic software by searching it on google. After that you need to use the below SELECT statement to retrieve party names and addresses if you want:
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
You just need to go to Gateway of Tally > Display > List of Accounts
- In the List of Accounts screen press E : Export.
- Select the Language in which you want the data to be exported.
- Select a format from the list of Formats available.
- Press Enter to accept the default Output Filename. In case you want to save the file in another folder then type the desired path and filename.
- Accept to export the Masters to a XML format file.
Bookmarks