---
title: "InventorySummaryByNumber (Visma.net Financials)"
description: "Inventory Summary by Number"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.InventorySummary.InventorySummaryByNumber
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.InventorySummary.InventorySummaryByNumber
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# InventorySummaryByNumber: Visma.net Financials Inventory Summary by Number

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `InventorySummary`
- Label: Inventory Summary by Number

Get a range of InventorySummary - ScreenId=IN401000

Can only retrieve data.

## API Source

- Endpoint: `/v1/inventorysummary/{inventoryNumber}`
- Operation: `get /v1/inventorysummary/{inventoryNumber}`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `inventoryNumber` | `` | [x] |  |  |
| `location` | `` | [ ] |  |  |
| `warehouse` | `` | [ ] |  |  |

## Table Columns

The columns of the table `InventorySummaryByNumber` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `COMPANY_CODE` | `varchar2(30)` | Company Code | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `available` | `double` | Available | [ ] | filters on the platform, writable, `available` | The table &gt; Available &gt; The quantity of the stock items available at the specific warehouse and location. |
| `availableForShipment` | `double` | itgen_vnet_availableforshipment | [ ] | filters on the platform, writable, `availableForShipment` | The table &gt; Available for shipment &gt; The quantity of the stock items available at the specific warehouse and location calculated based on the quantity on hand with the quantities shipped and on shipping deducted. |
| `baseUnit` | `varchar2` | Base Unit | [ ] | filters on the platform, writable, `baseUnit` | The table &gt; Base unit &gt; The unit of measure (UoM) selected as the base unit for the stock items in the Stock items (IN202500) window. |
| `dropShipForSO` | `double` | Dropship FORSO | [ ] | filters on the platform, writable, `dropShipForSO` | The table &gt; Drop-ship for sales order &gt; The quantity of the stock items listed on open drop-ship orders. This value is not included in the quantity available. |
| `dropShipForSOPrepared` | `double` | Dropship FORSO Prepared | [ ] | filters on the platform, writable, `dropShipForSOPrepared` | The table &gt; Drop-ship for sales order, prepared &gt; The quantity of the stock items listed on drop-ship sales orders with a status of On hold or Pending approval; this value is not included in the quantity available. |
| `dropShipForSOReceipts` | `double` | Dropship FORSO Receipts | [ ] | filters on the platform, writable, `dropShipForSOReceipts` | The table &gt; Drop-ship for sales order, receipts &gt; The quantity of the stock items listed on receipts for drop-ship sales orders; this value is not included in the quantity available. |
| `errorInfo` | `varchar2` | Error Message | [ ] | filters on the platform, writable, `errorInfo` |  |
| `estimatedTotalCost` | `double` | Estimated Total Cost | [ ] | filters on the platform, writable, `estimatedTotalCost` | The table &gt; Estimated total cost &gt; The estimated total cost of the stock items available at the specified warehouse and location. |
| `estimatedUnitCost` | `double` | Estimated Unit Cost | [ ] | filters on the platform, writable, `estimatedUnitCost` | The table &gt; Estimated unit cost &gt; The estimated unit cost of the selected stock items. |
| `expired` | `double` | Expired | [ ] | filters on the platform, writable, `expired` | The table &gt; Expired &gt; The quantity of the stock items that has reached its expiration date. |
| `inAssemblyDemand` | `double` | In Assembly Demand | [ ] | filters on the platform, writable, `inAssemblyDemand` | The table &gt; In assembly demand &gt; The quantity of the stock items included in unreleased kit assembly documents as components or kits, depending on whether the item is a kit or a kit component. |
| `inAssemblySupply` | `double` | In Assembly Supply | [ ] | filters on the platform, writable, `inAssemblySupply` | The table &gt; In assembly supply &gt; The quantity of the stock items listed on unreleased kit assembly documents. |
| `inIssues` | `double` | In Issues | [ ] | filters on the platform, writable, `inIssues` | The table &gt; Inventory issues &gt; The quantity of the stock items included in the inventory issue documents that have not yet been released. |
| `inReceipts` | `double` | In Receipts | [ ] | filters on the platform, writable, `inReceipts` | The table &gt; Invnetory receipts &gt; The quantity of the stock items included in the inventory receipt documents that have not yet been released. |
| `inTransit` | `double` | Intransit | [ ] | filters on the platform, writable, `inTransit` | The table &gt; In transit &gt; The quantity of the stock items included as in transit quantities in the inventory transfer documents that have not yet been released. |
| `inventory_description` | `varchar2` | Inventory Description | [ ] | filters on the platform, writable, `inventory.description` | Name of item/description |
| `inventory_number` | `varchar2` | Inventory Number | [ ] | filters on the platform, writable, `inventory.number` | Number of item |
| `location_id` | `int32` | Location ID | [ ] | filters on the platform, writable, `location.id` | Click the magnifier &gt; The identifier |
| `location_name` | `varchar2` | Location Name | [ ] | filters on the platform, writable, `location.name` | Click the magnifier &gt; The displayed name |
| `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | [ ] | filters on the platform, writable, `metadata.maxPageSize` |  |
| `metadata_totalCount` | `int64` | Total Count | [ ] | filters on the platform, writable, `metadata.totalCount` |  |
| `notAvailable` | `double` | Not Available | [ ] | filters on the platform, writable, `notAvailable` | The table &gt; Not available &gt; The quantity of the stock items on locations for which the Include in qty. available option is not selected. |
| `onHand` | `double` | On Hand | [ ] | filters on the platform, writable, `onHand` | The table &gt; On hand &gt; The quantity of the stock items available on hand at the specified warehouse and location. |
| `poReceipts` | `double` | itgen_vnet_poreceipts | [ ] | filters on the platform, writable, `poReceipts` | The table &gt; Purchase order receipts &gt; The quantity of the stock items included in the purchase receipts that have not yet been released. To view the purchase receipts, open the Purchase receipts (PO302000) window. |
| `purchaseForSO` | `double` | itgen_vnet_purchaseforso | [ ] | filters on the platform, writable, `purchaseForSO` | The table &gt; Purchase for sales order. &gt; The quantity of the stock items listed on open purchase orders created for sales orders. |
| `purchaseForSOPrepared` | `double` | itgen_vnet_purchaseforsoprepared | [ ] | filters on the platform, writable, `purchaseForSOPrepared` | The table &gt; Purchase for sales order prepared &gt; The quantity of the stock items listed on purchase orders yet on hold or pending approval and created for back orders. |
| `purchaseForSOReceipts` | `double` | itgen_vnet_purchaseforsoreceipts | [ ] | filters on the platform, writable, `purchaseForSOReceipts` | The table &gt; Purchase for sales order receipts &gt; The quantity of the stock items listed on purchase receipts for orders that were created for sales orders. |
| `purchaseOrders` | `double` | itgen_vnet_purchaseorders | [ ] | filters on the platform, writable, `purchaseOrders` | The table &gt; Purchase orders &gt; The quantity of the stock items included in open purchase orders. To view the purchase orders, open the Purchase orders (PO301000) window. |
| `purchasePrepared` | `double` | itgen_vnet_purchaseprepared | [ ] | filters on the platform, writable, `purchasePrepared` | The table &gt; Purchase prepared &gt; The quantity of the stock items listed on purchase orders pending approval and on hold. |
| `soAllocated` | `double` | itgen_vnet_soallocated | [ ] | filters on the platform, writable, `soAllocated` | The table &gt; Sales order allocated &gt; The quantity of stock items set aside according to sales orders. |
| `soBackOrdered` | `double` | itgen_vnet_sobackordered | [ ] | filters on the platform, writable, `soBackOrdered` | The table &gt; Back orders &gt; The quantity of the stock items on sales orders with the Back order status. |
| `soBooked` | `double` | itgen_vnet_sobooked | [ ] | filters on the platform, writable, `soBooked` | The table &gt; Sales order booked &gt; The quantity of the stock items booked according to sales orders. |
| `soShipped` | `double` | itgen_vnet_soshipped | [ ] | filters on the platform, writable, `soShipped` | The table &gt; Sales orders shipped &gt; The quantity of the stock items shipped according to the confirmed shipments. |
| `soToDropShip` | `double` | itgen_vnet_sotodropship | [ ] | filters on the platform, writable, `soToDropShip` | The table &gt; Sales order to drop-ship &gt; The quantity of the stock items included in open purchase orders created for drop-ship orders. |
| `soToPurchase` | `double` | itgen_vnet_sotopurchase | [ ] | filters on the platform, writable, `soToPurchase` | The table &gt; Sales order to purchase &gt; The quantity of the stock items included in unreleased sales orders requiring creating purchase orders. |
| `warehouse_description` | `varchar2` | Warehouse Description | [ ] | filters on the platform, writable, `warehouse.description` | Click on the magnifier. &gt; The description. |
| `warehouse_id` | `varchar2` | Warehouse ID | [ ] | filters on the platform, writable, `warehouse.id` | Click on the magnifier. &gt; The identifier. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

