Warehouse stock and item dossiers — Pro
Choose a warehouse; inspect quantities, thresholds, cost and the item across other warehouses.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
Based on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots use native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and verify the edition, fields, permissions and results before business use.
Current warehouse stock, not stock at a past date. Choose the operational warehouse code before opening. Shows warehouse name, item, unit, on-hand, committed, on-order, minimum/maximum and average price. Average price is a native warehouse field, not an asserted statutory FIFO valuation. Product details lead to the same item across all warehouses. Negative and zero stocks remain visible.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
SAP Business One 10.0 on Microsoft SQL Server only; not SAP HANA. Connect to one authorized company database using a restricted read-only account. Local-currency and foreign-currency amounts are distinct; no invented currency conversion or cross-currency total. Up to 2,000 rows per read; narrow the period or filters for large datasets. Live reads, no periodic background refresh. Detail buttons read only the selected context. Technical join keys are hidden.
Field legend: Y = Yes, N = No; partner type C = Customer, S = Supplier, L = Lead. A multi-currency partner setting is not an ISO currency code. Native foreign balances must not be combined across currencies; use SAP for currency-specific reconciliation. Active/inactive item flags alone do not apply SAP validity dates or document rules. Stock is a current snapshot in inventory units, not a historical valuation or a promise of availability. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The configured read cap does not guarantee an inexpensive server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE
Screenshots
What this package creates
1 Home3 Details3 lists1 sources to map
- Home: Stock by warehouse
- Details: Product dossier
- Details: Stock in all warehouses
- Details: Stock in all warehouses
- Sub-button: Product dossier
- Sub-button: Stock in all warehouses
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(DATALENGTH(w.ItemCode), N':', w.ItemCode, w.WhsCode) AS row_id, w.[ItemCode], w.[WhsCode], w.[OnHand], w.[IsCommited], w.[OnOrder], w.[MinStock], w.[MaxStock], w.[AvgPrice], i.ItemName, i.InvntryUom, h.WhsName FROM dbo.OITW w LEFT JOIN dbo.OITM i ON i.ItemCode = w.ItemCode LEFT JOIN dbo.OWHS h ON h.WhsCode = w.WhsCode
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT i.[ItemCode], i.[ItemName], i.[CodeBars], i.[InvntryUom], i.[OnHand], i.[IsCommited], i.[OnOrder], i.[BuyUnitMsr], i.[SalUnitMsr], i.[MinLevel], i.[MaxLevel], i.[frozenFor], i.[validFor], g.ItmsGrpNam, CASE WHEN i.frozenFor IS NULL THEN N'Not specified' WHEN i.frozenFor = 'Y' THEN N'Yes' WHEN i.frozenFor = 'N' THEN N'No' ELSE N'Unknown' END AS InactiveFlag, CASE WHEN i.validFor IS NULL THEN N'Not specified' WHEN i.validFor = 'Y' THEN N'Yes' WHEN i.validFor = 'N' THEN N'No' ELSE N'Unknown' END AS ActiveFlag FROM dbo.OITM i LEFT JOIN dbo.OITB g ON g.ItmsGrpCod = i.ItmsGrpCod WHERE i.ItemCode = :item
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(DATALENGTH(w.ItemCode), N':', w.ItemCode, w.WhsCode) AS row_id, w.[ItemCode], w.[WhsCode], w.[OnHand], w.[IsCommited], w.[OnOrder], w.[MinStock], w.[MaxStock], w.[AvgPrice], i.ItemName, i.InvntryUom, h.WhsName FROM dbo.OITW w LEFT JOIN dbo.OITM i ON i.ItemCode = w.ItemCode LEFT JOIN dbo.OWHS h ON h.WhsCode = w.WhsCode WHERE w.ItemCode = :item
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "SAP Business One 10.0 — SQL Server",
"id": "12A18BBB-AB47-5705-8E64-C7F8FE1B1B8C",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OITB",
"dbo.OITM",
"dbo.OITW",
"dbo.OWHS"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A297A14A-715A-5DFD-BD86-50BBDADE5921",
"key": "ItemName",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "25E6C53E-3184-5D3C-99AB-BB743B8E6CEA",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Internal row key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IsCommited",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinStock",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaxStock",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AvgPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntryUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Stock by warehouse",
"primaryKey": "row_id",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"WhsCode",
"ItemName",
"InvntryUom",
"WhsName"
],
"sourceID": "12A18BBB-AB47-5705-8E64-C7F8FE1B1B8C",
"sqlQuery": "SELECT CONCAT(DATALENGTH(w.ItemCode), N':', w.ItemCode, w.WhsCode) AS row_id, w.[ItemCode], w.[WhsCode], w.[OnHand], w.[IsCommited], w.[OnOrder], w.[MinStock], w.[MaxStock], w.[AvgPrice], i.ItemName, i.InvntryUom, h.WhsName FROM dbo.OITW w LEFT JOIN dbo.OITM i ON i.ItemCode = w.ItemCode LEFT JOIN dbo.OWHS h ON h.WhsCode = w.WhsCode",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"id": "29AD1A71-B513-51F4-B764-48D9A4580C76",
"mappings": [
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CodeBars",
"label": "Barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CodeBars",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntryUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IsCommited",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BuyUnitMsr",
"label": "Purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BuyUnitMsr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalUnitMsr",
"label": "Sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalUnitMsr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MinLevel",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinLevel",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MaxLevel",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaxLevel",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "frozenFor",
"label": "Inactive flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "frozenFor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "validFor",
"label": "Active flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validFor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItmsGrpNam",
"label": "Item group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItmsGrpNam",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InactiveFlag",
"label": "Inactive flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InactiveFlag",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ActiveFlag",
"label": "Active flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ActiveFlag",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Product dossier",
"primaryKey": "ItemCode",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemCode",
"id": "C3DAE7B1-5023-50AE-AE38-371722034B1D",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"ItemName",
"CodeBars",
"InvntryUom",
"BuyUnitMsr",
"SalUnitMsr",
"ItmsGrpNam",
"InactiveFlag",
"ActiveFlag"
],
"sourceID": "12A18BBB-AB47-5705-8E64-C7F8FE1B1B8C",
"sqlQuery": "SELECT i.[ItemCode], i.[ItemName], i.[CodeBars], i.[InvntryUom], i.[OnHand], i.[IsCommited], i.[OnOrder], i.[BuyUnitMsr], i.[SalUnitMsr], i.[MinLevel], i.[MaxLevel], i.[frozenFor], i.[validFor], g.ItmsGrpNam, CASE WHEN i.frozenFor IS NULL THEN N'Not specified' WHEN i.frozenFor = 'Y' THEN N'Yes' WHEN i.frozenFor = 'N' THEN N'No' ELSE N'Unknown' END AS InactiveFlag, CASE WHEN i.validFor IS NULL THEN N'Not specified' WHEN i.validFor = 'Y' THEN N'Yes' WHEN i.validFor = 'N' THEN N'No' ELSE N'Unknown' END AS ActiveFlag FROM dbo.OITM i LEFT JOIN dbo.OITB g ON g.ItmsGrpCod = i.ItmsGrpCod WHERE i.ItemCode = :item",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "0F18A517-810D-5F6D-8275-4BFB570BDF23",
"key": "WhsName",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "DF3D9450-1E38-562B-BB6E-A4DFD4E5E96F",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Internal row key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IsCommited",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinStock",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaxStock",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AvgPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntryUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Stock in all warehouses",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemCode",
"id": "2825EAD7-8D4F-5973-93B9-102ADAC14D90",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"WhsCode",
"ItemName",
"InvntryUom",
"WhsName"
],
"sourceID": "12A18BBB-AB47-5705-8E64-C7F8FE1B1B8C",
"sqlQuery": "SELECT CONCAT(DATALENGTH(w.ItemCode), N':', w.ItemCode, w.WhsCode) AS row_id, w.[ItemCode], w.[WhsCode], w.[OnHand], w.[IsCommited], w.[OnOrder], w.[MinStock], w.[MaxStock], w.[AvgPrice], i.ItemName, i.InvntryUom, h.WhsName FROM dbo.OITW w LEFT JOIN dbo.OITM i ON i.ItemCode = w.ItemCode LEFT JOIN dbo.OWHS h ON h.WhsCode = w.WhsCode WHERE w.ItemCode = :item",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "0329E719-4644-5531-8FAC-F847832EC7B3",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "58EF6295-DDEE-52C0-89F8-21E1FCDED329",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "29AD1A71-B513-51F4-B764-48D9A4580C76",
"title": "Product dossier",
"urlKey": ""
},
{
"id": "05686673-44AD-5FF2-95CC-FB9DAC0D3405",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "535FE2A9-7D1B-5085-942C-8A91C487C875",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DF3D9450-1E38-562B-BB6E-A4DFD4E5E96F",
"title": "Stock in all warehouses",
"urlKey": ""
}
],
"badgeKey": "OnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "25E6C53E-3184-5D3C-99AB-BB743B8E6CEA",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9B62C260-58EF-51F2-822B-EEB56B417F5D",
"openFilters": [
{
"id": "B531C65F-F0C1-56F6-AC5D-0666253B4F8A",
"includeAllOption": false,
"key": "WhsCode",
"title": "Warehouse code",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "A297A14A-715A-5DFD-BD86-50BBDADE5921",
"key": "ItemName",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "tablecells",
"title": "Stock by warehouse",
"titleKey": "ItemName"
},
{
"actions": [
{
"id": "07249AEA-A559-5CFE-B324-F5CCB6968463",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "800B6136-85E5-560F-8AD5-57DDFF2A2642",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DF3D9450-1E38-562B-BB6E-A4DFD4E5E96F",
"title": "Stock in all warehouses",
"urlKey": ""
}
],
"badgeKey": "OnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CodeBars",
"label": "Barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MinLevel",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MaxLevel",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItmsGrpNam",
"label": "Item group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "29AD1A71-B513-51F4-B764-48D9A4580C76",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CodeBars",
"label": "Barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "BuyUnitMsr",
"label": "Purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "SalUnitMsr",
"label": "Sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MinLevel",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MaxLevel",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItmsGrpNam",
"label": "Item group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InactiveFlag",
"label": "Inactive flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "ActiveFlag",
"label": "Active flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E9D7ABAD-7D41-59F5-B665-DBA9DF3FBD35",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "tablecells",
"title": "Product dossier",
"titleKey": "ItemName"
},
{
"actions": [],
"badgeKey": "OnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DF3D9450-1E38-562B-BB6E-A4DFD4E5E96F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7507C463-9F75-5C3F-82D2-ED7F70E5436A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "0F18A517-810D-5F6D-8275-4BFB570BDF23",
"key": "WhsName",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "WhsCode",
"systemImage": "tablecells",
"title": "Stock in all warehouses",
"titleKey": "WhsName"
}
],
"relations": [
{
"childDatasetID": "29AD1A71-B513-51F4-B764-48D9A4580C76",
"childKey": "ItemCode",
"id": "58EF6295-DDEE-52C0-89F8-21E1FCDED329",
"name": "Product dossier",
"parentDatasetID": "25E6C53E-3184-5D3C-99AB-BB743B8E6CEA",
"parentKey": "ItemCode"
},
{
"childDatasetID": "DF3D9450-1E38-562B-BB6E-A4DFD4E5E96F",
"childKey": "ItemCode",
"id": "535FE2A9-7D1B-5085-942C-8A91C487C875",
"name": "Stock in all warehouses",
"parentDatasetID": "25E6C53E-3184-5D3C-99AB-BB743B8E6CEA",
"parentKey": "ItemCode"
},
{
"childDatasetID": "DF3D9450-1E38-562B-BB6E-A4DFD4E5E96F",
"childKey": "ItemCode",
"id": "800B6136-85E5-560F-8AD5-57DDFF2A2642",
"name": "Stock in all warehouses",
"parentDatasetID": "29AD1A71-B513-51F4-B764-48D9A4580C76",
"parentKey": "ItemCode"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "SAP Business One",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nBased on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots use native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and verify the edition, fields, permissions and results before business use.\n\nCurrent warehouse stock, not stock at a past date. Choose the operational warehouse code before opening. Shows warehouse name, item, unit, on-hand, committed, on-order, minimum/maximum and average price. Average price is a native warehouse field, not an asserted statutory FIFO valuation. Product details lead to the same item across all warehouses. Negative and zero stocks remain visible.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nSAP Business One 10.0 on Microsoft SQL Server only; not SAP HANA. Connect to one authorized company database using a restricted read-only account. Local-currency and foreign-currency amounts are distinct; no invented currency conversion or cross-currency total. Up to 2,000 rows per read; narrow the period or filters for large datasets. Live reads, no periodic background refresh. Detail buttons read only the selected context. Technical join keys are hidden.\n\nField legend: Y = Yes, N = No; partner type C = Customer, S = Supplier, L = Lead. A multi-currency partner setting is not an ISO currency code. Native foreign balances must not be combined across currencies; use SAP for currency-specific reconciliation. Active/inactive item flags alone do not apply SAP validity dates or document rules. Stock is a current snapshot in inventory units, not a historical valuation or a promise of availability. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The configured read cap does not guarantee an inexpensive server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "65067600-001E-5323-9446-C23EB5C4D9CB",
"rootButtonCount": 1,
"summary": "Choose a warehouse; inspect quantities, thresholds, cost and the item across other warehouses.",
"tags": [
"SAP Business One",
"SQL Server",
"pro"
],
"title": "Warehouse stock and item dossiers — Pro"
}
}