Welcome to Marg Care - Marg ERP 9+

Home > Margerp > Sql Query > How to view party report with anniversary date,date of birth, and mobile number ?

How to view party report with anniversary date,date of birth, and mobile number ?

630

Ans.1

Follow the below steps to view party report with Anniversary date,date of birth and mobile number:-

1. Go to Master > Marg Setup > Advance Features > Report SQL Query > SQL query window will appear then user will click on Add New.

2. Then feed code according to the requirement > Modify Query in Executor---"Yes" > Type Query as SELE SCODE,PARNAM,CSTDATE,STDATE,PHONE4 FROM ORDER > Then click on Save.

3. Then click on Exit and click on sure to exit select yes .

4. Then go to Daily Report > SQL Query Executor > SQL Query Executor window will appear then user will select code from drop down and click on Execute Query > A report will be appear > Then select save format i.e. DBF,CSV,Excel etc. according to the requirement.


Submit Feedback