NetSuite Inventory Adjustment

Integrator.io
1

Having an issue importing Inventory Adjustment to NetSuite, it will accept positive stock adjustments with no issues. I can create negative stock adjustments within the NetSuite UI, but with Celigo it seems to be converting my stock adjustment to a positive value on import.

Here is my JSON below:

{
    "nlobjFieldIds": {
        "customform": 144,
        "subsidiary": 2,
        "account": "5262 Stock Adjustments",
        "adjlocation": "Test Park",
        "memo": "Unprocessed IBC Consumed",
        "class": "IBCs",
        "celigo_write_log": "true",
        "celigo_recordmode_dynamic": "true"
    },
    "nlobjSublistIds": {
        "inventory": {
            "lines": [
                {
                    "item": "U_IBC1000_A",
                    "location": "Test Park",
                    "adjustqtyby": -30
                },
                {
                    "item": "U_IBC1000_ADG",
                    "location": "Test Park",
                    "adjustqtyby": -10
                },
                {
                    "item": "U_IBC1000_AFR",
                    "location": "Test Park",
                    "adjustqtyby": -10
                },
                {
                    "item": "U_IBC1000_AFREV",
                    "location": "Test Park",
                    "adjustqtyby": -30
                },
                {
                    "item": "U_IBC1000_ATP",
                    "location": "Test Park",
                    "adjustqtyby": -10
                },
                {
                    "item": "U_IBC1000_AUV-B",
                    "location": "Test Park",
                    "adjustqtyby": -10
                },
                {
                    "item": "U_IBC1000_AUV-BLU",
                    "location": "Test Park",
                    "adjustqtyby": -10
                },
                {
                    "item": "U_IBC1000_AUV-W",
                    "location": "Test Park",
                    "adjustqtyby": -10
                },
                {
                    "item": "U_IBC1000_B",
                    "location": "Test Park",
                    "adjustqtyby": -10
                }
            ]
        }
    }
}

Assistance would be greatly appreciated

2

Hi Ian,

Did you happen to set the data type Adjustments : Adjust Qty. By to Number?

If yes, I think it tries to remove the negative thus posting it as a positive adjustment.

image
image707×355 17.4 KB

Cheers

3

Hi Marco, I did change the type to Number.

I have changed it back to the default however, I am now getting an error in regard to the Inventory Detail even after following the documentation of setting up the inventory detail sub record

Thanks;