Logistics.Inventory.BalancesAtDate (View)
View past inventory balances as they were on a specific date. Filter by the 'Date' column to select the date for which you want to retrieve stock levels. This report provides a snapshot of inventory at that moment in time, helping with audits, stock analysis, and historical tracking.
General
Namespace: Logistics.Inventory
Repository: Logistics.Inventory.BalancesAtDate
Introduced In Version: 25.1.1.62
API access: ReadWrite
Visualization
Display Format: {BaseCostValue}: {Date}
Search Members:
Category: Views
Show in UI: ShownByDefault
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| BaseCost | Amount (38, 2) | The cost of the inventory in base currency of the enterprise company.Currency: EnterpriseCompany.BaseCurrency Required |
| Date | date | The date parameter used to compute the balances.Required Filter(eq) |
| ProductCost | Amount (38, 2) | The cost of the inventory in the products currency.Currency: Product.CostingCurrency Required |
| QuantityBase | Quantity (38, 3) | The quantity of the stock received/issued in base measurement unitUnit: Product.BaseMeasurementCategory.BaseUnit Required |
| StoreCost | Amount (38, 2) | The cost of the inventory in the stores currency.Currency: Store.Currency Required |
References
| Name | Type | Description |
|---|---|---|
| EnterpriseCompany | EnterpriseCompanies | The enterprise company |
| Lot | Lots (nullable) | If non-null, contains the specific lot to use for the movement |
| Product | Products | The product |
| ProductVariant | ProductVariants (nullable) | If specified determines which product variant of the current product in this line is used. |
| SerialNumber | SerialNumbers (nullable) | Item serial number for serialized items. NULL for non-serialized items |
| Store | Stores | The store |
| StoreBin | StoreBins (nullable) | Store bin, from/to which the transaction was performed. |
Attribute Details
BaseCost
The cost of the inventory in base currency of the enterprise company.Currency: EnterpriseCompany.BaseCurrency Required
Type: Amount (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Date
The date parameter used to compute the balances.Required Filter(eq)
Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
ProductCost
The cost of the inventory in the products currency.Currency: Product.CostingCurrency Required
Type: Amount (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
QuantityBase
The quantity of the stock received/issued in base measurement unitUnit: Product.BaseMeasurementCategory.BaseUnit Required
Type: Quantity (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
StoreCost
The cost of the inventory in the stores currency.Currency: Store.Currency Required
Type: Amount (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
EnterpriseCompany
The enterprise company
Type: EnterpriseCompanies
Category: System
Inherited From: Gen_Documents_Table.Enterprise_Company_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Lot
If non-null, contains the specific lot to use for the movement
Type: Lots (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Lot_Id
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault
Product
The product
Type: Products
Category: System
Inherited From: Inv_Transaction_Lines_Table.Product_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
ProductVariant
If specified determines which product variant of the current product in this line is used.
Type: ProductVariants (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Product_Variant_Id
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault
SerialNumber
Item serial number for serialized items. NULL for non-serialized items
Type: SerialNumbers (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Serial_Number_Id
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault
Store
The store
Type: Stores
Category: System
Inherited From: Inv_Transactions_Table.Store_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
StoreBin
Store bin, from/to which the transaction was performed.
Type: StoreBins (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Store_Bin_Id
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault
API
Domain API Entity Set: Logistics_Inventory_BalancesAtDate
Domain API Entity Type: Logistics_Inventory_BalancesAtDateEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Logistics_Inventory_BalancesAtDate?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_BalancesAtDate?$top=10