Konjunkturpaket - SKR03 neues Konto Skonti 5%

[mfinanz.git] / 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 8925d10c49f2063a99174182cac133d01a4f14ce..8ff52d69d9d3b9bf1d1faf5b98467d87794c15c6 100644 (file)
--- 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!