From a5d3ddf6d512bc459cfa450c6b449c2e7a245373 Mon Sep 17 00:00:00 2001 From: Anders Betts Date: Fri, 18 Sep 2026 14:32:23 +0200 Subject: reports: Kapitas-style TUI tables, corrected moms rules (schema v3) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit The report views dumped JSON; they now render Saldobalans, Resultatrapport (previous-year column, 89xx bokfört/ej bokfört), Balansrapport (Ing balans/Ing saldo/Period/Utg balans, Beräknat resultat) and Momsrapport ruta för ruta, with Swedish amount formatting (1 234,56). The moms starter rules missed 33xx sales, sent reverse-charge VAT 2614 to box 10 instead of 30 and had box 48 positive. Rules may now share a box and report.vat sums them; box 49 is the sum of the moms boxes only. Schema v3 replaces the rules for existing orgs. Verified on a copy of the live DB: 05=703 200, 10=175 800, 20=1 453, 30=851, 48=-1 030, 49=175 621, matching the Kapitas 2027 export. Ctrl+R reload passes --socket and auto-login no longer rewrites tui.conf; pty tests now run through scripts/tui-sandbox.sh so they cannot touch the real config, cache or bw session. --- docs/SCHEMA.md | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'docs/SCHEMA.md') diff --git a/docs/SCHEMA.md b/docs/SCHEMA.md index 4b22271..db03e43 100644 --- a/docs/SCHEMA.md +++ b/docs/SCHEMA.md @@ -393,6 +393,11 @@ is editable by owners when Skatteverket changes the blankett. The seed rules are data, not code: the system ships a reviewed default set per fiscal year and keeps older sets for older years. +Several rules may target the same `box`; `report.vat` sums them into one entry +per box. Ruta 49 is the sum of the payable boxes only (`10`,`11`,`12`,`30`, +`31`,`32`,`48`,`60`,`61`,`62`); the other boxes are underlag and never change +what is payable. + ### 10.1 Voucher templates (schema v2) Konteringsmallar: named sets of rows with a formula over the variable `x`. @@ -459,7 +464,8 @@ another voucher is posted in between) — clients must not persist it. ## 12. Migrations and versioning - `meta(key TEXT PRIMARY KEY, value TEXT)` holds `schema_version` (integer) - and `created_at`. Current version: **2** (v2 adds the two template tables). + and `created_at`. Current version: **3** (v3 replaces the seeded moms rules + with the corrected mapping; v2 adds the two template tables). - Migrations are forward-only, applied automatically at daemon start, each in one transaction, and require an automatic `VACUUM INTO` snapshot next to the database before starting (`bokfd.db.pre-migration-`). -- cgit v1.3