With our script customreports.pl and some knowledge of sql-ledger database, you can create custom reports without much effort and which are integrated directly into sql-ledger.
customreports.pl is minimal Perl code required to build and integrate a custom report into sql-ledger.
1. Download customreports.perl, rename to customreports.pl and copy to ./sql-ledger/bin/mozilla/ folder.
2. Create a gateway script in ./sql-ledger/ folder by copying any existing gateway script. For example:
$ cp gl.pl customreports.pl
3. Create or edit your custom_menu.ini and add the following lines:
[Custom Reports] [Custom Reports--Customer List] module=customreports.pl action=customer_search
4. Optionally run 'perl locale.pl' in your language folder if you are not using the default English language.
You are done.
This sample report consists of two procedures, 'customer_search' and 'customer_report'.
customer_search displays a basic criteria form and when the user clicks the Continue button, customer_report displays the data.
Once you have installed this sample report, you can modify it to suite your own needs. To modify this report, you need some knowledge of SQL. See sql queries for some sample sql statements you can use to build new reports.
To create more reports, just copy these two procedures (customer_search, customer_report) within the same .pl file and rename them accordingly. Put your SQL statement and make other changes. A working report should be ready within 5-15 minutes.
Too difficult for you? We can build a custom report based on customreports.pl. Email us at sales@ledger123.com for details.