Inventory opening balances
The starting inventory quantities and costs of a site when it comes online.
- API name:
inventoryopeningbalances - 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. |
| User | userId | User | ||
| Location | sitelocationId | Reference | Yes | |
| Zone | siteareaId | Reference | Yes | |
| Tags | tagIds | Tags | ||
| Description | description | Text Area | ||
| Data | data | Data | ||
| Created by | createdBy | User | ||
| Created at | createdAt | Date and Time | Yes | |
| Updated by | updatedBy | User | ||
| Updated at | updatedAt | Date and Time | Yes | |
| Processed by | processedBy | User | ||
| Processed at | processedAt | Date and Time | ||
| 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
Owned records (solid line) are deleted with their owner. Grouped records (dashed line) can exist alone.
| Field | Points to | Kind |
|---|---|---|
User userId | Users | 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 inventoryopeningbalances.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add an new opening balance. | App · API · MCP · CLI |
| Edit | update | Save changes to this opening balance. | App · API · MCP · CLI |
| Process | process | Post this opening balance. You cannot undo it. | App · API · MCP · CLI |
| Cancel | cancel | Reverse the posted effect of this opening balance. | App · API · MCP · CLI |
| Block | block | Stop edits and deletion of this opening balance. 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 opening balance again. | App · API · MCP · CLI |
| Archive | archive | Retire this opening balance 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 opening balance to active lists and actions. | App · API · MCP · CLI |
| Delete | delete | Delete this opening balance and the data that belongs with it. This cannot be undone. | App · API · MCP · CLI |
States
How a record moves from state to state. Archive and block can happen in any state.