Tax Liability Report won't generate Blesta 4.3.2

[WebhostingNZ.com]

Hi,

Using the admin area we are not able to generate a Tax Liability report.  I have tested this on a fresh 4.3.2 install and the same error is reported.  Below is the error.  This happens when you select either CSV or JSON

PHP version 5.6, MySQL version 5.6 and MariaDB 10.2, both servers running cPanel (test server and live server both have this error)

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'temp.id' in 'order clause' on line 196 in /home/<username>/public_html/vendors/minphp/db/src/PdoConnection.php 

Printing Stack Trace: 
#0 /home/<username>/public_html/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array)
#1 /home/<username>/public_html/vendors/minphp/record/src/Record.php(804): Minphp\Db\PdoConnection->query('SELECT temp.*, ...', Array)
#2 /home/<username>/public_html/components/reports/tax_liability/tax_liability.php(206): Minphp\Record\Record->getStatement()
#3 /home/<username>/public_html/app/models/report_manager.php(199): TaxLiability->fetchAll('6', Array)
#4 /home/<username>/public_html/app/controllers/admin_reports.php(41): ReportManager->fetchAll('tax_liability', Array, 'csv')
#5 /home/<username>/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php(143): AdminReports->index()
#6 /home/<username>/public_html/index.php(21): Dispatcher::dispatch('/admin/reports/')
#7 {main}

 

[Tyson]

Thanks. This is fixed in CORE-2813 for v4.4.0.

In the interim, you can patch this yourself by updating /components/reports/tax_liability/tax_liability.php
Find the following line:

'invoices.subtotal', 'invoices.currency', 'invoices.date_closed',

Replace it with:

'invoices.id', 'invoices.subtotal', 'invoices.currency', 'invoices.date_closed',