Invalid price reference key -1

Integrator.io
1

Does anyone know the reason for a "Invalid price reference key -1" error from NetSuite during Sales Order creation (in a custom flow)? I know I've been able to get past it with a pretty obscure change that didn't seem related to price, but I don't remember it, so I'm hoping that writing it down is helpful next time!

2

Hi,

Through working with Netsuite, I've discovered that these types of error messages point to inactive or disabled things. Are you using a custom form for the sales order? Is the "rate" sublist field enabled on it?

3

It looks like you're trying to use -1 for custom pricing, correct?

Did you map it correctly, like this?

The image shows a UI element with a value of "-1" associated with "Items: Price Level (InternalId)" and a settings icon on the right. (Captioned by AI)

4

Yes, sort of. This is an integration I've inherited, it's works for most records, and its mapping's appearance is:

A search query shows the expression "item[*].price" with a search result of "-1" in a programming or database context. (Captioned by AI)

Which renders to:

{
    ...
    "nlobjSublistIds": {
        "item": {
            "lines": [
                {
                    "item": "item123",
                    "quantity": 1,
                    "price": "-1",
                    ...
                    "rate": "71"
                }
            ]
        }
    }
}
5

That does sound familiar, I haven't checked active/inactive Item records yet.
The mappings are not specifying which form to use but the mappings are mapping to the Items : NS Item Rate field, which I assume was customized by the client since the Output renders it as

{
   ...
   "nlobjSublistIds": {
       "item": {
         "lines": [
            {
               "rate": 123
...etc

I think it's also one of those errors that sometimes just goes away for me if I re-create the component in SuiteScript 1.0 mode, but this one was already in that mode.

6

Oh, I think I did check the items' Inactive state before. Both items on the record correspond to already-active item records in NetSuite.

Where is the "rate" sublist field enabled, is it on the form? Almost all records flow through this successfully.