53
edits
Changes
no edit summary
Line 26:
Line 26:
Adjust short_code_for_sell_journal (defaults to VT), sales_account_number and the DATE/DAT to the year you want.
sudo su postres
sudo su postres
# save the script to a file where postgres can write
# save the script to a file where postgres can write
− cd ~ && nano report.sh (paste the content and adapt to your database)
+ cd ~ && nano report.sh (paste the content and adjust the short_code_for_sell_journal (defaults to VT), sales_account_number and the DATE/DAT to the year you want)
# give run permissions
# give run permissions
chmod +x report.sh
chmod +x report.sh
# run the script
# run the script
./report.sh
./report.sh
−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.