List all inventory adjustments

QuickBooks Desktop API

Core Resources

Auth Sessions
End Users

General

Accounts
Classes
Customers
Date-Driven Terms
Employees
Inventory Sites
Payroll Wage Items
Sales Representatives
Sales-Tax Codes
Standard Terms
Vendors

Transactions

Bill Check Payments
Bill Credit Card Payments
Bills
Checks
Credit Card Charges
Credit Card Credits
Credit Memos
Estimates
Inventory Adjustments
Invoices
Journal Entries
Purchase Orders
Receive-Payments
Sales Orders
Sales Receipts
Time Tracking Activities
Transfers
Vendor Credits

Items

Discount Items
Inventory Assembly Items
Inventory Items
Non-Inventory Items
Sales-Tax Items
Service Items
Subtotal Items

GET

quickbooks-desktop

inventory-adjustments

import Conductor from 'conductor-node';

const client = new Conductor({
  apiKey: process.env['CONDUCTOR_SECRET_KEY'], // This is the default and can be omitted
});

async function main() {
  const inventoryAdjustment = await client.qbd.inventoryAdjustments.list({
    conductorEndUserId: 'end_usr_1234567abcdefg',
  });

  console.log(inventoryAdjustment.data);
}

main();

{
  "objectType": "list",
  "url": "/v1/quickbooks-desktop/inventory-adjustments",
  "data": [
    {
      "id": "123ABC-1234567890",
      "objectType": "qbd_inventory_adjustment",
      "createdAt": "2021-10-01T17:34:56.000Z",
      "updatedAt": "2021-10-01T20:45:30.000Z",
      "revisionNumber": "1721172183",
      "account": {
        "id": "80000001-1234567890",
        "fullName": "Inventory Shrinkage"
      },
      "inventorySite": {
        "id": "80000001-1234567890",
        "fullName": "Main Warehouse"
      },
      "transactionDate": "2021-10-01T00:00:00.000Z",
      "refNumber": "INVADJ-1234",
      "customer": {
        "id": "80000001-1234567890",
        "fullName": "Acme Corporation"
      },
      "class": {
        "id": "80000001-1234567890",
        "fullName": "Inventory Adjustment"
      },
      "memo": "Adjusted quantity due to physical count discrepancy",
      "externalId": "12345678-abcd-1234-abcd-1234567890ab",
      "lines": [
        {
          "id": "456DEF-1234567890",
          "objectType": "qbd_inventory_adjustment_line",
          "item": {
            "id": "80000001-1234567890",
            "fullName": "Widget A"
          },
          "serialNumber": "SN1234567890",
          "serialNumberAction": "added",
          "lotNumber": "LOT2023-001",
          "expirationDate": "2025-12-31T00:00:00.000Z",
          "inventorySiteLocation": {
            "id": "80000001-1234567890",
            "fullName": "Aisle 3, Shelf B"
          },
          "quantityDifference": 5,
          "valueDifference": 7
        }
      ],
      "customFields": [
        {
          "ownerId": "0",
          "name": "Customer Rating",
          "type": "string_1024_type",
          "value": "Premium"
        }
      ]
    }
  ]
}

Authorizations

Authorization

string

header

required

Your Conductor secret key using Bearer auth (e.g., "Authorization: Bearer {{YOUR_SECRET_KEY}}").

Headers

Conductor-End-User-Id

string

required

The ID of the EndUser to receive this request (e.g., "Conductor-End-User-Id: {{END_USER_ID}}").

Query Parameters

ids

string[]

Filter for specific inventory adjustments by their QuickBooks-assigned unique identifier(s).

IMPORTANT: If you include this parameter, QuickBooks will ignore all other query parameters for this request.

NOTE: If any of the values you specify in this parameter are not found, the request will return an error.

refNumbers

string[]

Filter for specific inventory adjustments by their ref-number(s), case-sensitive. In QuickBooks, ref-numbers are not required to be unique and can be arbitrarily changed by the QuickBooks user.

IMPORTANT: If you include this parameter, QuickBooks will ignore all other query parameters for this request.

NOTE: If any of the values you specify in this parameter are not found, the request will return an error.

limit

integer

The maximum number of objects to return.

IMPORTANT: QuickBooks Desktop does not support cursor-based pagination for inventory adjustments. This parameter will limit the response size, but you cannot fetch subsequent results using a cursor. For pagination, use the name-range parameters instead (e.g., nameFrom=A&nameTo=B).

When this parameter is omitted, the endpoint returns all inventory adjustments without limit, unlike paginated endpoints which default to 150 records. This is acceptable because inventory adjustments typically have low record counts.

Required range: x > 1

updatedAfter

string

Filter for inventory adjustments updated on or after this date and time, in ISO 8601 format (YYYY-MM-DDTHH:mm:ss). If you only provide a date (YYYY-MM-DD), the time is assumed to be 00:00:00 of that day.

updatedBefore

string

Filter for inventory adjustments updated on or before this date and time, in ISO 8601 format (YYYY-MM-DDTHH:mm:ss). If you only provide a date (YYYY-MM-DD), the time is assumed to be 23:59:59 of that day.

transactionDateFrom

string

Filter for inventory adjustments created on or after this date, in ISO 8601 format (YYYY-MM-DD).

transactionDateTo

string

Filter for inventory adjustments created on or before this date, in ISO 8601 format (YYYY-MM-DD).

customerIds

string[]

Filter for inventory adjustments associated with these customers.

accountIds

string[]

Filter for inventory adjustments associated with these accounts.

itemIds

string[]

Filter for inventory adjustments containing these inventory items.

refNumberContains

string

Filter for inventory adjustments whose refNumber contains this substring. NOTE: If you use this parameter, you cannot also use refNumberStartsWith or refNumberEndsWith.

refNumberStartsWith

string

Filter for inventory adjustments whose refNumber starts with this substring. NOTE: If you use this parameter, you cannot also use refNumberContains or refNumberEndsWith.

refNumberEndsWith

string

Filter for inventory adjustments whose refNumber ends with this substring. NOTE: If you use this parameter, you cannot also use refNumberContains or refNumberStartsWith.

refNumberFrom

string

Filter for inventory adjustments whose refNumber is greater than or equal to this value. If omitted, the range will begin with the first number of the list. Uses a numerical comparison for values that contain only digits; otherwise, uses a lexicographical comparison.

refNumberTo

string

Filter for inventory adjustments whose refNumber is less than or equal to this value. If omitted, the range will end with the last number of the list. Uses a numerical comparison for values that contain only digits; otherwise, uses a lexicographical comparison.

includeLineItems

boolean

default:

true

Whether to include line items in the response. Defaults to true.

Response

200 - application/json

Returns a list of inventory adjustments.

objectType

string

required

The type of object. This value is always "list".

Allowed value: "list"

url

string

required

The endpoint URL where this list can be accessed.

data

object[]

required

The array of inventory adjustments.

data.id

string

required

The unique identifier assigned by QuickBooks to this inventory adjustment. This ID is unique across all transaction types.

data.objectType

string

required

The type of object. This value is always "qbd_inventory_adjustment".

Allowed value: "qbd_inventory_adjustment"

data.createdAt

string

required

The date and time when this inventory adjustment was created, in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm). The time zone is the same as the user's time zone in QuickBooks.

data.updatedAt

string

required

The date and time when this inventory adjustment was last updated, in ISO 8601 format (YYYY-MM-DDThh:mm:ss±hh:mm). The time zone is the same as the user's time zone in QuickBooks.

data.revisionNumber

string

required

The current QuickBooks-assigned revision number of this inventory adjustment object, which changes each time the object is modified. When updating this object, you must provide the most recent revisionNumber to ensure you're working with the latest data; otherwise, the update will return an error.

data.account

object

required

The account to which this inventory adjustment is posted for tracking inventory value changes.

data.inventorySite

object | null

required

The site location where inventory for the item associated with this inventory adjustment is stored.

data.transactionDate

string

required

The date of this inventory adjustment, in ISO 8601 format (YYYY-MM-DD).

data.refNumber

string | null

required

The case-sensitive user-defined reference number for this inventory adjustment, which can be used to identify the transaction in QuickBooks. This value is not required to be unique and can be arbitrarily changed by the QuickBooks user.

data.customer

object | null

required

The customer or customer-job associated with this inventory adjustment.

data.class

object | null

required

The inventory adjustment's class. Classes can be used to categorize objects into meaningful segments, such as department, location, or type of work. In QuickBooks, class tracking is off by default. A class defined here is automatically used in this inventory adjustment's line items unless overridden at the line item level.

data.memo

string | null

required

A memo or note for this inventory adjustment.

data.externalId

string | null

required

A globally unique identifier (GUID) you, the developer, can provide for tracking this object in your external system. This field is immutable and can only be set during object creation.

data.lines

object[]

required

The inventory adjustment's item lines, each representing the adjustment of an inventory item's quantity, value, serial number, or lot number.

data.lines.id

string

required

The unique identifier assigned by QuickBooks to this inventory adjustment line. This ID is unique across all transaction line types.

data.lines.objectType

string

required

The type of object. This value is always "qbd_inventory_adjustment_line".

Allowed value: "qbd_inventory_adjustment_line"

data.lines.item

object | null

required

The inventory item associated with this inventory adjustment line.

data.lines.serialNumber

string | null

required

The serial number of the item associated with this inventory adjustment line. This is used for tracking individual units of serialized inventory items.

data.lines.serialNumberAction

enum<string> | null

required

Indicates whether this inventory adjustment line's serial number was added or removed from the inventory.

Available options:

added,

removed

data.lines.lotNumber

string | null

required

The lot number of the item associated with this inventory adjustment line. Used for tracking groups of inventory items that are purchased or manufactured together.

data.lines.expirationDate

string | null

required

The expiration date for the serial number or lot number of the item associated with this inventory adjustment line, in ISO 8601 format (YYYY-MM-DD). This is particularly relevant for perishable or time-sensitive inventory items. Note that this field is only supported on QuickBooks Desktop 2023 or later.

data.lines.inventorySiteLocation

object | null

required

The specific location (e.g., bin or shelf) within the inventory site where the item associated with this inventory adjustment line is stored.

data.lines.quantityDifference

number | null

required

Either a positive or negative number that shows the change in quantity for the inventory item associated with this inventory adjustment line. A positive number increases the quantity, while a negative number decreases it.

data.lines.valueDifference

number | null

required

Either a positive or negative number that shows the change in the total value of the entire stock of the inventory item associated with this inventory adjustment line. A positive number increases the value, while a negative number decreases it.

data.customFields

object[]

required

The custom fields for the inventory adjustment object, added as user-defined data extensions, not included in the standard QuickBooks object.

Retrieve an inventory adjustment Delete an inventory adjustment

import Conductor from 'conductor-node';

const client = new Conductor({
  apiKey: process.env['CONDUCTOR_SECRET_KEY'], // This is the default and can be omitted
});

async function main() {
  const inventoryAdjustment = await client.qbd.inventoryAdjustments.list({
    conductorEndUserId: 'end_usr_1234567abcdefg',
  });

  console.log(inventoryAdjustment.data);
}

main();

{
  "objectType": "list",
  "url": "/v1/quickbooks-desktop/inventory-adjustments",
  "data": [
    {
      "id": "123ABC-1234567890",
      "objectType": "qbd_inventory_adjustment",
      "createdAt": "2021-10-01T17:34:56.000Z",
      "updatedAt": "2021-10-01T20:45:30.000Z",
      "revisionNumber": "1721172183",
      "account": {
        "id": "80000001-1234567890",
        "fullName": "Inventory Shrinkage"
      },
      "inventorySite": {
        "id": "80000001-1234567890",
        "fullName": "Main Warehouse"
      },
      "transactionDate": "2021-10-01T00:00:00.000Z",
      "refNumber": "INVADJ-1234",
      "customer": {
        "id": "80000001-1234567890",
        "fullName": "Acme Corporation"
      },
      "class": {
        "id": "80000001-1234567890",
        "fullName": "Inventory Adjustment"
      },
      "memo": "Adjusted quantity due to physical count discrepancy",
      "externalId": "12345678-abcd-1234-abcd-1234567890ab",
      "lines": [
        {
          "id": "456DEF-1234567890",
          "objectType": "qbd_inventory_adjustment_line",
          "item": {
            "id": "80000001-1234567890",
            "fullName": "Widget A"
          },
          "serialNumber": "SN1234567890",
          "serialNumberAction": "added",
          "lotNumber": "LOT2023-001",
          "expirationDate": "2025-12-31T00:00:00.000Z",
          "inventorySiteLocation": {
            "id": "80000001-1234567890",
            "fullName": "Aisle 3, Shelf B"
          },
          "quantityDifference": 5,
          "valueDifference": 7
        }
      ],
      "customFields": [
        {
          "ownerId": "0",
          "name": "Customer Rating",
          "type": "string_1024_type",
          "value": "Premium"
        }
      ]
    }
  ]
}