Please can I have suggestions on why I cannot add a particular item to an invoice in SS2? This is my code:

rec.selectNewLine({
    sublistId: 'item'
});

rec.setCurrentSublistValue({
    sublistId: 'item',
    fieldId: 'item',
    value: lineData.itemInternalId
});

This error occurs on the second statement above:

"type":"error.SuiteScriptError","name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value 25542 for the following field: item"

The error happens for that item internal id only. If I use other item internal id values then the line is added and the invoice is created successfully. If I create the invoice manually for the same customer and location then I can add the item without issue. I welcome all suggestions of what to check for.

Can you please verify the subsidiary of the Item and Customer?

I should say that the item is "Other Charge for Sale"

can you check if the item is inactive or not?

It's not inactive (remember that I can add it to an invoice manually - the error only happens in my Suitelet)

Yes, you can add it manually.

It's not inactive

What about subsidiary?

Subsidiary is exactly the same as other items that my script can add to the invoice

@cja is lineData.itemInternalId a String by any chance?

The JSON is like this:

{
  "itemInternalId": "25542",
  "quantity": 1,
  "rate": 0.05,
  "amount": 0.05,
  "vatAmt": 0,
  "grossAmount": 0.05
}

That would be why. I would have said it’s a string.

I will test as you say, but here's a line that is added successfully:

{
  "itemInternalId": "25439",
  "quantity": "1.00000000",
  "rate": 3,
  "amount": 2.5,
  "grossAmount": 2.5
}

hmmmm and the only difference its the item type?

Well, when I diff the XML for the bad record and a good record there are lots of differences, but I can't make them identical

Those Quantity values look a bit different

They are, but the code doesn't get to there. The error is on this statement:

rec.setCurrentSublistValue({
    sublistId: 'item',
    fieldId: 'item',
    value: lineData.itemInternalId
});

In console can you manually set the item to the id 25542

I've never done anything in the console with NS before. How do I do that?

Easiest is with SS1.0

I changed the code to the following and got the same error:

rec.setCurrentSublistValue({
            sublistId: 'item',
            fieldId: 'item',
            value: lineData.itemInternalId.toString()
        });

did you try the parseInt

Trying now

That is odd.

Probably not. Looking now...

yes. Just to see if that is the common denominator

Same error with another Other Charge item

I would have it is the other charge items not going on.

It looks like it

If it adds normal items no problem then gotta be the type.

Thank you for your help. If you have any other ideas I will be grateful

Do you have full NS Support?

is the custom form used in the script the same as the ui?

Good idea. Checking...

I would pay!!

Me too, but it should be very expensive!

Best advice for getting fastest help from support on script issues. Create a very small scheduled script, with as few lines of code as possible, to reproduce the issue. Then attach it to the case. It helps them focus on the problem, and not get distracted by other things going on in your larger script.

@scottvonduhn Thanks, that's good advice

i say make the suitelet run as administrator

Now that's a good idea. Doing it now...

i doubt the problem is that the value is the wrong type. Its likely thats its simply not a valid option

Same error when the Suitelet's role is Administrator

You can create a Non-Inventory item and use it as a processing fee as an alternate solution since of the other worked.

Thank you, I am doing that now

Gotta be Other Charge for some reason then.

I think it's likely, although it could be something else about the items I'm trying, but I've no time to experiment further