Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Transaction Search by AccountType
Hi all,
I'm trying to obtain a list (via web services) of transactions that are linked to a certain account type, eg. Income or Expense.
I'm using Advanced Search however I cannot include a join on AccountType, and the .setAccountType() method requires a SearchMultiSelectField and not a SearchEnumMultiSelectField.
Maybe I'm missing something, but a SearchMultiSelectField requires at least 1 RecordRef and I can't figure out the InternalID of either a 'Income' or 'Expense' account type.
Below definitely doesn't work.
SearchMultiSelectField acctType = new SearchMultiSelectField(); acctType.setSearchValue(new RecordRef[1]); RecordRef thisAccountType = new RecordRef(); thisAccountType.setInternalId(AccountType.__expense) thisAccountType.setType(RecordType.account); acctType.setSearchValue(0, thisAccountType); acctType.setOperator(SearchMultiSelectFieldOperator.anyOf);