Search results formula to get location quantity on hand, location quantity available, location quantity backordered
search.createColumn({
name: "formulanumeric",
summary: "MAX",
formula: "CASE WHEN {item.inventorylocation} = {purchaseorder.location} THEN {item.locationquantityonhand} ELSE 0 END",
label: "OnHand"
}),
search.createColumn({
name: "formulanumeric",
summary: "MAX",
formula: "CASE WHEN {item.inventorylocation} = {purchaseorder.location} THEN {item.locationquantityavailable} ELSE 0 END",
label: "Available"
}),
search.createColumn({
name: "formulanumeric",
summary: "MAX",
formula: "CASE WHEN {item.inventorylocation} = {purchaseorder.location} THEN {item.locationquantitybackordered} ELSE 0 END",
label: "Backordered"
}),