Changes

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:

DAT="19"

DAT="19"

PSQL="psql -d dolibarr -U dolibarr -t -c"

PSQL="psql -d dolibarr -U dolibarr -t -c"

c3000="select sum(credit) from llx_accounting_bookkeeping where code_journal = \

SALES="select sum(credit) from llx_accounting_bookkeeping where code_journal = \

'short_code_for_sell_journal' and numero_compte = 'sales_account_number'  and doc_date <= '12/31/$DAT' and doc_date >= '\

'short_code_for_sell_journal' and numero_compte = 'sales_account_number'  and doc_date <= '12/31/$DAT' and doc_date >= '\

01/01/$DAT'"

01/01/$DAT'"

echo

echo

echo  -n "Total sales before taxes:"

echo  -n "Total sales before taxes:"

$PSQL "$c3000"

$PSQL "$SALES"

</pre>

</pre>

This can be expanded very easily to output very long and detailed reports.

This can be expanded very easily to output very long and detailed reports.