Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Project Saved Search > Sales Order Document Number
Hello,
We have a Project Saved Search and we want to add the Sales Order Document Number.
We used this formula: CASE WHEN {transaction.type} = 'Sales Order' THEN {transaction.number} ELSE NULL END
It shows the correct Document Number but there are duplicates.
If we add Transaction Fields… Main Line is True under the Criteria tab, it shows no results.
Can you share the right field or formula to display just the SO Document Number?
Here's screenshot FYR:
On the report:
Thank you!