Inventory adjustments
A correction of the on-hand quantity of an item at one site, area and location.
- API name:
inventoryadjustments - Domain: Inventory
- Modules: Inventory analytics, Inventory
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Name | label | Text | ||
| Number | uid | Text | The number is a human-readable, unique identifier for the record. | |
| Day | date | Date | Yes | Calendar date for this value. |
| On hand | onhand | Quantity | Yes | Target on-hand at this location. Create posts the difference from the captured baseline. |
| Available | available | Quantity | Yes | Derived available quantity: on-hand minus on-hold. |
| On hold | onhold | Quantity | Yes | Target on-hold quantity. Create posts the difference from the captured baseline. |
| Catalog | catalog | Constant | Fixed option from the allowed set for this field. | |
| Unit | catalogunit | Unit | ||
| Item | productitemId | Reference | ||
| Item | customitemId | Reference | ||
| Identifier | inventoryidentifierId | Reference | ||
| Location | sitelocationId | Reference | Yes | |
| Zone | siteareaId | Reference | Yes | |
| Reason | reason | Option (Select) | Yes | Why this adjustment was made. The organization defines this list and can add a reason. |
| Tags | tagIds | Tags | ||
| Description | description | Text Area | ||
| Created by | createdBy | User | ||
| Created at | createdAt | Date and Time | Yes | |
| Updated by | updatedBy | User | ||
| Updated at | updatedAt | Date and Time | Yes | |
| Canceled by | canceledBy | User | ||
| Canceled at | canceledAt | Date and Time | ||
| Blocked by | blockedBy | User | ||
| Blocked at | blockedAt | Date and Time | ||
| Archived by | archivedBy | User | ||
| Archived at | archivedAt | Date and Time |
Relations
| Field | Points to | Kind |
|---|---|---|
Identifier inventoryidentifierId | Inventory identifiers | reference |
Location sitelocationId | Site locations | reference |
Zone siteareaId | Site areas | reference |
Tags tagIds | Tags | reference |
Actions
What you can do with a record. Every action also sends the webhook event inventoryadjustments.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add an new adjustment. | App · API · MCP · CLI |
| Edit | update | Save changes to this adjustment. | App · API · MCP · CLI |
| Cancel | cancel | Reverse the posted effect of this adjustment. | App · API · MCP · CLI |
| Block | block | Stop edits and deletion of this adjustment. It stays visible and can still appear on existing documents. Unblock to edit again. | App · API · MCP · CLI |
| Unblock | unblock | Allow edits and deletion of this adjustment again. | App · API · MCP · CLI |
| Archive | archive | Retire this adjustment from daily use. It leaves active lists and pickers, and most actions stop. Unarchive to restore it. | App · API · MCP · CLI |
| Restore | unarchive | Return this adjustment to active lists and actions. | App · API · MCP · CLI |
| Delete | delete | Delete this adjustment and the data that belongs with it. This cannot be undone. | App · API · CLI |
States
How a record moves from state to state. Archive and block can happen in any state.