aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_check_tax_invoice_issued
Parameters
Name
Type
Mode
folio_id
integer
IN
Definition
BEGIN IF fn_intf_param('SALESTAX', 'FORCE_ISSUE_TAX', FALSE) AND EXISTS(SELECT 1 from sp_get_vat_info($1) v WHERE not v.closed and v.vatable <> 0) THEN RAISE EXCEPTION SQLSTATE '99999' USING detail = fn_result_error('30311', 'There are tax invoice(s) need to be issued'); END IF; END;