Inventory valuation adjustments
An adjustment to inventory value for additional or corrected costs, such as freight, customs, landed costs or period-end adjustments.
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Item | productitemId | Reference | ||
| Quantity | quantity | Quantity | Yes | Founding layer quantity at adjust time. |
| Quantity remaining | quantityRemaining | Quantity | Yes | Remaining quantity on the layer at adjust time. |
| Consumed quantity | quantityConsumed | Quantity | Yes | Quantity already consumed from the layer at adjust time. |
| Item | customitemId | Reference | ||
| Cost layer | inventorycostlayerId | Reference | Yes | |
| Catalog | catalog | Constant | Yes | Fixed option from the allowed set for this field. |
| Record | tableUid | Constant | Yes | Business table this row points to. |
| Record ID | recordId | Reference | Yes | |
| Amount | amount | Unit price | Yes | Total adjustment value in the layer currency. Positive increases cost; negative decreases it. |
| Unit cost change | unitCostDelta | Signed amount | Yes | Monetary amount in the applicable currency for this record. |
| Capitalized amount | amountCapitalized | Unit price | Yes | Portion of the adjustment that adds cost to the layer. |
| Revaluation amount | amountRevaluation | Signed amount | Yes | Portion of the adjustment that changes the layer value without adding quantity. |
| Excess over carrying value | amountExcess | Signed amount | Yes | Reduction that does not fit in the layer carrying value. Posts to inventory adjustment. |
| Prior unit cost | unitCostBefore | Unit price | Yes | Layer unit cost immediately before this adjustment. |
| New unit cost | unitCost | Unit price | Yes | Layer unit cost after the adjustment. |
| Created by | createdBy | User | ||
| Created at | createdAt | Date and Time | Yes | |
| 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 |
|---|---|---|
Cost layer inventorycostlayerId | Inventory cost layers | reference |