CostAdjustments
Tracks cost adjustments for item receipts or perpetual average costs, including performance optimization using REST APIs.
Columns
Name | Type | Description |
AdjustmentHeaderId [KEY] | Long | The unique identifier for the cost adjustment header, grouping related cost transactions under a single adjustment entry. This identifier ensures traceability and consolidated reporting of cost modifications in financial records. |
AdjustmentNumber | String | The unique alphanumeric identifier assigned to the cost adjustment. This identifier is used for tracking, financial reconciliation, and audit purposes within the cost management system. |
AdjustmentTypeCode | String | An abbreviation that identifies the type of cost adjustment, determining how cost updates are processed. Values include 'P-Perpetual' for ongoing cost changes, 'R-Receipt' for adjustments based on receipts, and 'L-Layer' for layered cost valuation updates. |
AdjustmentDate | Datetime | The date when the cost adjustment was made, indicating when inventory cost changes were applied in the system. This date ensures that cost updates align with financial reporting periods and inventory valuation cycles. |
AdjustmentStatusCode | String | An abbreviation that represents the current status of the adjustment, indicating its progress in the approval workflow. Values include 'P-Pending' for unapproved changes, 'S-Submitted' for adjustments awaiting review, and 'C-Voided' for canceled transactions. |
ReasonCode | String | An abbreviation that identifies the reason for the cost adjustment transaction, providing an explanation for cost updates. This abbreviation supports audit trails and compliance with financial reporting requirements. |
TransactionId | Long | The unique identifier for the transaction in the costing system. This identifier ensures accurate traceability of cost-related updates and proper alignment with inventory movements. |
CostOrganizationId | Long | The unique identifier for the cost organization responsible for managing and tracking cost transactions across inventory locations. This identifier ensures accurate financial reporting and compliance with cost accounting policies. |
CostBookId | Long | The unique identifier for the cost book associated with the adjustment. This identifier determines the financial policies, accounting rules, and valuation methods that apply to the cost update. |
ItemId | Long | The unique identifier for the inventory item being adjusted, ensuring that cost changes are applied to the correct product. This identifier maintains accuracy in stock valuation and cost reporting. |
InventoryOrganizationId | Long | The unique identifier for the inventory organization responsible for managing stock and applying cost adjustments. This identifier ensures that inventory costing is recorded correctly for financial and operational reporting. |
ReceiptQuantity | Decimal | The quantity of the item received, affecting inventory valuation and cost calculations. This value helps determine the impact of new stock on the overall inventory cost. |
QuantityOnhand | Decimal | The remaining quantity of the item in inventory after adjustments. This value ensures that stock records accurately reflect actual availability and financial valuation. |
TotalUnitCost | Decimal | The total cost per unit of the received item, used in cost valuation and inventory financial calculations. This value influences profitability analysis and cost management. |
TotalNewCost | Decimal | The total revised cost of the received item after applying the adjustment. This information impacts financial reporting, stock valuation, and the cost of goods sold (COGS). |
ValuationUnitId | Long | The unique identifier for the valuation unit, defining cost groupings within inventory accounting. This identifier ensures accurate cost tracking and reporting across different inventory segments. |
CostDate | Datetime | The date of the costing transaction for the adjustment, used to align cost updates with financial periods. This date supports historical cost tracking and ensures compliance with accounting principles. |
ReceiptNumber | String | The unique number identifying the receipt related to the transaction. This number ensures proper cost tracking, reconciliation, and validation of received inventory. |
CurrencyCode | String | An abbreviation that identifies the currency in which the cost adjustment is recorded. This abbreviation ensures proper financial alignment in multi-currency transactions and financial reporting. |
CostOrganizationName | String | The name of the cost organization responsible for managing the adjustment. This field can be reviewed and updated using the Setup and Maintenance work area under the Manage Cost Organizations task. |
CostBook | String | The name of the cost book that applies to the adjustment, determining financial policies and cost methodologies. This field can be updated using the Manage Cost Books task. |
InventoryOrganizationName | String | The name of the inventory organization where the cost adjustment is applied, ensuring accurate stock valuation and tracking. |
Item | String | The name of the inventory item affected by the cost adjustment, providing a readable reference for users managing stock valuation. |
ValuationUnit | String | The valuation unit for the adjustment, defining cost management levels. This information can be reviewed and updated using the Manage Valuation Units task. |
AdjustmentType | String | The type of adjustment being made. Values include 'Perpetual', 'Receipt', or 'Layer', which define how inventory costs are recalculated. |
AdjustmentStatus | String | The status of the adjustment ('Pending', 'Submitted', or 'Voided'), which helps track approval workflows. |
Reason | String | The reason for the cost adjustment transaction, providing an explanation for cost updates (for example, supplier price changes or corrections). |
UOMCode | String | The abbreviation that identifies the unit of measure (UOM) associated with the inventory item, ensuring consistent stock tracking. |
UOMName | String | The full name of the UOM, providing clarity on how the inventory quantity is recorded and managed. |
BindAdjustmentDate | Datetime | The date when the bound adjustment was recorded, used to link related cost adjustments and ensure accurate historical tracking. |
BindAdjustmentNumber | String | The unique number assigned to the bound adjustment, providing a reference for tracking and validating cost adjustments. |
BindAdjustmentStatus | String | The current status of the bound adjustment, indicating whether it is pending, submitted, or voided, and linking it to cost transactions and approvals. |
BindAdjustmentType | String | The category of the bound adjustment (for example, 'Perpetual', 'Receipt', or 'Layer'), determining how inventory costs are recalculated. |
BindCostBook | String | The name of the cost book linked to the bound adjustment, which defines the financial policies and rules governing cost calculations. |
BindCostOrgName | String | The name of the cost organization associated with the bound adjustment, ensuring accurate cost tracking across financial entities. |
BindItem | String | The name of the inventory item affected by the bound adjustment, ensuring that cost updates apply to the correct stock item. |
BindReason | String | The explanation for the bound adjustment, documenting the justification for the cost change (for example, corrections or supplier price updates). |
BindReceiptNumber | String | The receipt number associated with the bound adjustment, linking it to the corresponding inventory receipt for accurate cost reconciliation. |
BindValuationUnit | String | The valuation unit assigned to the bound adjustment, determining how inventory costs are grouped and reported in financial records. |
Finder | String | The reference key used to quickly search and retrieve specific cost adjustments within the system, improving efficiency in cost tracking and reporting. |