case when formula to show the document number if the intercompany status is paired

AI generated answer (using internal Slack threads):

Based on the conversations, you can use a CASE WHEN formula to show the document number if the intercompany status is paired. However, the exact field names for the document number and intercompany status in your NetSuite instance are needed to provide a precise formula. Assuming that the field for the document number is

{number}

and the field for the intercompany status is

{intercompanystatus}

, a possible formula could be:

CASE WHEN {intercompanystatus} = 'Paired' THEN {number} ELSE NULL END

This formula checks if the intercompany status is 'Paired'. If it is, it returns the document number. If it's not, it returns NULL. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******