summaryrefslogtreecommitdiff
path: root/LedgerSMB
diff options
context:
space:
mode:
Diffstat (limited to 'LedgerSMB')
-rw-r--r--LedgerSMB/PriceMatrix.pm3
1 files changed, 2 insertions, 1 deletions
diff --git a/LedgerSMB/PriceMatrix.pm b/LedgerSMB/PriceMatrix.pm
index 0a92562c..c604e982 100644
--- a/LedgerSMB/PriceMatrix.pm
+++ b/LedgerSMB/PriceMatrix.pm
@@ -50,7 +50,8 @@ sub price_matrix_query {
SELECT p.id AS parts_id, 0 AS customer_id,
0 AS pricegroup_id, 0 AS pricebreak,
p.sellprice, NULL AS validfrom, NULL AS validto,
- (SELECT substr(curr,1,3) FROM defaults) AS curr,
+ (SELECT substr(value,1,3) FROM defaults WHERE
+ setting_key = 'curr') AS curr,
'' AS pricegroup
FROM parts p
WHERE p.id = ?