X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/11a04bd50f0ec94871c75834b8b9497df46f5357..4858eee496c36d20673f0e2bcb680abc887fb8ba:/sql/Pg-upgrade2/konjunkturpaket_2020_SKR03.sql diff --git a/sql/Pg-upgrade2/konjunkturpaket_2020_SKR03.sql b/sql/Pg-upgrade2/konjunkturpaket_2020_SKR03.sql index 8925d10c4..8ff52d69d 100644 --- a/sql/Pg-upgrade2/konjunkturpaket_2020_SKR03.sql +++ b/sql/Pg-upgrade2/konjunkturpaket_2020_SKR03.sql @@ -34,6 +34,9 @@ IF ( select coa from defaults ) = 'Germany-DATEV-SKR03EU' THEN INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8732','Gewährte Skonti 5% USt','A', 'I', 'AR_paid', 2, 1, null,1, 't'); + INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_bwa, pos_bilanz, pos_eur, datevautomatik) + VALUES ('3732','Erhaltene Skonti 5 % Vorsteuer','A', 'E', 'AP_paid', 8, 4, null, null, 't'); + -- SKR03 -- datev reactivated the previously reserved chart 1775 in 2020, but it still exists in kivitendo (at least for SKR03) with a taxkey starting from 2007 and pointing to the existing automatic tax chart 1775 -- so we don't need to to anything!