Revision 7d0049f9
Von Tamino Steinert vor 3 Tagen hinzugefügt
SL/IS.pm | ||
---|---|---|
1595 | 1595 |
do_query($form, $dbh, $query, "Rechnung storniert am $form->{invdate} ", conv_i($form->{"storno_id"})); |
1596 | 1596 |
do_query($form, $dbh, qq|UPDATE ar SET paid = amount WHERE id = ?|, conv_i($form->{"id"})); |
1597 | 1597 |
|
1598 |
$query = <<SQL;
|
|
1599 |
UPDATE orderitems
|
|
1600 |
SET recurring_billing_invoice_id = NULL
|
|
1601 |
WHERE recurring_billing_invoice_id = ?
|
|
1602 |
SQL
|
|
1603 |
|
|
1604 |
do_query($form, $dbh, $query, conv_i($form->{"storno_id"})); |
|
1598 |
### Don't reset position of once periodic_invoice_items_configs on storno
|
|
1599 |
# $query = <<SQL;
|
|
1600 |
# UPDATE periodic_invoice_items_configs
|
|
1601 |
# SET once_invoice_id = NULL
|
|
1602 |
# WHERE once_invoice_id = ?
|
|
1603 |
# SQL |
|
1604 |
# do_query($form, $dbh, $query, conv_i($form->{"storno_id"}));
|
|
1605 | 1605 |
} |
1606 | 1606 |
|
1607 | 1607 |
# maybe we are in a larger transaction and the current |
Auch abrufbar als: Unified diff
S:IS: Einmal-Pos. von wied. Rechnungen bei Stronierung nicht zurücksetzt