From 2868feee8fb33457e7562f02778186b5b5c1a2b6 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 3 Sep 2008 14:04:07 +0000 Subject: [PATCH] =?utf8?q?Beim=20Anlegen=20des=20allerersten=20Beleges=20e?= =?utf8?q?ines=20Typs=20daf=C3=BCr=20sorgen,=20dass=20vendor=5Fid=20bzw.?= =?utf8?q?=20customer=5Fid=20auch=20gesetzt=20werden.=20Andernfalls=20funk?= =?utf8?q?tionieren=20Dinge=20wie=20Ansprechpartner-Drop-Down-Boxen=20nich?= =?utf8?q?t,=20oder=20es=20erscheinen=20sp=C3=A4ter=20SQL-Fehler.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/IR.pm | 2 +- SL/IS.pm | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/SL/IR.pm b/SL/IR.pm index 936cc98fe..72a36ae57 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -866,7 +866,7 @@ sub get_vendor { } my $query = qq|SELECT - v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, + v.id AS vendor_id, v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, $duedate + COALESCE(pt.terms_netto, 0) AS duedate, diff --git a/SL/IS.pm b/SL/IS.pm index 9a338eb0b..7e52b2bea 100644 --- a/SL/IS.pm +++ b/SL/IS.pm @@ -1526,7 +1526,7 @@ sub get_customer { # get customer $query = qq|SELECT - c.name AS customer, c.discount, c.creditlimit, c.terms, + c.id AS customer_id, c.name AS customer, c.discount, c.creditlimit, c.terms, c.email, c.cc, c.bcc, c.language_id, c.payment_id, c.street, c.zipcode, c.city, c.country, c.notes AS intnotes, c.klass as customer_klass, c.taxzone_id, c.salesman_id, -- 2.20.1