X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FSEPA.pm;h=32e763cdba0edfc64fb226aebb674447e5862bc7;hb=cdaddc5ab3c569585e39ee9e3f11260ae2336fea;hp=38341eccd5f9e4ef93c31508659dce6f3da2968c;hpb=c1716dbdeb0ba6d2cd9c708a2c54b9845e9532b4;p=kivitendo-erp.git

diff --git a/SL/SEPA.pm b/SL/SEPA.pm
index 38341eccd..32e763cdb 100644
--- a/SL/SEPA.pm
+++ b/SL/SEPA.pm
@@ -21,8 +21,8 @@ sub retrieve_open_invoices {
 
   my $query =
     qq|
-       SELECT ${arap}.id, ${arap}.invnumber, ${arap}.${vc}_id, ${arap}.amount AS invoice_amount, ${arap}.invoice,
-         vc.name AS vcname, ${arap}.duedate as duedate,
+       SELECT ${arap}.id, ${arap}.invnumber, ${arap}.${vc}_id as vc_id, ${arap}.amount AS invoice_amount, ${arap}.invoice,
+         vc.name AS vcname, vc.language_id, ${arap}.duedate as duedate,
 
          COALESCE(vc.iban, '') <> '' AND COALESCE(vc.bic, '') <> '' AS vc_bank_info_ok,