Go to “Inquiry >> Financial >> Analytical Accounting >> Distribution Query” and select “Query Maintenance”.
Click next and fill the ID and the name of the query:
Click next and select the needed columns:
Click Next and filter your data as needed, you could select any column to filter except the date which will be filtered later.
Click next and insert the order of the data sorting if you have a special sort order:
Now you are ready to filter your data based on the date or period and generate the report, just make sure you checked “Execute Query” and your report will be generated:
Next time you need to run this report, just select “Execute Existing Query” option from the first screen:
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
No comments:
Post a Comment