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 to Show Transactions with Different Posting Period and Date
Scenario
The user wants to create a Transaction Saved Search which shows Transactions whose Transaction Dates do not fall within the Transaction Posting Period. This tailored search will enable them to quickly access and review any transactions that might require further attention or adjustments.
Solution
1.Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Click Transaction
3. Search Title: Enter Title
4. Navigate to Criteria tab > Standard subtab and add Posting = T and filter Formula (Numeric), populating as below:
5. Navigate to Results tab > Columns subtab, add the following fields:
The formula (text) added = DECODE(To_Char({trandate},'Mon YYYY'),{postingperiod},'YES','NO') is used to verify and compare the
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: