Field descriptions: Stock journal inquiry

Criteria block

Field Description
From item
To item
The range of items.
Site The site at which the item is stocked.

Results block

Field Description
Amount variance The amount variance of the item.
Cost variance The cost variance of the item.
Currency The financial site currency for the item.
Currency ID The unique identifier of the currency.
Date The document date.
Document The document that records the stock activity.
Document line type The category of the document line that records the stock activity.
Expiry date The item expiry date.
Item The name of the item.
Item ID

The code that identifies the item.

When you create an item and integrate with Sage Intacct, you cannot modify the item ID.

Location The location where the item is stocked.
Location ID The unique identifier of the location. This is the field used by default in search and selection fields in the product.
Location zone The storage zone where the location is situated.
Lot The item lot number.
Movement amount The item standard or average total cost.
Non-absorbed amount The difference between the receipt total cost and the invoice total cost, that cannot be apportioned across the stock quantity originally receipted.
Order amount The total cost for the order based on the item total quantity.
Order cost The item unit cost.
Quantity The quantity of the item.
Reason code The reason for the change in stock value, for example a landed cost adjustment or stock value correction.
Site The site at which the item is stocked.
Site ID The descriptive ID of the site. You can change it any time because this is not the technical ID of the site.
Status The stock status of the item.
Sublot The item sublot number.
Supplier lot number The supplier lot number.
Unit of measure The unit of measure for the item.
Valued cost The item valued cost.