From 2cd7062c523ff86c2d02e78aed58a8234262552b Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Fri, 5 Jan 2007 09:17:05 +0000 Subject: [PATCH] =?utf8?q?Bei=20Einkaufsmasken=20sollte=20f=C3=BCr=20Artik?= =?utf8?q?el=20der=20Einkaufspreis=20aus=20der=20Datenbank=20geholt=20werd?= =?utf8?q?en,=20nicht=20der=20Verkaufspreis.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/IR.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/IR.pm b/SL/IR.pm index 77df80603..56207bf1b 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1147,7 +1147,7 @@ sub retrieve_item { $form->{transdate} ? $dbh->quote($form->{transdate}) : "current_date"; } - my $query = qq|SELECT p.id, p.partnumber, p.description, p.sellprice, + my $query = qq|SELECT p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice, p.inventory_accno_id, c1.accno AS inventory_accno, c1.new_chart_id AS inventory_new_chart, date($transdate) - c1.valid_from as inventory_valid, c2.accno AS income_accno, c2.new_chart_id AS income_new_chart, date($transdate) - c2.valid_from as income_valid, -- 2.20.1