Logistics.Inventory.BalancesAtDate View
Namespace: Logistics.Inventory
The inventory balances at specific date, grouped by storage key (Store, Product, Lot, etc.). Entity: Inv_Balances_At_Date (Introduced in version 25.1.1.62)
Default Visualization
Default Display Text Format:
{BaseCostValue}: {Date}
Default 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 balaces. In the result it is always null. 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 unit. Unit: 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. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id |
| Lot | Lots (nullable) | If non-null, contains the specific lot to use for the movement. Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Lot_Id |
| Product | Products | The product. Required Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Product_Id |
| ProductVariant | ProductVariants (nullable) | If specified determines which product variant of the current product in this line is used. Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Product_Variant_Id |
| SerialNumber | SerialNumbers (nullable) | Item serial number for serialized items. null for non-serialized items. Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Serial_Number_Id |
| Store | Stores | The store. Required Filter(multi eq) Inherited from Inv_Transactions_Table.Store_Id |
| StoreBin | StoreBins (nullable) | Store bin, from/to which the transaction was performed. Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Store_Bin_Id |
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 balaces. In the result it is always null. Required Filter(eq)
Type: date
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
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 unit. Unit: 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. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id
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. Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Lot_Id
Type: Lots (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Lot_Id
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault
Product
The product. Required Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Product_Id
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. Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Product_Variant_Id
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. Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Serial_Number_Id
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. Required Filter(multi eq) Inherited from Inv_Transactions_Table.Store_Id
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. Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Store_Bin_Id
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 Query: https://demodb.my.erp.net/api/domain/odata/Logistics_Inventory_BalancesAtDate?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_BalancesAtDate?$top=10