# NetSuite Inventory Adjustment

**URL:** <https://connective.celigo.com/t/netsuite-inventory-adjustment/5685>\
**Category:** Integrator.io\
**Tags:** netsuite\
**Created:** [October 10, 2025, 3:27am UTC](https://connective.celigo.com/t/netsuite-inventory-adjustment/5685 "2025-10-10T03:27:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ian\_Ramos](https://avatars.discourse-cdn.com/v4/letter/i/9fc29f/32.png) [@Ian\_Ramos](https://connective.celigo.com/u/Ian_Ramos)\
**Post date:** [October 10, 2025, 3:27am UTC](https://connective.celigo.com/t/netsuite-inventory-adjustment/5685/1 "2025-10-10T03:27:49Z")

</div>

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:

```json
{
    "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

---

<div class="post-metadata">

**Author:** ![Marco\_Esteban](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@Marco\_Esteban](https://connective.celigo.com/u/Marco_Esteban)\
**Post date:** [October 10, 2025, 5:02am UTC](https://connective.celigo.com/t/netsuite-inventory-adjustment/5685/2 "2025-10-10T05:02:05Z")

</div>

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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/61a65a0a73557e0c3e0fb81800a9d03990393a16.png)

Cheers

---

<div class="post-metadata">

**Author:** ![Ian\_Ramos](https://avatars.discourse-cdn.com/v4/letter/i/9fc29f/32.png) [@Ian\_Ramos](https://connective.celigo.com/u/Ian_Ramos)\
**Post date:** [October 13, 2025, 9:10pm UTC](https://connective.celigo.com/t/netsuite-inventory-adjustment/5685/3 "2025-10-13T21:10:26Z")

</div>

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;