diff --git a/src/org/openbravo/retail/posterminal/master/ProductPrice.java b/src/org/openbravo/retail/posterminal/master/ProductPrice.java
--- a/src/org/openbravo/retail/posterminal/master/ProductPrice.java
+++ b/src/org/openbravo/retail/posterminal/master/ProductPrice.java
@@ -10,6 +10,7 @@
 
 import org.codehaus.jettison.json.JSONException;
 import org.codehaus.jettison.json.JSONObject;
+import org.openbravo.retail.config.OBRETCOProductList;
 import org.openbravo.retail.posterminal.POSUtils;
 import org.openbravo.retail.posterminal.ProcessHQLQuery;
 
@@ -17,11 +18,18 @@
 
   @Override
   protected String getQuery(JSONObject jsonsent) throws JSONException {
-    return "from PricingProductPrice where priceListVersion in "
+    final OBRETCOProductList productList = POSUtils.getProductListByOrgId(jsonsent
+        .getString("organization"));
+    return "select pp.id as id, pp.priceListVersion.id as priceListVersion,"
+        + "pp.product.id as product, pp.listPrice as listPrice, pp.standardPrice as standardPrice,"
+        + "pp.priceLimit as priceLimit, pp.cost as cost, '' as _identifier "
+        + "from PricingProductPrice pp where pp.priceListVersion.id in "
         + "(select plv.id from PricingPriceList as ppl, PricingPriceListVersion as plv "
         + "where ppl.id = '"
         + POSUtils.getPriceListByOrgId(jsonsent.getString("organization")).getId()
         + "' and ppl.id = plv.priceList.id  and "
-        + "plv.validFromDate = (select max(pplv.validFromDate) from PricingPriceListVersion as pplv where pplv.priceList.id = ppl.id))";
+        + "plv.validFromDate = (select max(pplv.validFromDate) from PricingPriceListVersion as pplv where pplv.priceList.id = ppl.id)) "
+        + "and pp.product.id in (select pl.product.id from OBRETCO_Prol_Product pl where pl.obretcoProductlist.id = '"
+        + productList.getId() + "' )";
   }
 }