Revision f15d195e
Von Jan Büren vor mehr als 1 Jahr hinzugefügt
sql/Pg-upgrade2/add_link_for_fx_gain_loss_charts.sql | ||
---|---|---|
1 |
-- @tag: add_link_for_fx_gain_loss_charts |
|
2 |
-- @description: Kursdifferenzen am Beleg buchen benötigt Aufnahme in Zahlungs-Dropdown |
|
3 |
-- @depends: release_3_8_0 |
|
4 |
|
|
5 |
|
|
6 |
DO $$ |
|
7 |
BEGIN |
|
8 |
|
|
9 |
IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN |
|
10 |
DECLARE |
|
11 |
gain_chart text := '2660'; |
|
12 |
loss_chart text := '2150'; |
|
13 |
|
|
14 |
BEGIN |
|
15 |
UPDATE chart set link ='AR_paid:AP_paid' where accno in (gain_chart, loss_chart); |
|
16 |
END; |
|
17 |
END IF; |
|
18 |
|
|
19 |
IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN |
|
20 |
DECLARE |
|
21 |
gain_chart text := '4840'; |
|
22 |
loss_chart text := '6880'; |
|
23 |
BEGIN |
|
24 |
UPDATE chart set link ='AR_paid:AP_paid' where accno in (gain_chart, loss_chart); |
|
25 |
END; |
|
26 |
END IF; |
|
27 |
|
|
28 |
END $$; |
Auch abrufbar als: Unified diff
Vergessene chart.links für fx_gain_loss bei deutschen SKR* hinzufügen