-- Apply Invoice and Quotation Form Updates with VAT Calculation
-- Run this script to update forms in the database
-- Date: 2025-11-27

\echo 'Updating Invoice Form (ID 9001) with VAT calculation...'
\i sql/migrations/add_invoice_form_declarative.sql

\echo 'Creating Quotation Form (ID 9002) with VAT calculation...'
\i sql/migrations/add_quotation_form_declarative.sql

\echo 'Forms updated successfully!'
\echo 'Invoice Form: Changed aggregate label from "Grand Total" to "Subtotal"'
\echo 'Quotation Form: Created with VAT calculation support'
\echo 'Both forms will now display: Subtotal, VAT (12.5%), and Grand Total'
