This simple SuiteQL query returns the pricing from a selected list of price levels for an item:
http://SELECT
p.item,
p.pricelevel,
BUILTIN.DF(p.pricelevel) AS price_level_name,
p.priceqty AS quantity_break,
p.price AS unit_price
FROM
itemprice p
WHERE
p.item = 1786
AND
p.pricelevel IN (215,216,217,218,219,220)
ORDER BY
p.item, p.pricelevel, p.priceqty
The item has quantity pricing applied:
The SuiteQL returns this:
It would appear the priceqty field is some kind of ID for the actual quantity that is set on each Item record here:
Is there a way to access the actual value of the quantity break using SuiteQL?
