From e8d3bc67310c9326192088ad3ef50c7959caa004 Mon Sep 17 00:00:00 2001 From: Udo Spallek Date: Tue, 20 Feb 2007 23:19:38 +0000 Subject: [PATCH] USTVA Buchungsgruppe Inland: Konten angepasst und getestet USTVA IST und Soll Versteuerung: Querys angepasst und getestete USTVA Testscript Bugfix 526. --- SL/USTVA.pm | 263 +- ...va_setup_2007_update_chart_taxkeys_tax.sql | 377 +++ t/selenium/incomming/ustva-Inland-linet.html | 2116 +++++++++++++++++ 3 files changed, 2637 insertions(+), 119 deletions(-) create mode 100644 sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql create mode 100644 t/selenium/incomming/ustva-Inland-linet.html diff --git a/SL/USTVA.pm b/SL/USTVA.pm index 31b13bd03..4ac3c1a2c 100644 --- a/SL/USTVA.pm +++ b/SL/USTVA.pm @@ -598,12 +598,8 @@ sub ustva { $form, $category); - # 16%/19% Umstelung - # Umordnen der Kennziffern und abfangen von Fehlern - -# $form->header; -# print $form->{81}; - + # 16%/19% Umstellung + # Umordnen der Kennziffern if ( $form->{year} < 2007) { $form->{35} += $form->{81}; $form->{36} += $form->{811}; @@ -618,6 +614,7 @@ sub ustva { map { delete $form->{$_} } qw(51 511 97 971); } + # # Berechnung der USTVA Formularfelder laut Bogen 207 # @@ -660,7 +657,7 @@ sub get_accounts_ustva { my $dpt_where; my $dpt_join; my $project; - my $where = "1 = 1"; + my $where = ""; my $glwhere = ""; my $subwhere = ""; my $ARwhere = ""; @@ -699,107 +696,63 @@ sub get_accounts_ustva { AND ac.project_id = $form->{project_id} |; } -######################################### -# Method eq 'cash' = IST Versteuerung -######################################### + ############################################ + # Method eq 'cash' = IST Versteuerung + ############################################ + # Betrifft nur die eingenommene Umsatzsteuer + # + ############################################ if ($form->{method} eq 'cash') { $query = qq| - SELECT - -- Alle tatsaechlichen Zahlungseingaenge - -- im Voranmeldezeitraum erfassen - -- (Teilzahlungen werden prozentual auf verschiedene Steuern aufgeteilt) - SUM( ac.amount * - -- Bezahlt / Rechnungssumme - ( - SELECT SUM(acc.amount) - FROM acc_trans acc - INNER JOIN chart c ON (acc.chart_id = c.id - AND c.link like '%AR_paid%') - WHERE - 1=1 - $ARwhere - AND acc.trans_id = ac.trans_id - ) - / - ( - select amount from ar where id = ac.trans_id - ) - ) AS amount, - tk.pos_ustva - FROM acc_trans ac - LEFT JOIN chart c ON (c.id = ac.chart_id) - LEFT JOIN ar ON (ar.id = ac.trans_id) - LEFT JOIN taxkeys tk ON ( - tk.id = ( - SELECT id FROM taxkeys - WHERE chart_id = ac.chart_id - AND taxkey_id = ac.taxkey - AND startdate <= COALESCE(ar.deliverydate, ar.transdate) - ORDER BY startdate DESC LIMIT 1 - ) - ) - WHERE - 1=1 - -- Here no where, please. All Transactions ever should be - -- testet if they are paied in the USTVA report period. - GROUP BY tk.pos_ustva - - UNION -- alle Ausgaben AP erfassen - - SELECT - sum(ac.amount) AS amount, - tk.pos_ustva - FROM acc_trans ac - JOIN AP ON (AP.id = ac.trans_id ) - JOIN chart c ON (c.id = ac.chart_id) - LEFT JOIN taxkeys tk ON ( - tk.id = ( - SELECT id FROM taxkeys - WHERE chart_id=ac.chart_id - AND taxkey_id=ac.taxkey - AND startdate <= COALESCE(AP.transdate) - ORDER BY startdate DESC LIMIT 1 + SELECT + -- USTVA IST-Versteuerung + -- + -- Alle tatsaechlichen _Zahlungseingaenge_ + -- im Voranmeldezeitraum erfassen + -- (Teilzahlungen werden prozentual auf verschiedene Steuern aufgeteilt) + SUM( ac.amount * + -- Bezahlt / Rechnungssumme + ( + SELECT SUM(acc.amount) + FROM acc_trans acc + INNER JOIN chart c ON (acc.chart_id = c.id + AND c.link like '%AR_paid%') + WHERE + 1=1 + $ARwhere + AND acc.trans_id = ac.trans_id + ) + / + ( + SELECT amount FROM ar WHERE id = ac.trans_id + ) + ) AS amount, + tk.pos_ustva + FROM acc_trans ac + LEFT JOIN chart c ON (c.id = ac.chart_id) + LEFT JOIN ar ON (ar.id = ac.trans_id) + LEFT JOIN taxkeys tk ON ( + tk.id = ( + SELECT id FROM taxkeys + WHERE chart_id = ac.chart_id + -- AND taxkey_id = ac.taxkey + AND startdate <= COALESCE(ar.deliverydate, ar.transdate) + ORDER BY startdate DESC LIMIT 1 + ) ) - ) - WHERE - 1=1 - $APwhere - $dpt_where - $project - GROUP BY tk.pos_ustva - - UNION -- alle Ausgaben und Einnahmen direkter gl Buchungen erfassen - - SELECT sum - ( - ac.amount) AS amount, - tk.pos_ustva - FROM acc_trans ac - JOIN chart c ON (c.id = ac.chart_id) - JOIN gl a ON (a.id = ac.trans_id) - LEFT JOIN taxkeys tk ON ( - tk.id = ( - SELECT id FROM taxkeys - WHERE chart_id=ac.chart_id - AND taxkey_id=ac.taxkey - - AND startdate <= COALESCE(ac.transdate) - ORDER BY startdate DESC LIMIT 1 - ) - ) - - $dpt_join - WHERE $where - $dpt_from - $project - GROUP BY tk.pos_ustva - |; - - } else { -######################################### -# Method eq 'accrual' = Soll Versteuerung -######################################### + WHERE + 1=1 + -- Here no where, please. All Transactions ever should be + -- testet if they are paied in the USTVA report period. + GROUP BY tk.pos_ustva + |; + + } elsif ($form->{method} eq 'accrual') { + ######################################### + # Method eq 'accrual' = Soll Versteuerung + ######################################### if ($department_id) { $dpt_join = qq| @@ -810,22 +763,91 @@ sub get_accounts_ustva { |; } + $query = qq| - SELECT sum - ( - CASE WHEN c.link LIKE '%AR%' THEN ac.amount * -1 - WHEN c.link LIKE '%AP%' THEN ac.amount * 1 - END - ) AS amount, c.$category - FROM acc_trans ac - JOIN chart c ON (c.id = ac.chart_id) - $dpt_join - WHERE $where - $dpt_where - $project - GROUP BY c.$category - |; + -- Alle Einnahmen AR und pos_ustva erfassen + SELECT + - sum(ac.amount) AS amount, + tk.pos_ustva + FROM acc_trans ac + JOIN chart c ON (c.id = ac.chart_id) + JOIN ar ON (ar.id = ac.trans_id) + JOIN taxkeys tk ON ( + tk.id = ( + SELECT id FROM taxkeys + WHERE chart_id = ac.chart_id + AND startdate <= COALESCE(ar.deliverydate, ar.transdate) + ORDER BY startdate DESC LIMIT 1 + ) + ) + $dpt_join + WHERE 1 = 1 + $where + $dpt_where + $project + GROUP BY tk.pos_ustva + |; + + } else { + + $self->error("Unknown tax method: $form->{method}") + } + + ######################################### + # Ausgaben und Gl Buchungen sind gleich + # für Ist- und Soll-Versteuerung + ######################################### + $query .= qq| + UNION -- alle Ausgaben AP erfassen + + SELECT + sum(ac.amount) AS amount, + tk.pos_ustva + FROM acc_trans ac + JOIN AP ON (AP.id = ac.trans_id ) + JOIN chart c ON (c.id = ac.chart_id) + LEFT JOIN taxkeys tk ON ( + tk.id = ( + SELECT id FROM taxkeys + WHERE chart_id=ac.chart_id + --AND taxkey_id=ac.taxkey + AND startdate <= COALESCE(AP.transdate) + ORDER BY startdate DESC LIMIT 1 + ) + ) + WHERE + 1=1 + $APwhere + $dpt_where + $project + GROUP BY tk.pos_ustva + + UNION -- alle Ausgaben und Einnahmen direkter gl Buchungen erfassen + + SELECT sum + ( - ac.amount) AS amount, + tk.pos_ustva + FROM acc_trans ac + JOIN chart c ON (c.id = ac.chart_id) + JOIN gl a ON (a.id = ac.trans_id) + LEFT JOIN taxkeys tk ON ( + tk.id = ( + SELECT id FROM taxkeys + WHERE chart_id=ac.chart_id + --AND taxkey_id=ac.taxkey + AND startdate <= COALESCE(ac.transdate) + ORDER BY startdate DESC LIMIT 1 + ) + ) + + $dpt_join + WHERE 1 = 1 + $where + $dpt_from + $project + GROUP BY tk.pos_ustva + |; my @accno; my $accno; @@ -836,11 +858,12 @@ sub get_accounts_ustva { $main::lxdebug->message(LXDebug::QUERY, "$callingdetails \$query=\n $query"); my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); while ($ref = $sth->fetchrow_hashref(NAME_lc)) { -# Bug 365 solved?! - $ref->{amount} *= -1; + # Bug 365 solved?! + $ref->{amount} *= -1; if ($category eq "pos_bwa") { if ($last_period) { $form->{ $ref->{$category} }{kumm} += $ref->{amount}; @@ -851,9 +874,11 @@ sub get_accounts_ustva { $form->{ $ref->{$category} } += $ref->{amount}; } } + $sth->finish; $main::lxdebug->leave_sub(); + } diff --git a/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql b/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql new file mode 100644 index 000000000..b2d11b5d6 --- /dev/null +++ b/sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql @@ -0,0 +1,377 @@ +-- @tag: ustva_setup_2007_update_chart_taxkeys_tax +-- @description: Aktualisierung des SKR03 für 2006/2007. Es werden bisher nur Inland Buchungen 16%/19% in 2006/2007 unterstützt. +-- @depends: ustva_setup_2007 + + + +--############################################################# +--# +--# Neue Konten einfügen +--# +--############################################################# + + +INSERT INTO chart ( + accno, description, + charttype, category, link + ) +SELECT + '1570','Anrechenbare Vorsteuer', + 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax' +WHERE EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + + +INSERT INTO chart ( + accno, description, + charttype, category, link + ) +SELECT + '1574','Abziehbare Vorsteuer aus innergem. Erwerb 19 %', + 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax' +WHERE EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + + +INSERT INTO chart ( + accno, description, + charttype, category, link + ) +SELECT + '1774','Umsatzsteuer aus innergem. Erwerb 19 %', + 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax' +WHERE EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE chart SET description = 'Umsatzsteuer 7% innergem.Erwerb' +WHERE accno='1772' +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE chart SET description = 'Umsatzsteuer 16% innergem.Erwerb' +WHERE accno='1773' +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE chart SET description = 'Abziehbare Vorsteuer 7% innergem. Erwerb' +WHERE accno='1572' +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE chart SET description = 'Abziehbare Vorsteuer 16% innergem. Erwerb' +WHERE accno='1573' +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE chart SET description = 'Innergem. Erwerb 16%/19% VSt u. USt.' +WHERE accno='3425' +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE chart SET description = 'Innergem. Erwerb 7% VSt u. USt.' +WHERE accno='3420' +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +--INSERT INTO chart ( +-- accno, description, +-- charttype, category, link +-- ) +--SELECT +-- '3550','Steuerfreier innergem. Erwerb', +-- 'A', 'E', 'AP_amount:IC_cogs' +--WHERE EXISTS ( -- update only for SKR03 +-- SELECT coa FROM defaults +-- WHERE defaults.coa='Germany-DATEV-SKR03EU' +--); + + + +--############################################################# +--# +--# Anpassungen Tabelle tax +--# +--############################################################# + +-- Steuerkontenbenennung nach DATEV +UPDATE tax SET + taxdescription = 'USt-frei' +WHERE taxkey = '1' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Umsatzsteuer' +WHERE taxkey = '2' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Umsatzsteuer' +WHERE taxkey = '3' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; +UPDATE tax SET + taxdescription = 'Vorsteuer' +WHERE taxkey = '8' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Vorsteuer' +WHERE taxkey = '9' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Im anderen EU-Staat steuerpflichtige Lieferung' +WHERE taxkey = '10' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Steuerfreie innergem. Lieferung an Abnehmer mit Id.-Nr.' +WHERE taxkey = '11' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Steuerpflichtige EG-Lieferung zum ermäßigten Steuersatz' +WHERE taxkey = '12' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Steuerpflichtige EG-Lieferung zum vollen Steuersatz' +WHERE taxkey = '13' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + + +UPDATE tax SET + taxdescription = 'Steuerpflichtiger innergem. Erwerb zum ermäßigten Steuersatz' +WHERE taxkey = '18' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE tax SET + taxdescription = 'Steuerpflichtiger innergem. Erwerb zum vollen Steuersatz' +WHERE taxkey = '19' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +-- Weitere Steuerschlüssel hinzufügen + +INSERT INTO tax ( + chart_id, + taxnumber, + rate, + taxkey, + taxdescription + ) + SELECT (SELECT id FROM chart WHERE accno = '1774'), '1774', '0.19000', taxkey, taxdescription + FROM tax + WHERE taxkey = '13' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + + +INSERT INTO tax ( + chart_id, + rate, + taxnumber, + taxkey, + taxdescription + ) + SELECT (SELECT id FROM chart WHERE accno = '1574'), '0.19000', '1574', taxkey, taxdescription + FROM tax + WHERE taxkey = '19' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + + + + +--############################################################# +--# +--# Anpassungen Tabelle taxkeys +--# +--############################################################# + + +INSERT INTO taxkeys ( + chart_id, tax_id, taxkey_id, pos_ustva, startdate) + SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1576'), '9', '66', '1970-01-01' + FROM chart + LEFT JOIN tax ON (chart.id = tax.chart_id) + WHERE chart.accno = '1576' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +INSERT INTO taxkeys ( + chart_id, tax_id, taxkey_id, pos_ustva, startdate) + SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1574'), '19', '61', '1970-01-01' + FROM chart + LEFT JOIN tax ON (chart.id = tax.chart_id) + WHERE chart.accno = '1574' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + + +INSERT INTO taxkeys ( + chart_id, tax_id, taxkey_id, pos_ustva, startdate) + SELECT chart.id, '0', '0', '891', '2007-01-01' + FROM chart + LEFT JOIN tax ON (chart.id = tax.chart_id) + WHERE chart.accno = '1774' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +UPDATE taxkeys SET pos_ustva = '63' +WHERE chart_id in (SELECT id FROM chart WHERE accno in ('1577') +AND startdate = '1970-01-01') +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +UPDATE taxkeys SET pos_ustva = '67' +WHERE chart_id in (SELECT id FROM chart WHERE accno in ('1578', '1579') +AND startdate = '1970-01-01') +AND EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + + +INSERT INTO taxkeys ( + chart_id, tax_id, taxkey_id, pos_ustva, startdate) + SELECT chart.id, '0', '0', '66', '1970-01-01' + FROM chart + LEFT JOIN tax ON (chart.id = tax.chart_id) + WHERE chart.accno in ('1570', '1576') + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + + +UPDATE taxkeys SET pos_ustva = '51' +WHERE chart_id in (SELECT id FROM chart WHERE accno in ('8520') +AND startdate = '1970-01-01') +AND +EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' +); + +INSERT INTO taxkeys ( + chart_id, tax_id, taxkey_id, pos_ustva, startdate) + SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1776'), '0', '36', '1970-01-01' + FROM chart + LEFT JOIN tax ON (chart.id = tax.chart_id) + WHERE chart.accno = '1776' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + +INSERT INTO taxkeys ( + chart_id, tax_id, taxkey_id, pos_ustva, startdate) + SELECT chart.id, (SELECT id FROM tax WHERE taxnumber = '1775'), '0', '36', '2007-01-01' + FROM chart + LEFT JOIN tax ON (chart.id = tax.chart_id) + WHERE chart.accno = '1775' + AND + EXISTS ( -- update only for SKR03 + SELECT coa FROM defaults + WHERE defaults.coa='Germany-DATEV-SKR03EU' + ) +; + diff --git a/t/selenium/incomming/ustva-Inland-linet.html b/t/selenium/incomming/ustva-Inland-linet.html new file mode 100644 index 000000000..2e2038c47 --- /dev/null +++ b/t/selenium/incomming/ustva-Inland-linet.html @@ -0,0 +1,2116 @@ + + + +ustva-Inland-linet + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ustva-Inland-linet
setTimeout120000
selectFramerelative=top
openadmin.pl?path=bin/mozilla/&rpw=ro26F.eQBldoA&nextsub=list_users&action=Weiter
assertTitleLx-Office ERP Administration -
clickAndWaitdocument.forms[0].action[2]
assertTitleLx-Office ERP / Datenbankadministration -
selectWindownull
clickAndWaitaction
assertTitleLx-Office ERP Datenbankadministration / Datenbank anlegen -
typedbSelenium_Testdb-_SKR03_IST_1619_2006_2007
clickdocument.forms[0].chart[2]
clickAndWaitaction
fireEvent
clickAndWaitaction
clickAndWaitdemo-1619
assertTitleLx-Office ERP Administration / Benutzerdaten bearbeiten -
typePg_dbnameSelenium_Testdb-_SKR03_IST_1619_2006_2007
clickAndWaitaction
assertTitleLx-Office ERP Administration -
typelogindemo-1619
typepassworddemo
clickAndWaitdocument.forms[1].action
assertTitleDatenbankaktualisierung - Lx-Office Version 2.4.1 - -
clickAndWait//input[@value='Weiter']
assertTitleLx-Office Version 2.4.1 - Testbenutzer - Selenium_Testdb-_SKR03_IST_1619_2006_2007
typeinvdate11.11.2006
selectFramerelative=top
clicklink=Kunde erfassen
selectFramemain_window
waitForPageToLoad120000
typenameTestkunde
clickAndWaitaction
selectFramerelative=top
clicklink=Lieferant erfassen
selectFramemain_window
waitForPageToLoad120000
typenameTestlieferant
clickAndWaitaction
selectFramerelative=top
clicklink=Ware erfassen
selectFramemain_window
waitForPageToLoad120000
typedescriptionTestware
selectbuchungsgruppen_idlabel=Standard 16%/19%
typelastcost50
typesellprice100
clickAndWaitdocument.ic.action[1]
selectFramerelative=top
clicklink=Rechnung erfassen
selectFramemain_window
waitForPageToLoad120000
typeinvnumber1
typepartnumber_11
typeinvdate1.3.2007
typedatepaid_110.3.2007
typesource_11
typememo_11
typepaid_1119
clickAndWaitdocument.invoice.action[6]
clickAndWaitdocument.invoice.action[6]
selectFramerelative=top
clicklink=Rechnung erfassen
selectFramemain_window
waitForPageToLoad120000
typeinvnumber2
typeinvdate11.11.2006
typedatepaid_120.11.2006
typepartnumber_11
typesource_14
typememo_14
typepaid_1116
clickAndWaitdocument.invoice.action[6]
clickAndWaitdocument.invoice.action[6]
selectFramerelative=top
clicklink=Rechnung erfassen
selectFramemain_window
waitForPageToLoad120000
typeinvnumber3
typeinvdate03.12.2006
typeduedate10.12.2006
typepartnumber_11
clickAndWaitupdate_button
verifyTextPresentUmsatzsteuer
verifyTextPresent16,00
typedeliverydate15.12.2006
clickAndWaitupdate_button
verifyTextPresentUmsatzsteuer
verifyTextPresent16,00
typedatepaid_120.12.2006
typesource_14
typememo_14
typepaid_1116
clickAndWaitdocument.invoice.action[6]
selectFramerelative=top
clicklink=Rechnung erfassen
selectFramemain_window
waitForPageToLoad120000
typeinvnumber4
typeinvdate8.08.2006
typedeliverydate10.09.2006
typepartnumber_11
clickAndWaitupdate_button
verifyText//tr[6]/td/table/tbody/tr/td[2]/table/tbody/tr[2]/td16,00
typedatepaid_12.2.2007
typesource_17
typememo_17
typepaid_1116
clickAndWaitdocument.invoice.action[6]
selectFramerelative=top
clicklink=Rechnung erfassen
selectFramemain_window
waitForPageToLoad120000
typeinvnumber5
typeinvdate10.06.2006
typedeliverydate13.1.2007
typepartnumber_11
typedatepaid_112.7.2006
typesource_145
typememo_144
typepaid_1119
clickAndWaitdocument.invoice.action[6]
clickAndWaitdocument.invoice.action[6]
selectFramerelative=top
clicklink=Dialogbuchen
selectFramemain_window
waitForPageToLoad120000
selectaccno_1label=1588--Bezahlte Einfuhrumsatzsteuer
selectaccno_2label=1200--Bank
typereferenceTest 1588 Kz62
typedescriptionTest 1588 Kz62
typetransdate1.10.2005
typedebit_2143,2455
typecredit_1143,2455
clickAndWaitaction
clickAndWaitdocument.gl.action[1]
waitForTextPresentBuchung gespeichert
selectFramerelative=top
clicklink=Debitorenbuchung
selectFramemain_window
waitForPageToLoad120000
selectAR_amount_1label=8400--Erlöse 16%/19% USt.
typeamount_12000
clickAndWaitaction
typetransdate19.2.2007
clickAndWaitaction
typedatepaid_11.4.2007
typesource_12
typememo_12
typepaid_12000
selectAR_paid_1label=1200--Bank
typeinvnumberDebitorenbuchung
clickAndWaitdocument.arledger.action[1]
selectFramerelative=top
clicklink=Kreditorenbuchung
selectFramemain_window
waitForPageToLoad120000
selectAP_amount_1label=0420--Büroeinrichtung
typeinvnumberKreditorenbuchung
typeamount_12000
clickAndWaitaction
typetransdate20.05.2007
typedatepaid_11.6.2007
typesource_1123
typememo_1123
typepaid_11000
clickAndWaitdocument.forms[0].action[1]
selectFramerelative=top
clicklink=UStVa Einstellungen
selectFramemain_window
waitForPageToLoad120000
selectelsterland_newlabel=Nordrhein Westfalen
selectelsterFFFF_newlabel=Aachen-Innenstadt (5201)
clickcash
clickmonth
clickAndWaitaction
selectpart_1_1label=1
selectpart_1_2label=2
selectpart_1_3label=3
selectpart_1_4label=4
selectpart_2_1label=5
selectpart_2_2label=6
selectpart_2_3label=7
selectpart_2_4label=8
clickAndWaitdocument.elsterform.action[1]
selectFramerelative=up
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=März
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 81)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[5]19,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=November
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 51)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[5]16,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=Dezember
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 51)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[5]16,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=Februar
clickAndWaitaction
verifyText//tr[11]/td[2]35
verifyText//tr[11]/td[3]100
verifyText//tr[11]/td[4]36
verifyText//tr[11]/td[5]16,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=Juli
clickAndWaitaction
verifyText//tr[11]/td[2]35
verifyText//tr[11]/td[3]100
verifyText//tr[11]/td[4]36
verifyText//tr[11]/td[5]19,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2005
selectzeitraumlabel=Oktober
clickAndWaitaction
selectFramerelative=up
selectFramemain_window
verifyText//tr[39]/td[2]62
verifyText//tr[39]/td[3]143,25
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=April
clickAndWaitaction
selectFramerelative=up
selectFramemain_window
verifyText//tr[9]/td[2](Spalte 81)
verifyText//tr[9]/td[3]1681
verifyText//tr[9]/td[5]319,33
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=Mai
clickAndWaitaction
selectFramerelative=up
selectFramemain_window
verifyText//tr[37]/td[3]319,33
verifyText//tr[37]/td[2](Spalte 66)
selectFramerelative=top
clicklink=UStVa Einstellungen
selectFramemain_window
waitForPageToLoad120000
clickaccrual
clickmonth
clickAndWaitaction
selectpart_1_1label=1
selectpart_1_2label=2
selectpart_1_3label=3
selectpart_1_4label=4
selectpart_2_1label=5
selectpart_2_2label=6
selectpart_2_3label=7
selectpart_2_4label=8
clickAndWaitdocument.elsterform.action[1]
selectFramerelative=up
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=März
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 81)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[5]19,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=November
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 51)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[5]16,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=Dezember
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 51)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[5]16,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=August
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 51)
verifyText//tr[9]/td[3]100
verifyText//tr[9]/td[4](Spalte 51 rechts)
verifyText//tr[9]/td[5]16,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2006
selectzeitraumlabel=Juni
clickAndWaitaction
verifyText//tr[11]/td[2]35
verifyText//tr[11]/td[3]100
verifyText//tr[11]/td[4]36
verifyText//tr[11]/td[5]19,00
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2005
selectzeitraumlabel=Oktober
clickAndWaitaction
verifyText//tr[39]/td[2]62
verifyText//tr[39]/td[3]143,25
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=Februar
clickAndWaitaction
verifyText//tr[9]/td[2](Spalte 81)
verifyText//tr[9]/td[3]1681
verifyText//tr[9]/td[5]319,33
selectFramerelative=top
clicklink=UStVa
selectFramemain_window
waitForPageToLoad120000
selectyearlabel=2007
selectzeitraumlabel=Mai
clickAndWaitaction
verifyText//tr[37]/td[3]319,33
verifyText//tr[37]/td[2](Spalte 66)
selectFramerelative=top
openadmin.pl?path=bin/mozilla/&rpw=ro26F.eQBldoA&nextsub=list_users&action=Weiter
assertTitleLx-Office ERP Administration -
clickAndWaitdemo-1619
typePg_dbnameleer
assertTitleLx-Office ERP Administration / Benutzerdaten bearbeiten -
clickAndWaitdocument.forms[0].action[0]
assertTitleLx-Office ERP Administration -
clickAndWaitdocument.forms[0].action[2]
assertTitleLx-Office ERP / Datenbankadministration -
clickdocument.forms[0].action[1]
waitForPageToLoad120000
assertTitleLx-Office ERP Datenbankadministration / Datenbank löschen -
click//input[@value="Selenium_Testdb-_SKR03_IST_1619_2006_2007"]
clickAndWaitaction
assertTitleLx-Office ERP Datenbankadministration / Datenbank löschen -
clickAndWaitaction
assertTitleLx-Office ERP Administration -
+ + -- 2.20.1