This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi,

I am looking to exclude transactions (Item Receipts and Inventory Transfers) that are in A/P,A/R,GL Locked periods.  How could this be done via a Saved Search or verify using a field on the transaction itself during an Map/Reduce script?

First search for the locked periods, then exclude transactions by those date ranges.

```require(['N/query'],function(query){
  var sql="select * from accountingperiod where closed = 'T'";
  var results = query.runSuiteQL({query: sql, params: []}).asMappedResults();
console.log(results);
})```

things get more tricky if you have multiple subsidiaries that close independently.