Forum

Report: Taxable Sales (absolute must have)

Posted in CategoryIdeas
  • Van Stokes    ( User ) 2 years ago

    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
    ;


     

  • Denis Duliçi    ( Admin ) 2 years ago

    Tax Summary and more reports are coming in the next versions.

Please login or register to leave a response.