i have UI saved search on item record where i am checking few things like item status should active , now i want whatever result i get i want to show the number of quantity subtracted by number of quantity received which is in return authorization, how do i do that

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you want to create a saved search that shows the quantity of an item subtracted by the quantity received in return authorization. Here's how you can do it: 1. Create a new saved search on the item record. 2. In the criteria tab, add your conditions (like item status = active). 3. In the results tab, add the fields you want to display. For the quantity subtracted by the quantity received, you can use a formula field. The formula would look something like this:

NVL({quantity},0)-NVL({quantityshiprecv},0)

. This formula subtracts the quantity received (

quantityshiprecv

) from the total quantity (

quantity

). The

NVL

function is used to replace null values with 0 to avoid any errors during the calculation. Please note that

{quantityshiprecv}

is the field id for the quantity received in return authorization. If you can't find this field, you can use a browser "view source" trick or use a NetSuite Field Explorer extension for Chrome to find the field id. Remember to replace

{quantity}

and

{quantityshiprecv}

with the actual field ids in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******