fix(dbt): period_net_amount = debit minus credit

Open-source Excel-native EPM and consolidation for SAP & Dynamics

Brought to you by: konsolid-at

Status: closed

Owner: nobody

Labels: None

Updated: 2026-06-21

Created: 2026-06-21

Creator: Anonymous

Private: No

Originally created by: grynn-in

Change base_measures.period_net_amount from sum(accounting_currency_amount) to sum(debit_amount) - sum(credit_amount).
Fixes D365-shaped data where amounts are unsigned and IsCredit splits debit/credit magnitudes.

New dbt test assert_period_net_equals_debit_minus_credit.sql (fails on stale gold until full refresh — expected)

konsol: https://github.com/grynn-in/konsol/pull/38 (snapshot hotfix + measure fixture)

Requires governed dbt build on demo after merge.