Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Search join on rev. rec. schedule
I need to find transaction records from specific accounts with revenue recognition schedule period = last month period. I do not seem to figure out how to do a join on rev. rec. schedule. It is simple enough through UI:
1. Select transaction search
2. Select "Rev Rec Schedule..." from the bottom of the list
3. Select field "Posting Period"
However, when I tried to repeat the same programmatically in my script I can not find out proper formula. It should be something like
filters[0] = new nlobjSearchFilter('account', null,'anyof', [139,140], null);
filters[1] = new nlobjSearchFilter('type', null,'anyof', 'CustInvc', null);
filters[2] = new nlobjSearchFilter('postperiod, 'RS_RevRecognitionSched'
0