Files
invoice-system/migrations/add-sales-tax-periods-status.sql
2026-05-31 13:03:27 -05:00

3 lines
163 B
SQL

ALTER TABLE sales_tax_periods ADD COLUMN status VARCHAR(20) DEFAULT 'open';
UPDATE sales_tax_periods SET status = 'booked' WHERE qbo_journal_entry_id IS NOT NULL;