Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Saturday, August 9, 8:00 PM PT to 9:00 PM PT
Saturday, August 16, 8:00 PM PT to 9:00 PM PT
During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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 |
Did you know your engagement in our programs can lead to awesome surprises? That's right!
By participating and showcasing your skills, you'll get a chance to win exclusive rewards. Are you ready to unlock your potential and claim these amazing perks?
Learn more and join in the fun: