Making Custom Reports
There are three kind of reports in iVendNext.
1. Report Builder
Report Builder is an in-built report customization tool in iVendNext. This allows you to define specific fields of the form which shall be added in the report. Also you can set required filters, sorting and give preferred names to report.
2. Query Report
Query Report is written in SQL which pulls values from the account's database and displays the same in the report. Though SQL queries can be written from the front end, like HTML, it has been restricted for iVendNext cloud users. This is because it allows users with no access to specific reports to fetch data directly from the database. Check Purchase Order Item to be Received report in Stock module for example of a Query report.
3. Script Report
Script Reports are written in Python and stored on the server side. These are complex reports which involve logic and calculation. Since these reports are written on the server side, customizing it from a hosted account is not possible. Check the Financial Analytics report in Accounts module for an example of Script Report.
Dynamic Filter is available in Script Reports and Query Reports; however, not in the Report Builder.