Discussions
Transaction Search
I want to create a suitescript to search all transaction records posted to a group of accounts (all accounts with account number starting with 51). Here's my code -
var filters = new Array();
filters[0] = new nlobjSearchFilter( 'accounttype', null, 'is', 'Expense' );
filters[1] = new nlobjSearchFilter( 'account', null, 'anyof', '51%' );
var columns = new Array();
columns[0] = new nlobjSearchColumn('account', null, 'group');
columns[1] = new nlobjSearchColumn('department', null, 'group');
columns[2] = new nlobjSearchColumn('class', null, 'group');
columns[3] = new nlobjSearchColumn('location', null, 'group');
columns[4] = new nlobjSearchColumn('debitamount', null, 'sum');
var searchresults = nlapiSearchRecord( 'transaction', null, filters, columns);
It returns all the transaction records - is not filtering by account. How can I do this? I would also like to add another filter to get the transactions for a given fiscal year. What would be the syntax for that.