list all dates in a posting period using search

AI generated answer (using internal Slack threads):

To list all dates in a posting period using a search in SuiteScript, you can perform a search on the

accountingperiod

record type. The

startdate

and

enddate

fields of this record type represent the range of dates in the posting period. Here is a sample code snippet in SuiteScript 2.0:

javascript
var search = require('N/search');

var postingPeriodSearch = search.create({
   type: 'accountingperiod',
   filters: [
      ['startdate', 'onorafter', '1/1/2021'], 
      'and', 
      ['enddate', 'onorbefore', '12/31/2021']
   ],
   columns: ['startdate', 'enddate']
});

postingPeriodSearch.run().each(function(result) {
   var startDate = result.getValue({name: 'startdate'});
   var endDate = result.getValue({name: 'enddate'});
   log.debug('Start Date', startDate);
   log.debug('End Date', endDate);
   return true;
});

This script will return all the posting periods that fall within the date range specified in the filters. The start and end dates of each posting period are logged to the execution log. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******