53
edits
FAQ Custom reporting script EN: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(snippet) |
No edit summary |
||
| Line 4: | Line 4: | ||
The standard reporting in Dolibarr did not suit my needs so I created a custom one using a bash script. To use and adapt this script you should familiarize yourself with the columns of the table llx_accounting_bookkeeping as this is where your ledger is stored. | The standard reporting in Dolibarr did not suit my needs so I created a custom one using a bash script. To use and adapt this script you should familiarize yourself with the columns of the table llx_accounting_bookkeeping as this is where your ledger is stored. | ||
Before running this script, make sure you have committed all your transactions to the journal (Journalization). | Before running this script, make sure you have committed all your transactions to the journal (Journalization). This script was run on a Dolibarr 9.0.1 install, you might have to adapt it if using another version e.g. if the table or column names have changed. | ||
This outputs the total sale of year 2019 before taxes: | This outputs the total sale of year 2019 before taxes: | ||