diff options
| -rw-r--r-- | LedgerSMB/PriceMatrix.pm | 3 |
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 = ? |