Adjustment Line — entity reference

One stock correction on an adjustment: an item, SKU, lot and storage location, a quantity, a unit cost and an Adjustment Type that decides which stock bucket and ledger entry type posting uses. Saving a line posts nothing; the adjustment's Post Inventory posts every line without an Inventory Ledger reference. Once posted, a Quantity or Unit Cost edit posts a reversal and a replacement and a delete posts a reversal. Item, SKU, Item Lot and Storage Location cannot be changed after the line is saved.

Fields

Field	Label	Type	Required	What it does
`AdjustmentId`	Inventory Adjustment	Lookup → Adjustment	Yes	The adjustment the line belongs to; its partner account and branch decide whose stock moves.
`AdjustmentType`	Adjustment Type	PickList		The reason for the correction. Empty: a positive Quantity adds to Positive Adjusted and a negative one to Negative Adjusted. Excess, Shortage, Damaged and Expired post to their own buckets, only for quantities above zero. OnHold and OnLoan post to their buckets and accept negative quantities to release stock. Assemble and Disassemble both post into Assembled In and generate no component lines. Changing the type on a posted line does not re-post it. Values: Expired, Damaged, OnLoan, Shortage, Assemble, Excess, OnHold, Disassemble.
`ClaimBatchId`	Claim Batch	Lookup → ClaimBatch		A claim batch reference. Not filled by the standard claim settlement.
`ClaimId`	Claim	Lookup → Claim		The claim a settlement-created line came from.
`ClaimLineId`	Claim Line	Lookup → ClaimLine		The claim line whose approved quantity a claim settlement wrote to this line.
`ConversionRatio`	Conversion Ratio	Number
`ConversionRatio1`	Conversion Ratio 1	Number
`CreatedById`	Created By	Lookup → UserAccount	Yes
`CreatedDateTime`	Created Date	DateAndTime	Yes
`CycleCountLineId`	Cycle Count Line	Lookup → CycleCountLine		The counted line that produced this line on a cycle count release: one untyped signed line for the difference, plus Damaged and Expired lines for recorded damaged and expired quantities.
`DamagedQuantity`	Damaged Quantity	Calculated (calculated)		Calculated: equals Quantity when the type is Damaged, otherwise 0. The damaged ledger setting posts from it.
`ExcessQuantity`	Excess Quantity	Calculated (calculated)		Calculated: equals Quantity when the type is Excess, otherwise 0. The excess ledger setting posts from it.
`ExpiredQuantity`	Expired Quantity	Calculated (calculated)		Calculated: equals Quantity when the type is Expired, otherwise 0. The expiry ledger setting posts from it.
`ExternalId`	External	Text, unique
`Id`	Id	Guid	Yes
`ILPostingQuantity`	IL Posting Quantity	Calculated (calculated)		Calculated absolute value of Quantity.
`InventoryLedgerId`	Inventory Ledger	Lookup → InventoryLedger		The ledger entry the line posted. Set only by posting; Post Inventory skips lines that already have it, which makes repeated posting safe.
`IsILPosted`	IL Posted	Boolean	Yes	Never set by any process and protected against edits; use Inventory Ledger to see whether a line is posted.
`IsILPostingApproved`	IL Posting Approved	Boolean	Yes	Not checked by adjustment posting.
`ItemComponentId`	Item Component	Lookup → ItemComponent		A bill-of-materials component reference. No standard process fills it, because Assemble and Disassemble lines generate no component lines.
`ItemId`	Item	Lookup → Item	Yes	The item corrected. Required; must be active and inventory-tracked. Not editable after saving.
`ItemLotId`	Item Lot	Lookup → ItemLot		The batch or serial corrected. Required for lot-tracked items, both on save and at posting. Not editable after saving.
`ItemLotTypeId`	Item Lot Type	Lookup → ItemLotType		The lot type recorded on the ledger entry.
`ModifiedById`	Modified By	Lookup → UserAccount	Yes
`Name`	Line Number	Text		The line's number, assigned from the IAL document-name series.
`OwnerId`	Owner	Lookup → UserAccount	Yes
`ParentLineId`	Parent Line	Lookup → AdjustmentLine		A parent-line reference. No standard process creates child lines; deleting a line also deletes any lines that point to it.
`PriceAsOnDate`	Price As On Date	Date		A line-level pricing date. Not on the shipped forms; changing it re-prices the line.
`PriceListId`	Price List	Lookup → PriceList		A line-level price list. Not on the shipped forms; pricing uses the header's price list.
`Quantity`	Quantity	Number		The size of the correction, default 0. Its sign gives the direction for untyped, OnHold, OnLoan and Assemble lines. An untyped line with quantity 0 posts nothing.
`RecordTypeId`	Record Type	Guid, hidden
`Remarks`	Remarks	Text		Free text for the evidence reference. Not on the shipped line forms.
`ShortageQuantity`	Shortage Quantity	Calculated (calculated)		Calculated: equals Quantity when the type is Shortage, otherwise 0. The shortage ledger setting posts from it.
`SKUId`	SKU	Lookup → SKU		The item's variant, limited to SKUs of the item and required when the item needs one. Not editable after saving.
`StorageLocationId`	Storage Location	Lookup → StorageLocation		The bin whose stock row is corrected. Not on the shipped Quick Add form and not editable after saving, so hand-entered lines post to the stock row with no location unless an administrator adds the field to the form. Lines from a cycle count carry the count line's location.
`TotalCost`	Total Cost	Currency		Not calculated and not filled by posting. Use Quantity times Unit Cost.
`UIProps`	UI Props	Text
`UnitCost`	Unit Cost	Currency		The cost per unit written to the ledger entry. Filled from the matching rule of the header's price list when left empty; a cost typed on a new line is kept. Changing the header's Price As On Date replaces it when a rule matches.
`UnitCost2`	Unit Cost 2	Currency		The secondary price from the same price-list rule. Not used by posting.
`UOM`	UOM	PickList		Values: Pack, Litres.
`UOM1`	UOM 1	PickList		Values: Each.
`UOMQuantity`	UOM Quantity	Number
`UOMQuantity1`	UOM Quantity 1	Number
`UpdatedDateTime`	Modified Date	DateAndTime	Yes

Actions

Action	Label	Type	What it does
`BulkDelete`	Delete	Delete	Delete
`Clone`	Clone	ServerAction (`Clone`)	Create a copy of this record
`Delete`	Delete	Delete	Delete
`DeleteInList`	Delete	Delete	Delete
`Edit`	Edit	Edit	Edit
`EditInLine`	Edit	Edit	Edit
`EditInLineEntity`	Edit	EditInline	Edit
`New`	New	New	New
`NewInLine`	Quick Add	NewInline	New
`PostInventory`	Post Inventory	UIAction	Post from the parent document's Perform Inventory Posting, which picks up every line that has no InventoryLedgerId yet.

Validations

Validation	Applies to	Error message	Notes
Item Required Validation	`ItemId`, Error	Selection of Item is Mandatory.	Selection of Item is Mandatory.
Quantity Validation On Disassemble	Error, inactive	Quantity can not be positive in case of Disassemble Adjustment Type.	Quantity can not be positive in case of Disassemble Adjustment Type.
Restrict Negative Quantity	`Quantity`, Error, inactive	Quantity must be greater than 0.	Quantity must be greater than 0.
Total Cost Rule Validation	`TotalCost`, Error	Total Cost can't be negative	Total Cost can't be negative
Unit Cost Rule Validation	`UnitCost`, Error, inactive	Unit Cost can't be negative	Unit Cost can't be negative

Lookup filters

Filter	Lookup field	Notes
Sku For Item	`SKUId`

ItemComponent — looks up via ItemComponentId
PriceList — looks up via PriceListId
ClaimBatch — looks up via ClaimBatchId
UserAccount — looks up via OwnerId
ItemLot — looks up via ItemLotId
CycleCountLine — looks up via CycleCountLineId
UserAccount — looks up via ModifiedById
ClaimLine — looks up via ClaimLineId
AdjustmentLine — looks up via ParentLineId
StorageLocation — looks up via StorageLocationId
Item — looks up via ItemId
InventoryLedger — looks up via InventoryLedgerId
ItemLotType — looks up via ItemLotTypeId
UserAccount — looks up via CreatedById
SKU — looks up via SKUId
Claim — looks up via ClaimId
Adjustment — looks up via AdjustmentId
AdjustmentLine — referenced by via ParentLineId

Adjustment Line — entity reference

Fields

Actions

Validations

Lookup filters

Related entities

Related topics