case when formula to show the quantity with transaction unit in item fulfillment search

AI generated answer (using internal Slack threads):

Based on the conversations, to show the quantity with transaction unit in item fulfillment search, you can use the field "Quantity in Transaction Units". This field shows the quantity ordered in the Unit of Measure (UOM) on the transaction. For example, if you have a Sales Order with a line that is Quantity 1 box of 10 pieces, the quantity field will show 10 (quantity in item base units) and the "Quantity in Transaction Units" will show 1 (quantity per calculated unit). If you want to maintain a single line for each Purchase Order line item in a saved search and get the total quantity received in transaction units, you can use the formula

{quantityshiprecv} / ({quantity} / {quantityuom})

. If you want to display

{item.locationquantityavailable}

in a transaction search where there is a location filter and dynamically returns only the quantity in the selected location filter, you can use a Case formula like this:

CASE WHEN {location} = {item.inventorylocation} THEN {item.locationquantityonhand} else 0 END

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******