Stock by warehouse — Pro
Warehouse stock, replenishment quantities, costs, item dossier and stock in other warehouses.
NOT VALIDATED ON A REAL ERP INSTALLATION. Based on official Sage 100 US 2026 FLOR documentation and synthetic tests. Map your authorized company source, run the read/compatibility test at import, and check columns, permissions, results and performance before business use. DEMO images, when provided, use synthetic data.
For warehouse, purchasing and operations teams: choose a warehouse, see on-hand stock, outstanding purchase/sales quantities, back orders, shipping quantities, reorder thresholds and native warehouse cost/value. Open the item dossier or compare that same item across all its warehouses. Inactive/restricted warehouses and item status remain visible; this report does not authorize transfers.
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.
Amounts are native source values, with no invented currency code, conversion, tax treatment or cross-company total. Verify the company currency and any multicurrency extensions. Standard prices are reference prices, not negotiated customer quotes. Standard cost is not inventory valuation unless that valuation method is in use. Average cost may be an estimate when stock is negative. On-hand quantities use the stock unit; sales/purchase units and their conversion factors are shown separately. No invented available-stock calculation or replenishment recommendation. Only regular inventory items are included in the Free catalog. The Pro warehouse report retains orphan warehouse rows with an explicit missing-master message instead of silently dropping stock. Reads are on demand, at most 2,000 rows each, without scheduled refresh. Narrow filters if the limit is reached; search only covers loaded rows. Row limits do not guarantee inexpensive scans. SQL permissions must explicitly allow all shown data, including costs. Display filters do not replace database access control.
Unofficial community configuration for Sage 100 US 2026, SQL Server deployment (formerly Premium), Inventory Management enabled. Not ProvideX Standard/Advanced, Sage 100 France, or Sage 100 Contractor. A company-provided SQL read-only account is required; the package contains no server, credentials or business rows. Verify dbo schema, edition, logical/physical column conversions, full keys, permissions and execution plans. Dictionary: https://help-sage100.na.sage.com/2026/FLOR/index.htm Functional help: https://help-sage100.na.sage.com/2026/Subsystems/IM/IMMainFields/Inventory_Maintenance_-_Fields.htm
Pro: one source, three lists, two related buttons and custom read-only SQL. Choose the warehouse before reading; related lists are fetched only when opened.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Stock by warehouse
- Details: Item dossier
- Details: Stock in all warehouses
- Sub-button: Item 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.WarehouseCode) AS StockKey, w.ItemCode, w.WarehouseCode, w.BinLocation, w.QuantityOnHand, w.QuantityOnPurchaseOrder, w.QuantityOnSalesOrder, w.QuantityOnBackOrder, w.QuantityInShipping, w.ReorderPointQty, w.MinimumOrderQty, w.MaximumOnHandQty, w.AverageCost, w.TotalWarehouseValue, COALESCE(NULLIF(i.ItemCodeDesc,N''),w.ItemCode) AS ItemName, COALESCE(NULLIF(h.WarehouseDesc,N''),w.WarehouseCode) AS WarehouseLabel, i.StandardUnitOfMeasure, i.ProductLine, i.UPCEAN, i.StandardUnitPrice, CASE i.Valuation WHEN N'1' THEN N'Standard' WHEN N'2' THEN N'Average' WHEN N'3' THEN N'Fifo' WHEN N'4' THEN N'Lifo' WHEN N'5' THEN N'Lot' WHEN N'6' THEN N'Serial' ELSE CONCAT(N'Unknown / unset: ', i.Valuation) END AS ValuationName, CASE i.InactiveItem WHEN N'N' THEN N'Active' WHEN N'Y' THEN N'Inactive' ELSE N'Unknown / missing' END AS ItemState, CASE h.WarehouseStatus WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'R' THEN N'Restricted' ELSE CONCAT(N'Unknown / unset: ', h.WarehouseStatus) END AS WarehouseStateName, CASE WHEN i.ItemCode IS NULL THEN N'Missing: verify source integrity' ELSE N'Present' END AS MasterAvailability, CASE WHEN w.QuantityOnHand<0 AND i.Valuation=N'2' THEN N'Estimate: negative average-cost stock' ELSE N'Native warehouse average; check valuation method' END AS CostContext, h.WarehouseCity, h.TelephoneNo, h.ContactName, h.StatusComment FROM dbo.IM_ItemWarehouse w LEFT JOIN dbo.CI_Item i ON i.ItemCode=w.ItemCode LEFT JOIN dbo.IM_Warehouse h ON h.WarehouseCode=w.WarehouseCode
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT i.ItemCode, i.ItemCodeDesc, i.ItemType, i.ProductLine, i.DefaultWarehouseCode, i.StandardUnitOfMeasure, i.TotalQuantityOnHand, i.StandardUnitPrice, i.StandardUnitCost, i.AverageUnitCost, i.LastTotalUnitCost, i.SalesUnitOfMeasure, i.SalesUMConvFctr, i.PurchaseUnitOfMeasure, i.PurchaseUMConvFctr, i.UPCEAN, CASE i.Valuation WHEN N'1' THEN N'Standard' WHEN N'2' THEN N'Average' WHEN N'3' THEN N'Fifo' WHEN N'4' THEN N'Lifo' WHEN N'5' THEN N'Lot' WHEN N'6' THEN N'Serial' ELSE CONCAT(N'Unknown / unset: ', i.Valuation) END AS ValuationName, CASE i.ProcurementType WHEN N'B' THEN N'Buy to Stock' WHEN N'M' THEN N'Make to Stock' WHEN N'C' THEN N'Buy to Order' WHEN N'N' THEN N'Make to Order' WHEN N'S' THEN N'Subcontract' ELSE CONCAT(N'Unknown / unset: ', i.ProcurementType) END AS ProcurementName, CASE i.InactiveItem WHEN N'N' THEN N'Active' WHEN N'Y' THEN N'Inactive' ELSE N'Unknown / unset' END AS ItemState FROM dbo.CI_Item i 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.WarehouseCode) AS StockKey, w.ItemCode, w.WarehouseCode, w.BinLocation, w.QuantityOnHand, w.QuantityOnPurchaseOrder, w.QuantityOnSalesOrder, w.QuantityOnBackOrder, w.QuantityInShipping, w.ReorderPointQty, w.MinimumOrderQty, w.MaximumOnHandQty, w.AverageCost, w.TotalWarehouseValue, COALESCE(NULLIF(i.ItemCodeDesc,N''),w.ItemCode) AS ItemName, COALESCE(NULLIF(h.WarehouseDesc,N''),w.WarehouseCode) AS WarehouseLabel, i.StandardUnitOfMeasure, i.ProductLine, i.UPCEAN, i.StandardUnitPrice, CASE i.Valuation WHEN N'1' THEN N'Standard' WHEN N'2' THEN N'Average' WHEN N'3' THEN N'Fifo' WHEN N'4' THEN N'Lifo' WHEN N'5' THEN N'Lot' WHEN N'6' THEN N'Serial' ELSE CONCAT(N'Unknown / unset: ', i.Valuation) END AS ValuationName, CASE i.InactiveItem WHEN N'N' THEN N'Active' WHEN N'Y' THEN N'Inactive' ELSE N'Unknown / missing' END AS ItemState, CASE h.WarehouseStatus WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'R' THEN N'Restricted' ELSE CONCAT(N'Unknown / unset: ', h.WarehouseStatus) END AS WarehouseStateName, CASE WHEN i.ItemCode IS NULL THEN N'Missing: verify source integrity' ELSE N'Present' END AS MasterAvailability, CASE WHEN w.QuantityOnHand<0 AND i.Valuation=N'2' THEN N'Estimate: negative average-cost stock' ELSE N'Native warehouse average; check valuation method' END AS CostContext, h.WarehouseCity, h.TelephoneNo, h.ContactName, h.StatusComment FROM dbo.IM_ItemWarehouse w LEFT JOIN dbo.CI_Item i ON i.ItemCode=w.ItemCode LEFT JOIN dbo.IM_Warehouse h ON h.WarehouseCode=w.WarehouseCode WHERE w.ItemCode=:item
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 100 US — SQL Server",
"id": "4EFD3A5B-4AAF-5094-A233-98B439C7D94F",
"kind": "sqlServer",
"requiredObjects": [
"dbo.CI_Item",
"dbo.IM_ItemWarehouse",
"dbo.IM_Warehouse"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 US — SQL Server",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A297A14A-715A-5DFD-BD86-50BBDADE5921",
"key": "ItemName",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "2659E5B8-39AF-5D62-92B0-DF43272CE13F",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Internal item / warehouse key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockKey",
"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": "WarehouseCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BinLocation",
"label": "Bin location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BinLocation",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityOnHand",
"label": "On hand — stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QuantityOnPurchaseOrder",
"label": "On purchase orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnPurchaseOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityOnSalesOrder",
"label": "On sales orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnSalesOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityOnBackOrder",
"label": "Back ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnBackOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityInShipping",
"label": "In shipping",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityInShipping",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReorderPointQty",
"label": "Reorder point",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReorderPointQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MinimumOrderQty",
"label": "Minimum order quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinimumOrderQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MaximumOnHandQty",
"label": "Maximum on-hand quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaximumOnHandQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AverageCost",
"label": "Warehouse average cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AverageCost",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TotalWarehouseValue",
"label": "Warehouse stock value — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TotalWarehouseValue",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseLabel",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseLabel",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitOfMeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductLine",
"label": "Product line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductLine",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UPCEAN",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UPCEAN",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ValuationName",
"label": "Valuation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ValuationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemState",
"label": "Item status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseStateName",
"label": "Warehouse status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseStateName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MasterAvailability",
"label": "Item master",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MasterAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostContext",
"label": "Average-cost context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseCity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseCity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TelephoneNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Warehouse contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StatusComment",
"label": "Warehouse status comment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StatusComment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Stock by warehouse",
"primaryKey": "StockKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"WarehouseCode",
"BinLocation",
"ItemName",
"WarehouseLabel",
"StandardUnitOfMeasure",
"ProductLine",
"UPCEAN",
"ValuationName",
"ItemState",
"WarehouseStateName",
"MasterAvailability",
"CostContext",
"WarehouseCity",
"TelephoneNo",
"ContactName",
"StatusComment"
],
"sourceID": "4EFD3A5B-4AAF-5094-A233-98B439C7D94F",
"sqlQuery": "SELECT CONCAT(DATALENGTH(w.ItemCode),N':',w.ItemCode,w.WarehouseCode) AS StockKey, w.ItemCode, w.WarehouseCode, w.BinLocation, w.QuantityOnHand, w.QuantityOnPurchaseOrder, w.QuantityOnSalesOrder, w.QuantityOnBackOrder, w.QuantityInShipping, w.ReorderPointQty, w.MinimumOrderQty, w.MaximumOnHandQty, w.AverageCost, w.TotalWarehouseValue, COALESCE(NULLIF(i.ItemCodeDesc,N''),w.ItemCode) AS ItemName, COALESCE(NULLIF(h.WarehouseDesc,N''),w.WarehouseCode) AS WarehouseLabel, i.StandardUnitOfMeasure, i.ProductLine, i.UPCEAN, i.StandardUnitPrice, CASE i.Valuation WHEN N'1' THEN N'Standard' WHEN N'2' THEN N'Average' WHEN N'3' THEN N'Fifo' WHEN N'4' THEN N'Lifo' WHEN N'5' THEN N'Lot' WHEN N'6' THEN N'Serial' ELSE CONCAT(N'Unknown / unset: ', i.Valuation) END AS ValuationName, CASE i.InactiveItem WHEN N'N' THEN N'Active' WHEN N'Y' THEN N'Inactive' ELSE N'Unknown / missing' END AS ItemState, CASE h.WarehouseStatus WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'R' THEN N'Restricted' ELSE CONCAT(N'Unknown / unset: ', h.WarehouseStatus) END AS WarehouseStateName, CASE WHEN i.ItemCode IS NULL THEN N'Missing: verify source integrity' ELSE N'Present' END AS MasterAvailability, CASE WHEN w.QuantityOnHand<0 AND i.Valuation=N'2' THEN N'Estimate: negative average-cost stock' ELSE N'Native warehouse average; check valuation method' END AS CostContext, h.WarehouseCity, h.TelephoneNo, h.ContactName, h.StatusComment FROM dbo.IM_ItemWarehouse w LEFT JOIN dbo.CI_Item i ON i.ItemCode=w.ItemCode LEFT JOIN dbo.IM_Warehouse h ON h.WarehouseCode=w.WarehouseCode",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 US — SQL Server",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"id": "E5E4E14E-F5F1-58BC-8F53-00E40C9F95E2",
"mappings": [
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCodeDesc",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCodeDesc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemType",
"label": "Type (1 regular, 3 charge, 4 comment, 5 misc.)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductLine",
"label": "Product line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductLine",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DefaultWarehouseCode",
"label": "Default warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DefaultWarehouseCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitOfMeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TotalQuantityOnHand",
"label": "On hand — all warehouses",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TotalQuantityOnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StandardUnitCost",
"label": "Standard cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitCost",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AverageUnitCost",
"label": "Average cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AverageUnitCost",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LastTotalUnitCost",
"label": "Last total cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LastTotalUnitCost",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesUnitOfMeasure",
"label": "Sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesUnitOfMeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalesUMConvFctr",
"label": "Stock units per sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalesUMConvFctr",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchaseUnitOfMeasure",
"label": "Purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchaseUnitOfMeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PurchaseUMConvFctr",
"label": "Stock units per purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PurchaseUMConvFctr",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UPCEAN",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UPCEAN",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ValuationName",
"label": "Valuation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ValuationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProcurementName",
"label": "Procurement",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProcurementName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemState",
"label": "Item status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Item dossier",
"primaryKey": "ItemCode",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemCode",
"id": "ED251C51-2569-5960-99F1-A8EDF4B1588C",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"ItemCodeDesc",
"ItemType",
"ProductLine",
"DefaultWarehouseCode",
"StandardUnitOfMeasure",
"SalesUnitOfMeasure",
"PurchaseUnitOfMeasure",
"UPCEAN",
"ValuationName",
"ProcurementName",
"ItemState"
],
"sourceID": "4EFD3A5B-4AAF-5094-A233-98B439C7D94F",
"sqlQuery": "SELECT i.ItemCode, i.ItemCodeDesc, i.ItemType, i.ProductLine, i.DefaultWarehouseCode, i.StandardUnitOfMeasure, i.TotalQuantityOnHand, i.StandardUnitPrice, i.StandardUnitCost, i.AverageUnitCost, i.LastTotalUnitCost, i.SalesUnitOfMeasure, i.SalesUMConvFctr, i.PurchaseUnitOfMeasure, i.PurchaseUMConvFctr, i.UPCEAN, CASE i.Valuation WHEN N'1' THEN N'Standard' WHEN N'2' THEN N'Average' WHEN N'3' THEN N'Fifo' WHEN N'4' THEN N'Lifo' WHEN N'5' THEN N'Lot' WHEN N'6' THEN N'Serial' ELSE CONCAT(N'Unknown / unset: ', i.Valuation) END AS ValuationName, CASE i.ProcurementType WHEN N'B' THEN N'Buy to Stock' WHEN N'M' THEN N'Make to Stock' WHEN N'C' THEN N'Buy to Order' WHEN N'N' THEN N'Make to Order' WHEN N'S' THEN N'Subcontract' ELSE CONCAT(N'Unknown / unset: ', i.ProcurementType) END AS ProcurementName, CASE i.InactiveItem WHEN N'N' THEN N'Active' WHEN N'Y' THEN N'Inactive' ELSE N'Unknown / unset' END AS ItemState FROM dbo.CI_Item i WHERE i.ItemCode=:item",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 100 US — SQL Server",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "097CB1FE-5CD1-5E83-B17C-A3A42BC1A60B",
"key": "WarehouseCode",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "6156F029-1FE6-52EB-8826-5D9F4DEA3284",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Internal item / warehouse key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockKey",
"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": "WarehouseCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BinLocation",
"label": "Bin location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BinLocation",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityOnHand",
"label": "On hand — stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QuantityOnPurchaseOrder",
"label": "On purchase orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnPurchaseOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityOnSalesOrder",
"label": "On sales orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnSalesOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityOnBackOrder",
"label": "Back ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityOnBackOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QuantityInShipping",
"label": "In shipping",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "QuantityInShipping",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReorderPointQty",
"label": "Reorder point",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReorderPointQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MinimumOrderQty",
"label": "Minimum order quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinimumOrderQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MaximumOnHandQty",
"label": "Maximum on-hand quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaximumOnHandQty",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AverageCost",
"label": "Warehouse average cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AverageCost",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TotalWarehouseValue",
"label": "Warehouse stock value — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TotalWarehouseValue",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseLabel",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseLabel",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitOfMeasure",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductLine",
"label": "Product line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductLine",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UPCEAN",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UPCEAN",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StandardUnitPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ValuationName",
"label": "Valuation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ValuationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemState",
"label": "Item status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseStateName",
"label": "Warehouse status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseStateName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MasterAvailability",
"label": "Item master",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MasterAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostContext",
"label": "Average-cost context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseCity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseCity",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TelephoneNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ContactName",
"label": "Warehouse contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ContactName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StatusComment",
"label": "Warehouse status comment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StatusComment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Stock in all warehouses",
"primaryKey": "StockKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemCode",
"id": "F3E68DE3-9F26-5FF0-9FF1-4D984356C855",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"WarehouseCode",
"BinLocation",
"ItemName",
"WarehouseLabel",
"StandardUnitOfMeasure",
"ProductLine",
"UPCEAN",
"ValuationName",
"ItemState",
"WarehouseStateName",
"MasterAvailability",
"CostContext",
"WarehouseCity",
"TelephoneNo",
"ContactName",
"StatusComment"
],
"sourceID": "4EFD3A5B-4AAF-5094-A233-98B439C7D94F",
"sqlQuery": "SELECT CONCAT(DATALENGTH(w.ItemCode),N':',w.ItemCode,w.WarehouseCode) AS StockKey, w.ItemCode, w.WarehouseCode, w.BinLocation, w.QuantityOnHand, w.QuantityOnPurchaseOrder, w.QuantityOnSalesOrder, w.QuantityOnBackOrder, w.QuantityInShipping, w.ReorderPointQty, w.MinimumOrderQty, w.MaximumOnHandQty, w.AverageCost, w.TotalWarehouseValue, COALESCE(NULLIF(i.ItemCodeDesc,N''),w.ItemCode) AS ItemName, COALESCE(NULLIF(h.WarehouseDesc,N''),w.WarehouseCode) AS WarehouseLabel, i.StandardUnitOfMeasure, i.ProductLine, i.UPCEAN, i.StandardUnitPrice, CASE i.Valuation WHEN N'1' THEN N'Standard' WHEN N'2' THEN N'Average' WHEN N'3' THEN N'Fifo' WHEN N'4' THEN N'Lifo' WHEN N'5' THEN N'Lot' WHEN N'6' THEN N'Serial' ELSE CONCAT(N'Unknown / unset: ', i.Valuation) END AS ValuationName, CASE i.InactiveItem WHEN N'N' THEN N'Active' WHEN N'Y' THEN N'Inactive' ELSE N'Unknown / missing' END AS ItemState, CASE h.WarehouseStatus WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'R' THEN N'Restricted' ELSE CONCAT(N'Unknown / unset: ', h.WarehouseStatus) END AS WarehouseStateName, CASE WHEN i.ItemCode IS NULL THEN N'Missing: verify source integrity' ELSE N'Present' END AS MasterAvailability, CASE WHEN w.QuantityOnHand<0 AND i.Valuation=N'2' THEN N'Estimate: negative average-cost stock' ELSE N'Native warehouse average; check valuation method' END AS CostContext, h.WarehouseCity, h.TelephoneNo, h.ContactName, h.StatusComment FROM dbo.IM_ItemWarehouse w LEFT JOIN dbo.CI_Item i ON i.ItemCode=w.ItemCode LEFT JOIN dbo.IM_Warehouse h ON h.WarehouseCode=w.WarehouseCode WHERE w.ItemCode=:item",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "6F70F030-A650-5B10-95C9-535872160774",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C2CFD881-EBCD-569B-A50E-A7F94D23C292",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E5E4E14E-F5F1-58BC-8F53-00E40C9F95E2",
"title": "Item dossier",
"urlKey": ""
},
{
"id": "C26D4598-1360-5210-976D-B90EBC83BCF5",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "9524EEE9-A8D0-5A89-9AA9-6B4EE57EBB30",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6156F029-1FE6-52EB-8826-5D9F4DEA3284",
"title": "Stock in all warehouses",
"urlKey": ""
}
],
"badgeKey": "QuantityOnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BinLocation",
"label": "Bin location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnPurchaseOrder",
"label": "On purchase orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnSalesOrder",
"label": "On sales orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnBackOrder",
"label": "Back ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityInShipping",
"label": "In shipping",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseLabel",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "2659E5B8-39AF-5D62-92B0-DF43272CE13F",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "BinLocation",
"label": "Bin location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnHand",
"label": "On hand — stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnPurchaseOrder",
"label": "On purchase orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnSalesOrder",
"label": "On sales orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnBackOrder",
"label": "Back ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityInShipping",
"label": "In shipping",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "ReorderPointQty",
"label": "Reorder point",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "MinimumOrderQty",
"label": "Minimum order quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "MaximumOnHandQty",
"label": "Maximum on-hand quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "AverageCost",
"label": "Warehouse average cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "TotalWarehouseValue",
"label": "Warehouse stock value — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseLabel",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ProductLine",
"label": "Product line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "UPCEAN",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ValuationName",
"label": "Valuation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemState",
"label": "Item status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseStateName",
"label": "Warehouse status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "MasterAvailability",
"label": "Item master",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "CostContext",
"label": "Average-cost context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseCity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ContactName",
"label": "Warehouse contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "StatusComment",
"label": "Warehouse status comment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "DEC1ABB2-0840-5CAF-A872-D5E18EDBF833",
"openFilters": [
{
"id": "7B977011-E680-5134-A339-2F89753A6EAD",
"includeAllOption": false,
"key": "WarehouseCode",
"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": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "shippingbox",
"title": "Stock by warehouse",
"titleKey": "ItemName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TotalQuantityOnHand",
"label": "On hand — all warehouses",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E5E4E14E-F5F1-58BC-8F53-00E40C9F95E2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemCodeDesc",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemType",
"label": "Type (1 regular, 3 charge, 4 comment, 5 misc.)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ProductLine",
"label": "Product line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "DefaultWarehouseCode",
"label": "Default warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "TotalQuantityOnHand",
"label": "On hand — all warehouses",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitCost",
"label": "Standard cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "AverageUnitCost",
"label": "Average cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "LastTotalUnitCost",
"label": "Last total cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "SalesUnitOfMeasure",
"label": "Sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "SalesUMConvFctr",
"label": "Stock units per sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "PurchaseUnitOfMeasure",
"label": "Purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "PurchaseUMConvFctr",
"label": "Stock units per purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "UPCEAN",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ValuationName",
"label": "Valuation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "ProcurementName",
"label": "Procurement",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemState",
"label": "Item status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9D797641-71EC-5C9E-83A4-B3633D1816FA",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "shippingbox",
"title": "Item dossier",
"titleKey": "ItemCodeDesc"
},
{
"actions": [],
"badgeKey": "QuantityOnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BinLocation",
"label": "Bin location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnPurchaseOrder",
"label": "On purchase orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnSalesOrder",
"label": "On sales orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnBackOrder",
"label": "Back ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QuantityInShipping",
"label": "In shipping",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "6156F029-1FE6-52EB-8826-5D9F4DEA3284",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "BinLocation",
"label": "Bin location",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnHand",
"label": "On hand — stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnPurchaseOrder",
"label": "On purchase orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnSalesOrder",
"label": "On sales orders",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityOnBackOrder",
"label": "Back ordered",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "QuantityInShipping",
"label": "In shipping",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "ReorderPointQty",
"label": "Reorder point",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "MinimumOrderQty",
"label": "Minimum order quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and replenishment",
"detailRole": "information",
"isVisible": true,
"key": "MaximumOnHandQty",
"label": "Maximum on-hand quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "AverageCost",
"label": "Warehouse average cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "TotalWarehouseValue",
"label": "Warehouse stock value — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseLabel",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitOfMeasure",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ProductLine",
"label": "Product line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "UPCEAN",
"label": "UPC / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Prices and costs — source currency",
"detailRole": "information",
"isVisible": true,
"key": "StandardUnitPrice",
"label": "Standard price — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ValuationName",
"label": "Valuation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ItemState",
"label": "Item status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseStateName",
"label": "Warehouse status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "MasterAvailability",
"label": "Item master",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "CostContext",
"label": "Average-cost context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseCity",
"label": "City",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "ContactName",
"label": "Warehouse contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Item and stock",
"detailRole": "information",
"isVisible": true,
"key": "StatusComment",
"label": "Warehouse status comment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2A8E02F7-9C65-524A-A19C-99E6D2550066",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "097CB1FE-5CD1-5E83-B17C-A3A42BC1A60B",
"key": "WarehouseCode",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "shippingbox",
"title": "Stock in all warehouses",
"titleKey": "WarehouseLabel"
}
],
"relations": [
{
"childDatasetID": "E5E4E14E-F5F1-58BC-8F53-00E40C9F95E2",
"childKey": "ItemCode",
"id": "C2CFD881-EBCD-569B-A50E-A7F94D23C292",
"name": "Item dossier",
"parentDatasetID": "2659E5B8-39AF-5D62-92B0-DF43272CE13F",
"parentKey": "ItemCode"
},
{
"childDatasetID": "6156F029-1FE6-52EB-8826-5D9F4DEA3284",
"childKey": "ItemCode",
"id": "9524EEE9-A8D0-5A89-9AA9-6B4EE57EBB30",
"name": "Stock in all warehouses",
"parentDatasetID": "2659E5B8-39AF-5D62-92B0-DF43272CE13F",
"parentKey": "ItemCode"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 100 US — SQL Server",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "NOT VALIDATED ON A REAL ERP INSTALLATION. Based on official Sage 100 US 2026 FLOR documentation and synthetic tests. Map your authorized company source, run the read/compatibility test at import, and check columns, permissions, results and performance before business use. DEMO images, when provided, use synthetic data.\n\nFor warehouse, purchasing and operations teams: choose a warehouse, see on-hand stock, outstanding purchase/sales quantities, back orders, shipping quantities, reorder thresholds and native warehouse cost/value. Open the item dossier or compare that same item across all its warehouses. Inactive/restricted warehouses and item status remain visible; this report does not authorize transfers.\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\nAmounts are native source values, with no invented currency code, conversion, tax treatment or cross-company total. Verify the company currency and any multicurrency extensions. Standard prices are reference prices, not negotiated customer quotes. Standard cost is not inventory valuation unless that valuation method is in use. Average cost may be an estimate when stock is negative. On-hand quantities use the stock unit; sales/purchase units and their conversion factors are shown separately. No invented available-stock calculation or replenishment recommendation. Only regular inventory items are included in the Free catalog. The Pro warehouse report retains orphan warehouse rows with an explicit missing-master message instead of silently dropping stock. Reads are on demand, at most 2,000 rows each, without scheduled refresh. Narrow filters if the limit is reached; search only covers loaded rows. Row limits do not guarantee inexpensive scans. SQL permissions must explicitly allow all shown data, including costs. Display filters do not replace database access control.\n\nUnofficial community configuration for Sage 100 US 2026, SQL Server deployment (formerly Premium), Inventory Management enabled. Not ProvideX Standard/Advanced, Sage 100 France, or Sage 100 Contractor. A company-provided SQL read-only account is required; the package contains no server, credentials or business rows. Verify dbo schema, edition, logical/physical column conversions, full keys, permissions and execution plans. Dictionary: https://help-sage100.na.sage.com/2026/FLOR/index.htm Functional help: https://help-sage100.na.sage.com/2026/Subsystems/IM/IMMainFields/Inventory_Maintenance_-_Fields.htm\n\nPro: one source, three lists, two related buttons and custom read-only SQL. Choose the warehouse before reading; related lists are fetched only when opened.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "C803BB54-E751-5948-B165-DF77A7A92780",
"rootButtonCount": 1,
"summary": "Warehouse stock, replenishment quantities, costs, item dossier and stock in other warehouses.",
"tags": [
"Sage 100 US",
"SQL Server",
"Inventory",
"Pro"
],
"title": "Stock by warehouse — Pro"
}
}