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!
NSC | Saved Search: Days Between Sales Order Creation and Fulfillment
Scenario
User wants to know how they could show the difference between the dates of when the Sales Order was created and when the Sales Order was fulfilled via a Saved Search.
Solution
To calculate the days between the date the Sales Order was created and the date it was shipped, you can try the following below:
1.Navigate to Reports > New Search > Select Transaction
2. Click Create Saved Search button
3. Under the Criteria, select the following:
- Type = Sales Order
- Fulfilling/Receiving Transaction : Type = Item Fulfillment
4. Under Results tab, you can add or remove preferred fields. To compute the difference of days:
Clarisa De Torres | Ask a Guru
- Earn Community badges now! Refer a Member | Answer Accepter |
The Support Community is your launchpad for learning, sharing, and earning exclusive rewards. Every contribution you make helps others and brings you closer to our official Oracle merchandise.
Learn more and join in the fun: