Logistics.Inventory.CurrentBalances View
Namespace: Logistics.Inventory
The current inventory balances, grouped by storage key (Store, Product, Lot, etc.). Entity: Inv_Current_Balances (Introduced in version 22.1.4.33)
Default Visualization
Default Display Text Format:
{BaseCostValue}: {EnterpriseCompanyId}
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 Filter(ge;le) |
| 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 Filter(eq;ge;le) ReadOnly |
| 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 which issued the document. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id Introduced in version 24.1.0.7 |
| 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 Introduced in version 24.1.0.7 |
| Product | Products | The item that was received/issued. Required Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Product_Id Introduced in version 24.1.0.7 FilterableReference |
| 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 Introduced in version 24.1.0.7 |
| 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 Introduced in version 24.1.0.7 |
| Store | Stores | The store from which the goods are received or issued. Required Filter(multi eq) Inherited from Inv_Transactions_Table.Store_Id Introduced in version 24.1.0.7 |
| 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 Introduced in version 24.1.0.7 |
Attribute Details
BaseCost
The cost of the inventory in base currency of the enterprise company. Currency: EnterpriseCompany.BaseCurrency Required Filter(ge;le)
Type: Amount (38, 2)
Category: System
Supported Filters: 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 Filter(eq;ge;le) ReadOnly
Type: Quantity (38, 3)
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: False
Show in UI: HiddenByDefault
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 which issued the document. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id Introduced in version 24.1.0.7
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 Introduced in version 24.1.0.7
Type: Lots (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Lot_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Product
The item that was received/issued. Required Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Product_Id Introduced in version 24.1.0.7 FilterableReference
Type: Products
Category: System
Inherited From: Inv_Transaction_Lines_Table.Product_Id
Supported Filters: Equals, EqualsIn
Filterable Reference: True
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 Introduced in version 24.1.0.7
Type: ProductVariants (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Product_Variant_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
SerialNumber
Item serial number for serialized items. null for non-serialized items. Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Serial_Number_Id Introduced in version 24.1.0.7
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 from which the goods are received or issued. Required Filter(multi eq) Inherited from Inv_Transactions_Table.Store_Id Introduced in version 24.1.0.7
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 Introduced in version 24.1.0.7
Type: StoreBins (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Store_Bin_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
API
Domain API Query: https://demodb.my.erp.net/api/domain/odata/Logistics_Inventory_CurrentBalances?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_CurrentBalances?$top=10