api.pricelistItem()
The method api.pricelistItem() has been deprecated in 14.0 version.
Deprecated Usage
def resultPrice = api.pricelistItem("Global Pricelist")
def cost = api.pricelistItem("Global Pricelist", "Cost")QueryApi Usage
Utilize a query of Condition Records to determine the approved price instead of querying each Price List line item.
Execute a single query for the entire set of SKUs, rather than performing individual queries for each SKU.
def skus = ["10000001"]
def targetDate = api.targetDate()
def qapi = api.queryApi()
def exprs = qapi.exprs()
def t1 = qapi.tables().conditionRecords("Global Pricelist")
def globalPrices = qapi.source(t1, [t1.sku, t1.conditionValue().as("ResultPrice"), t1.unitOfMeasure()],
exprs.and(
t1.sku.in(skus),
t1.validFrom().lessOrEqual(targetDate),
t1.validTo().greaterOrEqual(targetDate),
))
.stream {
it.each { pli ->
def resultPrice = pli.ResultPrice
def cost = pli.Cost
}
}See Also
Found an issue in documentation? Write to us.