Revision 67d95a83
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 | ||
|---|---|---|
| 666 | 666 |
'Cleared Balance' => 'abgeschlossen', |
| 667 | 667 |
'Cleared/uncleared only' => 'Status abgeglichen', |
| 668 | 668 |
'Clearing Tax Received (No 71)' => 'Verrechnung des Erstattungsbetrages erwünscht (Zeile 71)', |
| 669 |
'Clearing account for advance payments' => 'Verrechnungskonto für Anzahlungen', |
|
| 669 | 670 |
'Client' => 'Mandant', |
| 670 | 671 |
'Client #1' => 'Mandant #1', |
| 671 | 672 |
'Client Configuration' => 'Mandantenkonfiguration', |
| locale/en/all | ||
|---|---|---|
| 666 | 666 |
'Cleared Balance' => '', |
| 667 | 667 |
'Cleared/uncleared only' => '', |
| 668 | 668 |
'Clearing Tax Received (No 71)' => '', |
| 669 |
'Clearing account for advance payments' => '', |
|
| 669 | 670 |
'Client' => '', |
| 670 | 671 |
'Client #1' => '', |
| 671 | 672 |
'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