ifnull
6/22/2015 - 9:54 PM

PHP search Netsuite for accounting period or posting period

PHP search Netsuite for accounting period or posting period

<?php
// Get Accounting Period for specific month
// Start Date  is on 6/1/2015
// End Date    is on 6/30/2015
// Quarter is false

require_once '../PHPToolkit/NetSuiteService.php';

$service = new NetSuiteService();

$service->setSearchPreferences(false, 20);

// Start Date
$periodStart = new SearchDateField();
$periodStart->operator = "on";
$periodStart->searchValue = "2015-06-01T00:00:00.000-07:00";

// End Date
$periodEnd = new SearchDateField();
$periodEnd->operator = "on";
$periodEnd->searchValue = "2015-06-30T00:00:00.000-07:00";

// Exclude Quarters
$periodQuarter = new SearchBooleanField();
$periodQuarter->searchValue = FALSE;

// Basic Search with params
$search = new AccountingPeriodSearchBasic();
$search->startDate = $periodStart;
$search->endDate = $periodEnd;
$search->isQuarter = $periodQuarter;

$request = new SearchRequest();
$request->searchRecord = $search;

$searchResponse = $service->search($request);

if (!$searchResponse->searchResult->status->isSuccess) {
	echo "SEARCH ERROR";
} else {
	echo "SEARCH SUCCESS, records found: " . $searchResponse->searchResult->totalRecords;
	print_r($searchResponse->searchResult);
}