Sales Tax Liability report

[web2008]

The latest Sales Tax Liability report does not show the date range on the printable version.

Anyone know how to include this in the report?

Otherwise, this report is still incorrect ( version 8.2 ), as it shows Add Funds invoice as sales.

[brian!]

On 09/08/2021 at 00:12, web2008 said:

Anyone know how to include this in the report?

quick change...

$reportdata["headertext"] .= "<br>$numinvoices Invoices Found<br><B>Total Invoiced:</B> ".formatCurrency($total)." &nbsp; <B>Tax Level 1 Liability:</B> ".formatCurrency($tax)." &nbsp; <B>Tax Level 2 Liability:</B> ".formatCurrency($tax2)."<br><b>".$dateRangeText.": </b>".fromMySQLDate($queryStartDate,false)." - ".fromMySQLDate($queryEndDate,false);

as always, don't edit the original .php file (it will get replaced during an update) - so duplicate and edit that.

On 09/08/2021 at 00:12, web2008 said:

Otherwise, this report is still incorrect ( version 8.2 ), as it shows Add Funds invoice as sales.

could you not remove the "Add Funds" line from the SQL query in the report?

            $join
                ->On('tblinvoiceitems.type', '=', Capsule::raw('"Invoice"'));

[web2008]

Thank you brian! - Date Range works fine!

Else, when I remove the "Add Funds" lines (2) the report still shows Add Funds as sales.