Revision 341e134e
Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt
SL/DB/MetaSetup/Default.pm | ||
---|---|---|
15 | 15 |
address_street1 => { type => 'text' }, |
16 | 16 |
address_street2 => { type => 'text' }, |
17 | 17 |
address_zipcode => { type => 'text' }, |
18 |
advance_payment_clearing_chart_id => { type => 'integer' }, |
|
18 | 19 |
allow_new_purchase_delivery_order => { type => 'boolean', default => 'true', not_null => 1 }, |
19 | 20 |
allow_new_purchase_invoice => { type => 'boolean', default => 'true', not_null => 1 }, |
20 | 21 |
allow_sales_invoice_from_sales_order => { type => 'boolean', default => 'true', not_null => 1 }, |
locale/de/all | ||
---|---|---|
669 | 669 |
'Cleared Balance' => 'abgeschlossen', |
670 | 670 |
'Cleared/uncleared only' => 'Status abgeglichen', |
671 | 671 |
'Clearing Tax Received (No 71)' => 'Verrechnung des Erstattungsbetrages erwünscht (Zeile 71)', |
672 |
'Clearing account for advance payments' => 'Verrechnungskonto für Anzahlungen', |
|
672 | 673 |
'Client' => 'Mandant', |
673 | 674 |
'Client #1' => 'Mandant #1', |
674 | 675 |
'Client Configuration' => 'Mandantenkonfiguration', |
locale/en/all | ||
---|---|---|
669 | 669 |
'Cleared Balance' => '', |
670 | 670 |
'Cleared/uncleared only' => '', |
671 | 671 |
'Clearing Tax Received (No 71)' => '', |
672 |
'Clearing account for advance payments' => '', |
|
672 | 673 |
'Client' => '', |
673 | 674 |
'Client #1' => '', |
674 | 675 |
'Client Configuration' => '', |
sql/Pg-upgrade2/defaults_advance_payment_clearing_chart_id.sql | ||
---|---|---|
1 |
-- @tag: defaults_advance_payment_clearing_chart_id |
|
2 |
-- @description: Voreingestelltes Konto für Verrechnung von Anzahlungen |
|
3 |
-- @depends: new_chart_1593_1495 |
|
4 |
|
|
5 |
ALTER TABLE defaults ADD COLUMN advance_payment_clearing_chart_id INTEGER; |
|
6 |
|
|
7 |
DO $$ |
|
8 |
BEGIN |
|
9 |
|
|
10 |
IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR03EU' THEN |
|
11 |
DECLARE |
|
12 |
clearing_accno text := '1593'; |
|
13 |
|
|
14 |
BEGIN |
|
15 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN |
|
16 |
UPDATE defaults SET advance_payment_clearing_chart_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno); |
|
17 |
END IF; |
|
18 |
END; |
|
19 |
END IF; |
|
20 |
|
|
21 |
IF ( SELECT coa FROM defaults ) = 'Germany-DATEV-SKR04EU' THEN |
|
22 |
DECLARE |
|
23 |
clearing_accno text := '1495'; |
|
24 |
|
|
25 |
BEGIN |
|
26 |
IF ( SELECT COUNT(accno) FROM chart WHERE accno LIKE clearing_accno ) = 1 THEN |
|
27 |
UPDATE defaults SET advance_payment_clearing_chart_id = (SELECT id FROM chart WHERE accno LIKE clearing_accno); |
|
28 |
END IF; |
|
29 |
END; |
|
30 |
END IF; |
|
31 |
|
|
32 |
END $$; |
templates/webpages/client_config/_default_accounts.html | ||
---|---|---|
55 | 55 |
<td>[% P.chart.picker('defaults.ar_chart_id', SELF.defaults.ar_chart_id, type='AR', choose=1, style=style) %]<td> |
56 | 56 |
</tr> |
57 | 57 |
|
58 |
<tr> |
|
59 |
<td align="right">[% LxERP.t8("Clearing account for advance payments") %]</td> |
|
60 |
<td>[% P.chart.picker('defaults.advance_payment_clearing_chart_id', SELF.defaults.advance_payment_clearing_chart_id, choose=1, style=style) %]<td> |
|
61 |
</tr> |
|
62 |
|
|
58 | 63 |
<tr> |
59 | 64 |
<td align="right">[% LxERP.t8("Account for workflow from purchase order to ap transaction") %]</td> |
60 | 65 |
<td>[% P.chart.picker('defaults.workflow_po_ap_chart_id', SELF.defaults.workflow_po_ap_chart_id, type='AP_amount', choose=1, style=style) %]<td> |
Auch abrufbar als: Unified diff
Anzahlungs-Rg.: Standardkonto-Auswahl f. Verrechnungskonto