Inventur: Voreinstellungen für Lager, Lagerplatz und Stichtag (DB und Rose)

[kivitendo-erp.git] / SL / DB / VC.pm

diff --git a/SL/DB/VC.pm b/SL/DB/VC.pm
index 44b2dbb0952057f976c957475f57603c81698f89..c41f28788fe378f08619b85e60e0fc4ab8be9104 100644 (file)
--- a/SL/DB/VC.pm
+++ b/SL/DB/VC.pm
@@ -26,7 +26,7 @@ SQL
   $query = <<SQL;
     SELECT o.amount,
       (SELECT e.buy FROM exchangerate e
   $query = <<SQL;
     SELECT o.amount,
       (SELECT e.buy FROM exchangerate e

-       WHERE e.curr = o.curr
+       WHERE e.currency_id = o.currency_id

          AND e.transdate = o.transdate)
     FROM oe o
     WHERE (o.${type}_id = ?)
          AND e.transdate = o.transdate)
     FROM oe o
     WHERE (o.${type}_id = ?)