Good afternoon all - I've got a workflow action script that I am trying to set the account field on and it's being difficult. I tried the internalid, the account number, the account name and keep getting: You have entered an Invalid Field Value XXX for the following field: account

in general you set fields using internal id number, and it has to be a valid choice for the record. that means valid subsidiary and the like

yes - I created the bill in the UI under the same transform scenario and pull the internalid of an account that is a valid UI option

what does your code look

vendor_bill.setSublistValue({ sublistId: 'expense', fieldId: 'account', value: expense.account, line: eCount });

i cant really tell anything from that code beyond you are setting the account of the expense sublist

it must be related to sub or something because one of the other account ids work

but if you have a valid internal id in the value and a valid line in the line, then it looks normal

yeah, the code is a bit convoluted so I didn't want to distract

as i mentioned earlier, check that the subsidiary is valid for the account

perhaps it's that it must be an expense account?

if you can set that account in the ui, you should be able to set it in the script

that's where I am seeing the discrepancy. it's the vendor's sub that is relevant here right?

i was about to say you cant select a non posting account in the ui so its unlikely that you can in script

I could definitely select it in the UI, although I did not attempt to save it, likely that it would stop me there.