Show sales invoice number in item fulfillment using case when formula

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that displaying the associated invoice number on an Item Fulfillment in NetSuite can be a bit tricky due to the way transactions are related. The Invoice and Item Fulfillment (IF) are related transactions of the Sales Order (SO), but the IF is not directly related to the Invoice. One way to achieve this could be to create a saved search from the Sales Order that shows both the Invoice and IF, or make a search of Invoice and IF grouped by 'Created From'. If the IF is invoiced, you would search 'Created From : Billing Transaction'. On an IF search, the field would be 'Applied To Transaction : Billing Transaction'. However, it was noted that there were issues with consistently sourcing this field into a custom field on the IF. As for using a CASE WHEN formula, the correct syntax seems to be

CASE WHEN ({field} = 'value') THEN 'result1' ELSE {field} END

. Parentheses and quotes around the value seem to help the formula work correctly. Please note that this is a complex issue and might require further customization based on your specific NetSuite setup and business requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******