Skip to content

Instantly share code, notes, and snippets.

@ifnull
Created June 22, 2015 21:54
Show Gist options
  • Save ifnull/404a83e1fb8032d7bd44 to your computer and use it in GitHub Desktop.
Save ifnull/404a83e1fb8032d7bd44 to your computer and use it in GitHub Desktop.
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);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment