From 622319e0a67971ef076bd39dca18622907aca055 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Mon, 8 Nov 2021 12:51:43 +0100 Subject: [PATCH] Anzahlungs-Rg.: Neue Konten f. Verrechnung erhaltener Anzahlungen (SKR03/04) --- sql/Pg-upgrade2/new_chart_1593_1495.sql | 37 +++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 sql/Pg-upgrade2/new_chart_1593_1495.sql diff --git a/sql/Pg-upgrade2/new_chart_1593_1495.sql b/sql/Pg-upgrade2/new_chart_1593_1495.sql new file mode 100644 index 000000000..5a512ba34 --- /dev/null +++ b/sql/Pg-upgrade2/new_chart_1593_1495.sql @@ -0,0 +1,37 @@ +-- @tag: new_chart_1593_1495 +-- @description: Neue Konten "Verrechnungskonto erhalt. Anzahl. bei Buchung über Debitorenkonto" +-- @depends: release_3_5_8 + + +DO $$ +BEGIN + + IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN + DECLARE + new_accno text := '1593'; + + BEGIN + IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE new_accno ) = 0 THEN + INSERT INTO chart (accno, description, charttype, category, link, taxkey_id) + VALUES (new_accno, 'Verrechnungskonto erhalt. Anzahl. bei Buchung über Debitorenkonto','A', 'L', 'AR', 0); + INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, startdate) + VALUES ((SELECT id FROM chart WHERE accno LIKE new_accno), 0, 0, '1970-01-01'); + END IF; + END; + END IF; + + IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN + DECLARE + new_accno text := '1495'; + + BEGIN + IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE new_accno ) = 0 THEN + INSERT INTO chart (accno, description, charttype, category, link, taxkey_id) + VALUES (new_accno, 'Verrechnungskonto erhalt. Anzahl. bei Buchung über Debitorenkonto','A', 'L', 'AR', 0); + INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, startdate) + VALUES ((SELECT id FROM chart WHERE accno LIKE new_accno), 0, 0, '1970-01-01'); + END IF; + END; + END IF; + +END $$; -- 2.20.1