Welcome to Marg Care - Marg ERP 9+

Home > Margerp > Other Reports > How to Export Ledger with Telephone and Address Detail in Excel Format in Marg Software ?

How to Export Ledger with Telephone and Address Detail in Excel Format in Marg Software ?

4521

Ans.1

In order to export ledgers with Telephone & Address, the user will follow the below steps:

  • Go to Reports > Other reports > Telephone/Address/Label.

  • A 'Select Group' window will appear.
  • Select group then press 'Enter' on it.
  • Suppose select 'Sundry Debtors'.

  • A 'Control Box' window will appear with some options which are mentioned below:

a. Selected Station: Select 'Yes', if the report needs to be viewed for a particular station.

b. Selected Party: Select 'Yes', if the report needs to be viewed for a particular party.

c. Selected Area: Select 'Yes', if the report needs to be viewed for a particular Area.

d. Selected M.R.: Select 'Yes', if the report needs to be viewed for a particular M.R..

e. Selected Route: Select 'Yes', if the report needs to be viewed for a particular Route.

Keep pressing 'Enter' on it.

  • Press 'Alt+P'.

  • A 'Print' window will appear.
  • Select 'Export -> Excel'.

  • Then an 'Export to Excel' window will appear in which the user can view the path where the excel will be exported.
  • The user can change the path of the report as per the requirement(If required).
  • Click on 'Accept'.

After following the above steps, the ledger report will get export with telephone number and address.

Ans.2

1. Go to Masters > Ledger Master > Modify Ledger.

2. A 'Ledger Alternation' window will appear. Press 'Alt+P'.

3. A 'Print List' window will appear. In 'Contact-Y/ Address/ No' option, the user will select "Add".

4. Then click on Excel/ View/ Print as per the requirement.


Submit Feedback