This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone has any tips regarding setting the column _account_ to an account-type on the sublist _allocationsource_ on _allocationschedule_?

`var newrec = nlapiCreateRecord('allocationschedule');`
`newrec.setFieldValue('name','testrecord1');`
`newrec.setFieldValue('frequency','MONTHLY');`
`newrec.setFieldValue('creditaccount',1);`
`newrec.setFieldValue('weightsinpercentage','T');`
`newrec.selectNewLineItem('allocationdestination');`
`newrec.setCurrentLineItemValue('allocationdestination','account',1);`
`newrec.setCurrentLineItemValue('allocationdestination','weight','100');`
`newrec.commitLineItem('allocationdestination');`
`newrec.selectNewLineItem('allocationsource');`
`newrec.setCurrentLineItemValue('allocationsource','account','OthIncome');`
`newrec.commitLineItem('allocationsource');`
`nlapiSubmitRecord(newrec);`

This will result in "Invalid account reference key OthIncome for accountingbook &lt;NULL&gt;.". This is probably due to Netsuite trying to translate the value to an account, not an accounttype. Maybe there are some magic internalids (numeric) even for the accounttypes?

use ```newrec
      .getLineItemField("allocationsource", "account", 1)
      .getSelectOptions()``` to get an array of nlobjSelectOptions

<https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_n3126295.html>

check for your id in there, if its not there, you usually are gonna have problems trying to set that id

if it is there, you probably want to try netsuite support

a desperation option might be to try using newrec.setCurrentLineItemText with the text of the option

Thanks, unfortunately getting the id of the select-options gives me the internalId's of accounttypes. (OthIncome,Equity,Income,Bank). But those are the ones that I cannot set.

I've also tried using setCurrentLineItemText() but that gives me a record that don't have a value in 'account' but have '&lt; &gt;' in 'account_display'

I've created a case towards Netsuite. We'll see if they have anything to say.