Ask, reply and learn. Join the community of Akaunting.
A absolute must have. Need to have a report that shows the taxable sales for a given date range. This is critical so people can correctly report and pay their taxes. Without this feature the whole system is not very useful for retail sales. The report needs to report all taxable items:
Example DML:
SELECT
rqu_taxes.name,
SUM( rqu_invoice_items.total ) AS `Taxable Amount`
FROM
rqu_invoices,
rqu_invoice_items,
rqu_taxes
WHERE rqu_invoices.invoiced_at
BETWEEN '2017-12-01 00:00:00' AND '2017-12-31 23:59:59'
AND rqu_invoices.invoice_status_code != 'draft'
AND rqu_invoices.deleted_at IS NULL
AND rqu_invoices.company_id = 2
AND rqu_invoice_items.company_id = rqu_invoices.company_id
AND rqu_invoice_items.deleted_at IS NULL
AND rqu_taxes.id = rqu_invoice_items.tax_id
GROUP BY
rqu_taxes.name
;
Tax Summary and more reports are coming in the next versions.
Showing 1 to 2 of 2 discussions