Logistics.Inventory.CurrentBalances (View)
The current inventory balances, grouped by storage key (Store, Product, Lot, etc.).
General
Namespace: Logistics.Inventory
Repository: Logistics.Inventory.CurrentBalances
Introduced In Version: 22.1.4.33
API access: ReadWrite
Visualization
Display Format: {BaseCostValue}: {EnterpriseCompanyId}
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 unitUnit: 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 |
| 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. |
| SerialNumber | SerialNumbers (nullable) | Item serial number for serialized items. NULL for non-serialized items |
| 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. |
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 unitUnit: 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
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.
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
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.
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 Entity Set: Logistics_Inventory_CurrentBalances
Domain API Entity Type: Logistics_Inventory_CurrentBalance
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Logistics_Inventory_CurrentBalances?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_CurrentBalances?$top=10