Warehouse stock, product dossier and locations — Pro
Choose a warehouse; inspect native quantities, planning settings and the product across warehouses.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Documentary and synthetic checks, not a real SYSPRO installation.
For warehouse teams, purchasing, production and managers: choose a warehouse, find a product, see its on-hand, allocated and on-order native quantities with its stocking unit and product class. Open complete stock Details for WIP allocations/reservations, dispatched quantities and stored planning thresholds. Open the current product record for descriptions, supplier/buyer codes, lead time, references and unit settings, then inspect that product across warehouses on demand.
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 authorised source and your Cifru plan.
Pro: one source, three live lists with same-row Details and two nested lazy sub-buttons. No widgets or periodic refresh. The warehouse selection is required at opening before the final 2,000-row cap. Existing workspace resources count towards plan limits. Search/local filters apply only to loaded rows; a capped result is not a complete inventory.
QUANTITIES: exact native decimal text, no rounding, sums, valuation or available-to-sell formula. On hand includes held stock and is NOT freely sellable inventory. On-order is not only purchase orders; WIP reserved is the stock-code-level value, not all lot reservations. Allocated fields remain independent native values, without guessed reclassification. NULL is not zero and negative quantities remain negative. Quantities sort/filter as text in local views.
UNIT REPRESENTATION: stocking and alternate units, current factor and method code are shown separately. SYSPRO unit quantity processing can present a native 10.5 as 10/06 with 12 alternate units per stocking unit. Cifru shows the native decimal, NOT a converted boxes/pieces display. Confirm the installed quantity basis/settings before operational use. No StockAndAltUm physical SQL column, Units/Edited API property, kg/m3 or case conversion is inferred. Current product settings are not historical movement units. Thresholds are stored settings, not an MRP or automatic replenishment recommendation. Currency/cost, bin, lot, serial and movement history are not included without their own verified contracts.
IDENTITY/SCOPE: complete StockCode+Warehouse within the authorised inventory database; technical length-prefixed UTF-16 key is hidden. Missing/empty/duplicate warehouse identities are not arbitrarily selected. Missing or ambiguous optional product records preserve the stock row with an explicit context warning; no first match or multiplication. Product drill-down requires a unique current product. Shared inventory/company scope and actual warehouse authorisation must be enforced at the source, not inferred from Cifru filters.
COMPATIBILITY: selected vendor SQL examples (2019 R2/2026 R2), 2026 R1 explicit direct-table OData mapping/native inventory manuals, older COMFCH business identity and March2021 default dbo architecture, plus INVSST quantity-format semantics only. Business-object input/output is not installed SQL DDL. Mixed editions do not certify a current deployment. SQL Server2012+ for CONCAT; validate dbo, all selected fields/types, collation, full identity uniqueness, units, results and read performance at import. Row caps do not guarantee a cheap query; correlated uniqueness checks need appropriate indexes. Narrow the authorised source if needed.
SECURITY: user-authorised least-privilege SELECT-only connection. Direct SQL does not inherit ERP operator ACL; read access to shared inventory must be reviewed separately. No production rows, credentials or server addresses are in the package. Eight native fictional DEMO gallery images are approved; they will not constitute a real ERP/SQL Server/iOS compatibility test. Unofficial configuration, not endorsed by SYSPRO.
Documentation: https://help.syspro.com/business-object-library/G_Objects/inv/invsst/invsst.htm ; https://help.syspro.com/syspro-8-2026-r2/topics/machine-learning/machine-learning-ovr.htm ; https://help.syspro.com/syspro-8-2026-r1/topics/syspro-services/syspro-odata-service/syspro-odata-service.htm ; https://help.syspro.com/syspro-8-2026-r1/g_programs/inv/invpen/invpen.htm ; https://help.syspro.com/syspro-8-2026-r1/g_programs/inv/invpws/invpws.htm
Gallery: Eight representative native Cifru images show complete stock cards, stock Details, the actual product drill-down and its Details, all three warehouse cards for that product, and selected warehouse Details. All data are invented and marked DEMO. The gallery demonstrates every level but does not display all 62 useful Detail positions simultaneously. All 62 populated positions were independently checked across 16 personally viewed original private PNG/XML pairs; repeated contexts are not 62 distinct physical columns. Fields were not removed or images retouched to fit the eight-image gallery. Entire RAW is retained privately, pending its separate video audit. This is not a real SYSPRO, SQL Server or iOS connection/compatibility/performance test.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Warehouse stock
- Details: Current product record
- Details: Stock across warehouses
- Sub-button: Current product record
- Sub-button: Product across 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(CAST(N'' AS nvarchar(max)), DATALENGTH(CAST(w.StockCode AS nvarchar(max))), N':', CAST(w.StockCode AS nvarchar(max)), N'|', DATALENGTH(CAST(w.Warehouse AS nvarchar(max))), N':', CAST(w.Warehouse AS nvarchar(max)), N'|') AS StockKey, COALESCE(NULLIF(m.Description,N''),w.StockCode) AS RecordTitle, CAST(w.StockCode AS nvarchar(max)) AS StockCode, CAST(w.Warehouse AS nvarchar(max)) AS Warehouse, CAST(w.QtyOnHand AS nvarchar(max)) AS QtyOnHand, CAST(w.QtyAllocated AS nvarchar(max)) AS QtyAllocated, CAST(w.QtyOnOrder AS nvarchar(max)) AS QtyOnOrder, CAST(w.QtyAllocatedWip AS nvarchar(max)) AS QtyAllocatedWip, CAST(w.QtyDispatched AS nvarchar(max)) AS QtyDispatched, CAST(w.QtyWipReserved AS nvarchar(max)) AS QtyWipReserved, CAST(w.MinimumQty AS nvarchar(max)) AS MinimumQty, CAST(w.MaximumQty AS nvarchar(max)) AS MaximumQty, CAST(w.SafetyStockQty AS nvarchar(max)) AS SafetyStockQty, CAST(w.ReOrderQty AS nvarchar(max)) AS ReOrderQty, CAST(m.Description AS nvarchar(max)) AS Description, CAST(m.LongDesc AS nvarchar(max)) AS LongDesc, CAST(m.ProductClass AS nvarchar(max)) AS ProductClass, CAST(m.StockUom AS nvarchar(max)) AS StockUom, CAST(m.AlternateUom AS nvarchar(max)) AS AlternateUom, CAST(m.ConvFactAltUom AS nvarchar(max)) AS ConvFactAltUom, CAST(m.ConvMulDiv AS nvarchar(max)) AS ConvMulDiv, CAST(m.Supplier AS nvarchar(max)) AS Supplier, CAST(m.Buyer AS nvarchar(max)) AS Buyer, CAST(m.LeadTime AS nvarchar(max)) AS LeadTime, CASE WHEN m.StockCode IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current product' END AS ProductContext FROM dbo.InvWarehouse w LEFT JOIN dbo.InvMaster m ON m.StockCode=w.StockCode AND 1=(SELECT COUNT(*) FROM dbo.InvMaster mq WHERE mq.StockCode=m.StockCode) WHERE w.StockCode IS NOT NULL AND w.Warehouse IS NOT NULL AND DATALENGTH(CAST(w.StockCode AS nvarchar(max)))>0 AND DATALENGTH(CAST(w.Warehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM dbo.InvWarehouse wq WHERE wq.StockCode=w.StockCode AND wq.Warehouse=w.Warehouse)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CAST(m.StockCode AS nvarchar(max)) AS StockCode, CAST(m.Description AS nvarchar(max)) AS Description, CAST(m.LongDesc AS nvarchar(max)) AS LongDesc, CAST(m.ProductClass AS nvarchar(max)) AS ProductClass, CAST(m.Supplier AS nvarchar(max)) AS Supplier, CAST(m.Buyer AS nvarchar(max)) AS Buyer, CAST(m.LeadTime AS nvarchar(max)) AS LeadTime, CAST(m.StockUom AS nvarchar(max)) AS StockUom, CAST(m.AlternateUom AS nvarchar(max)) AS AlternateUom, CAST(m.OtherUom AS nvarchar(max)) AS OtherUom, CAST(m.ConvFactAltUom AS nvarchar(max)) AS ConvFactAltUom, CAST(m.ConvMulDiv AS nvarchar(max)) AS ConvMulDiv, CAST(m.ConvFactOthUom AS nvarchar(max)) AS ConvFactOthUom, CAST(m.MulDiv AS nvarchar(max)) AS MulDiv, CAST(m.AlternateKey1 AS nvarchar(max)) AS AlternateKey1, CAST(m.AlternateKey2 AS nvarchar(max)) AS AlternateKey2 FROM dbo.InvMaster m WHERE m.StockCode=:stock AND 1=(SELECT COUNT(*) FROM dbo.InvMaster mq WHERE mq.StockCode=m.StockCode)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(CAST(N'' AS nvarchar(max)), DATALENGTH(CAST(w.StockCode AS nvarchar(max))), N':', CAST(w.StockCode AS nvarchar(max)), N'|', DATALENGTH(CAST(w.Warehouse AS nvarchar(max))), N':', CAST(w.Warehouse AS nvarchar(max)), N'|') AS StockKey, COALESCE(NULLIF(m.Description,N''),w.StockCode) AS RecordTitle, CAST(w.StockCode AS nvarchar(max)) AS StockCode, CAST(w.Warehouse AS nvarchar(max)) AS Warehouse, CAST(w.QtyOnHand AS nvarchar(max)) AS QtyOnHand, CAST(w.QtyAllocated AS nvarchar(max)) AS QtyAllocated, CAST(w.QtyOnOrder AS nvarchar(max)) AS QtyOnOrder, CAST(w.QtyAllocatedWip AS nvarchar(max)) AS QtyAllocatedWip, CAST(w.QtyDispatched AS nvarchar(max)) AS QtyDispatched, CAST(w.QtyWipReserved AS nvarchar(max)) AS QtyWipReserved, CAST(w.MinimumQty AS nvarchar(max)) AS MinimumQty, CAST(w.MaximumQty AS nvarchar(max)) AS MaximumQty, CAST(w.SafetyStockQty AS nvarchar(max)) AS SafetyStockQty, CAST(w.ReOrderQty AS nvarchar(max)) AS ReOrderQty, CAST(m.Description AS nvarchar(max)) AS Description, CAST(m.LongDesc AS nvarchar(max)) AS LongDesc, CAST(m.ProductClass AS nvarchar(max)) AS ProductClass, CAST(m.StockUom AS nvarchar(max)) AS StockUom, CAST(m.AlternateUom AS nvarchar(max)) AS AlternateUom, CAST(m.ConvFactAltUom AS nvarchar(max)) AS ConvFactAltUom, CAST(m.ConvMulDiv AS nvarchar(max)) AS ConvMulDiv, CAST(m.Supplier AS nvarchar(max)) AS Supplier, CAST(m.Buyer AS nvarchar(max)) AS Buyer, CAST(m.LeadTime AS nvarchar(max)) AS LeadTime, CASE WHEN m.StockCode IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current product' END AS ProductContext FROM dbo.InvWarehouse w LEFT JOIN dbo.InvMaster m ON m.StockCode=w.StockCode AND 1=(SELECT COUNT(*) FROM dbo.InvMaster mq WHERE mq.StockCode=m.StockCode) WHERE w.StockCode IS NOT NULL AND w.Warehouse IS NOT NULL AND DATALENGTH(CAST(w.StockCode AS nvarchar(max)))>0 AND DATALENGTH(CAST(w.Warehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM dbo.InvWarehouse wq WHERE wq.StockCode=w.StockCode AND wq.Warehouse=w.Warehouse) AND w.StockCode=:stock
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "SYSPRO — authorised inventory SQL Server database",
"id": "710FFFB1-9EF5-54F1-ADAB-B145FC2FBF80",
"kind": "sqlServer",
"requiredObjects": [
"dbo.InvMaster",
"dbo.InvWarehouse"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SYSPRO",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B24C1C63-32B7-5C29-9FA0-30C0C928A102",
"key": "StockCode",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "E83BADB3-1D37-58B4-ABC5-6A1A0B3A0C2E",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Internal complete warehouse identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RecordTitle",
"label": "Card title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordTitle",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Warehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Warehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyOnHand",
"label": "On hand — includes held stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyOnHand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyAllocated",
"label": "Allocated quantity (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyAllocated",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyOnOrder",
"label": "On order (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyOnOrder",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyAllocatedWip",
"label": "Allocated to WIP (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyAllocatedWip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QtyDispatched",
"label": "Dispatched, not invoiced (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyDispatched",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QtyWipReserved",
"label": "WIP reserved at stock-code level",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyWipReserved",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MinimumQty",
"label": "Minimum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MinimumQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MaximumQty",
"label": "Maximum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MaximumQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SafetyStockQty",
"label": "Safety stock quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SafetyStockQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReOrderQty",
"label": "Reorder quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReOrderQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongDesc",
"label": "Extended description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongDesc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductClass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AlternateUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvFactAltUom",
"label": "Alternate unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvFactAltUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvMulDiv",
"label": "Alternate method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvMulDiv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Supplier",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Buyer",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LeadTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductContext",
"label": "Current product context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Warehouse stock",
"primaryKey": "StockKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"StockCode",
"Warehouse",
"QtyOnHand",
"QtyAllocated",
"QtyOnOrder",
"QtyAllocatedWip",
"QtyDispatched",
"QtyWipReserved",
"MinimumQty",
"MaximumQty",
"SafetyStockQty",
"ReOrderQty",
"Description",
"LongDesc",
"ProductClass",
"StockUom",
"AlternateUom",
"ConvFactAltUom",
"ConvMulDiv",
"Supplier",
"Buyer",
"LeadTime",
"ProductContext"
],
"sourceID": "710FFFB1-9EF5-54F1-ADAB-B145FC2FBF80",
"sqlQuery": "SELECT CONCAT(CAST(N'' AS nvarchar(max)), DATALENGTH(CAST(w.StockCode AS nvarchar(max))), N':', CAST(w.StockCode AS nvarchar(max)), N'|', DATALENGTH(CAST(w.Warehouse AS nvarchar(max))), N':', CAST(w.Warehouse AS nvarchar(max)), N'|') AS StockKey, COALESCE(NULLIF(m.Description,N''),w.StockCode) AS RecordTitle, CAST(w.StockCode AS nvarchar(max)) AS StockCode, CAST(w.Warehouse AS nvarchar(max)) AS Warehouse, CAST(w.QtyOnHand AS nvarchar(max)) AS QtyOnHand, CAST(w.QtyAllocated AS nvarchar(max)) AS QtyAllocated, CAST(w.QtyOnOrder AS nvarchar(max)) AS QtyOnOrder, CAST(w.QtyAllocatedWip AS nvarchar(max)) AS QtyAllocatedWip, CAST(w.QtyDispatched AS nvarchar(max)) AS QtyDispatched, CAST(w.QtyWipReserved AS nvarchar(max)) AS QtyWipReserved, CAST(w.MinimumQty AS nvarchar(max)) AS MinimumQty, CAST(w.MaximumQty AS nvarchar(max)) AS MaximumQty, CAST(w.SafetyStockQty AS nvarchar(max)) AS SafetyStockQty, CAST(w.ReOrderQty AS nvarchar(max)) AS ReOrderQty, CAST(m.Description AS nvarchar(max)) AS Description, CAST(m.LongDesc AS nvarchar(max)) AS LongDesc, CAST(m.ProductClass AS nvarchar(max)) AS ProductClass, CAST(m.StockUom AS nvarchar(max)) AS StockUom, CAST(m.AlternateUom AS nvarchar(max)) AS AlternateUom, CAST(m.ConvFactAltUom AS nvarchar(max)) AS ConvFactAltUom, CAST(m.ConvMulDiv AS nvarchar(max)) AS ConvMulDiv, CAST(m.Supplier AS nvarchar(max)) AS Supplier, CAST(m.Buyer AS nvarchar(max)) AS Buyer, CAST(m.LeadTime AS nvarchar(max)) AS LeadTime, CASE WHEN m.StockCode IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current product' END AS ProductContext FROM dbo.InvWarehouse w LEFT JOIN dbo.InvMaster m ON m.StockCode=w.StockCode AND 1=(SELECT COUNT(*) FROM dbo.InvMaster mq WHERE mq.StockCode=m.StockCode) WHERE w.StockCode IS NOT NULL AND w.Warehouse IS NOT NULL AND DATALENGTH(CAST(w.StockCode AS nvarchar(max)))>0 AND DATALENGTH(CAST(w.Warehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM dbo.InvWarehouse wq WHERE wq.StockCode=w.StockCode AND wq.Warehouse=w.Warehouse)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SYSPRO",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B24C1C63-32B7-5C29-9FA0-30C0C928A102",
"key": "StockCode",
"type": "text"
}
],
"id": "AE897A99-0747-5EC1-BD77-096E5B452E78",
"mappings": [
{
"commonFieldKey": "",
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongDesc",
"label": "Extended description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongDesc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductClass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Supplier",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Buyer",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LeadTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AlternateUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OtherUom",
"label": "Other unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "OtherUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvFactAltUom",
"label": "Alternate unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvFactAltUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvMulDiv",
"label": "Alternate method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvMulDiv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvFactOthUom",
"label": "Other unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvFactOthUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MulDiv",
"label": "Other method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MulDiv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AlternateKey1",
"label": "Alternate reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AlternateKey1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AlternateKey2",
"label": "Alternate reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AlternateKey2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Current product record",
"primaryKey": "StockCode",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockCode",
"id": "BAFB4E0E-90BE-5198-AD08-E59D337539FF",
"name": "stock",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"StockCode",
"Description",
"LongDesc",
"ProductClass",
"Supplier",
"Buyer",
"LeadTime",
"StockUom",
"AlternateUom",
"OtherUom",
"ConvFactAltUom",
"ConvMulDiv",
"ConvFactOthUom",
"MulDiv",
"AlternateKey1",
"AlternateKey2"
],
"sourceID": "710FFFB1-9EF5-54F1-ADAB-B145FC2FBF80",
"sqlQuery": "SELECT CAST(m.StockCode AS nvarchar(max)) AS StockCode, CAST(m.Description AS nvarchar(max)) AS Description, CAST(m.LongDesc AS nvarchar(max)) AS LongDesc, CAST(m.ProductClass AS nvarchar(max)) AS ProductClass, CAST(m.Supplier AS nvarchar(max)) AS Supplier, CAST(m.Buyer AS nvarchar(max)) AS Buyer, CAST(m.LeadTime AS nvarchar(max)) AS LeadTime, CAST(m.StockUom AS nvarchar(max)) AS StockUom, CAST(m.AlternateUom AS nvarchar(max)) AS AlternateUom, CAST(m.OtherUom AS nvarchar(max)) AS OtherUom, CAST(m.ConvFactAltUom AS nvarchar(max)) AS ConvFactAltUom, CAST(m.ConvMulDiv AS nvarchar(max)) AS ConvMulDiv, CAST(m.ConvFactOthUom AS nvarchar(max)) AS ConvFactOthUom, CAST(m.MulDiv AS nvarchar(max)) AS MulDiv, CAST(m.AlternateKey1 AS nvarchar(max)) AS AlternateKey1, CAST(m.AlternateKey2 AS nvarchar(max)) AS AlternateKey2 FROM dbo.InvMaster m WHERE m.StockCode=:stock AND 1=(SELECT COUNT(*) FROM dbo.InvMaster mq WHERE mq.StockCode=m.StockCode)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SYSPRO",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "CE0A66E7-464C-5EEE-82B3-B3162DE60E87",
"key": "Warehouse",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "DA85A1C0-89AC-55A2-AB2E-0FCBAAAB0833",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Internal complete warehouse identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RecordTitle",
"label": "Card title",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RecordTitle",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Warehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Warehouse",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyOnHand",
"label": "On hand — includes held stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyOnHand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyAllocated",
"label": "Allocated quantity (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyAllocated",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyOnOrder",
"label": "On order (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyOnOrder",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "QtyAllocatedWip",
"label": "Allocated to WIP (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyAllocatedWip",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QtyDispatched",
"label": "Dispatched, not invoiced (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyDispatched",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QtyWipReserved",
"label": "WIP reserved at stock-code level",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QtyWipReserved",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MinimumQty",
"label": "Minimum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MinimumQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MaximumQty",
"label": "Maximum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "MaximumQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SafetyStockQty",
"label": "Safety stock quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SafetyStockQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReOrderQty",
"label": "Reorder quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ReOrderQty",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LongDesc",
"label": "Extended description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LongDesc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductClass",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "StockUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AlternateUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvFactAltUom",
"label": "Alternate unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvFactAltUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConvMulDiv",
"label": "Alternate method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ConvMulDiv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Supplier",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "Buyer",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "LeadTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductContext",
"label": "Current product context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ProductContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Product across warehouses",
"primaryKey": "StockKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "StockCode",
"id": "BAFB4E0E-90BE-5198-AD08-E59D337539FF",
"name": "stock",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"StockCode",
"Warehouse",
"QtyOnHand",
"QtyAllocated",
"QtyOnOrder",
"QtyAllocatedWip",
"QtyDispatched",
"QtyWipReserved",
"MinimumQty",
"MaximumQty",
"SafetyStockQty",
"ReOrderQty",
"Description",
"LongDesc",
"ProductClass",
"StockUom",
"AlternateUom",
"ConvFactAltUom",
"ConvMulDiv",
"Supplier",
"Buyer",
"LeadTime",
"ProductContext"
],
"sourceID": "710FFFB1-9EF5-54F1-ADAB-B145FC2FBF80",
"sqlQuery": "SELECT CONCAT(CAST(N'' AS nvarchar(max)), DATALENGTH(CAST(w.StockCode AS nvarchar(max))), N':', CAST(w.StockCode AS nvarchar(max)), N'|', DATALENGTH(CAST(w.Warehouse AS nvarchar(max))), N':', CAST(w.Warehouse AS nvarchar(max)), N'|') AS StockKey, COALESCE(NULLIF(m.Description,N''),w.StockCode) AS RecordTitle, CAST(w.StockCode AS nvarchar(max)) AS StockCode, CAST(w.Warehouse AS nvarchar(max)) AS Warehouse, CAST(w.QtyOnHand AS nvarchar(max)) AS QtyOnHand, CAST(w.QtyAllocated AS nvarchar(max)) AS QtyAllocated, CAST(w.QtyOnOrder AS nvarchar(max)) AS QtyOnOrder, CAST(w.QtyAllocatedWip AS nvarchar(max)) AS QtyAllocatedWip, CAST(w.QtyDispatched AS nvarchar(max)) AS QtyDispatched, CAST(w.QtyWipReserved AS nvarchar(max)) AS QtyWipReserved, CAST(w.MinimumQty AS nvarchar(max)) AS MinimumQty, CAST(w.MaximumQty AS nvarchar(max)) AS MaximumQty, CAST(w.SafetyStockQty AS nvarchar(max)) AS SafetyStockQty, CAST(w.ReOrderQty AS nvarchar(max)) AS ReOrderQty, CAST(m.Description AS nvarchar(max)) AS Description, CAST(m.LongDesc AS nvarchar(max)) AS LongDesc, CAST(m.ProductClass AS nvarchar(max)) AS ProductClass, CAST(m.StockUom AS nvarchar(max)) AS StockUom, CAST(m.AlternateUom AS nvarchar(max)) AS AlternateUom, CAST(m.ConvFactAltUom AS nvarchar(max)) AS ConvFactAltUom, CAST(m.ConvMulDiv AS nvarchar(max)) AS ConvMulDiv, CAST(m.Supplier AS nvarchar(max)) AS Supplier, CAST(m.Buyer AS nvarchar(max)) AS Buyer, CAST(m.LeadTime AS nvarchar(max)) AS LeadTime, CASE WHEN m.StockCode IS NULL THEN N'Missing or ambiguous — verify source' ELSE N'Unique current product' END AS ProductContext FROM dbo.InvWarehouse w LEFT JOIN dbo.InvMaster m ON m.StockCode=w.StockCode AND 1=(SELECT COUNT(*) FROM dbo.InvMaster mq WHERE mq.StockCode=m.StockCode) WHERE w.StockCode IS NOT NULL AND w.Warehouse IS NOT NULL AND DATALENGTH(CAST(w.StockCode AS nvarchar(max)))>0 AND DATALENGTH(CAST(w.Warehouse AS nvarchar(max)))>0 AND 1=(SELECT COUNT(*) FROM dbo.InvWarehouse wq WHERE wq.StockCode=w.StockCode AND wq.Warehouse=w.Warehouse) AND w.StockCode=:stock",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "C0343EF1-00BD-5C2F-ADF4-0779181D5E50",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A0323B8A-5418-5E4B-99A1-345593A375D1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "AE897A99-0747-5EC1-BD77-096E5B452E78",
"title": "Current product record",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnHand",
"label": "On hand — includes held stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QtyAllocated",
"label": "Allocated quantity (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnOrder",
"label": "On order (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "E83BADB3-1D37-58B4-ABC5-6A1A0B3A0C2E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "Warehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "LongDesc",
"label": "Extended description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "ProductContext",
"label": "Current product context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnHand",
"label": "On hand — includes held stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyAllocated",
"label": "Allocated quantity (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnOrder",
"label": "On order (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyAllocatedWip",
"label": "Allocated to WIP (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyWipReserved",
"label": "WIP reserved at stock-code level",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyDispatched",
"label": "Dispatched, not invoiced (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "MinimumQty",
"label": "Minimum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "MaximumQty",
"label": "Maximum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "SafetyStockQty",
"label": "Safety stock quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "ReOrderQty",
"label": "Reorder quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current unit settings — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current unit settings — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "ConvFactAltUom",
"label": "Alternate unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current unit settings — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "ConvMulDiv",
"label": "Alternate method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D1582B16-633C-5AAB-8462-8A25081B6669",
"openFilters": [
{
"id": "0724F921-59E3-5C1A-9FBF-7CD733E7E744",
"includeAllOption": false,
"key": "Warehouse",
"title": "Choose authorised warehouse",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B24C1C63-32B7-5C29-9FA0-30C0C928A102",
"key": "StockCode",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Warehouse",
"systemImage": "doc.text",
"title": "Warehouse stock",
"titleKey": "RecordTitle"
},
{
"actions": [
{
"id": "EAB8E2DA-B214-53E5-B9FB-F06B51A02B95",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C5CCF0F6-5626-5B1C-B641-4C40FC5F76E2",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DA85A1C0-89AC-55A2-AB2E-0FCBAAAB0833",
"title": "Stock across warehouses",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "AE897A99-0747-5EC1-BD77-096E5B452E78",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "LongDesc",
"label": "Extended description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Purchasing and planning",
"detailRole": "information",
"isVisible": true,
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Purchasing and planning",
"detailRole": "information",
"isVisible": true,
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Purchasing and planning",
"detailRole": "information",
"isVisible": true,
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stocking and alternate unit",
"detailRole": "information",
"isVisible": true,
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stocking and alternate unit",
"detailRole": "information",
"isVisible": true,
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stocking and alternate unit",
"detailRole": "information",
"isVisible": true,
"key": "ConvFactAltUom",
"label": "Alternate unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stocking and alternate unit",
"detailRole": "information",
"isVisible": true,
"key": "ConvMulDiv",
"label": "Alternate method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other unit",
"detailRole": "information",
"isVisible": true,
"key": "OtherUom",
"label": "Other unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other unit",
"detailRole": "information",
"isVisible": true,
"key": "ConvFactOthUom",
"label": "Other unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Other unit",
"detailRole": "information",
"isVisible": true,
"key": "MulDiv",
"label": "Other method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business references",
"detailRole": "information",
"isVisible": true,
"key": "AlternateKey1",
"label": "Alternate reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business references",
"detailRole": "information",
"isVisible": true,
"key": "AlternateKey2",
"label": "Alternate reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "649D91EF-070A-58BC-8CA5-251D959B086E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "B24C1C63-32B7-5C29-9FA0-30C0C928A102",
"key": "StockCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "StockCode",
"systemImage": "doc.text",
"title": "Current product record",
"titleKey": "Description"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnHand",
"label": "On hand — includes held stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QtyAllocated",
"label": "Allocated quantity (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnOrder",
"label": "On order (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "DA85A1C0-89AC-55A2-AB2E-0FCBAAAB0833",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "StockCode",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "Warehouse",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "LongDesc",
"label": "Extended description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "ProductClass",
"label": "Product class code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product and warehouse — current record",
"detailRole": "information",
"isVisible": true,
"key": "ProductContext",
"label": "Current product context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "StockUom",
"label": "Stocking unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnHand",
"label": "On hand — includes held stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyAllocated",
"label": "Allocated quantity (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyOnOrder",
"label": "On order (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyAllocatedWip",
"label": "Allocated to WIP (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyWipReserved",
"label": "WIP reserved at stock-code level",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Native quantities — NOT freely sellable",
"detailRole": "information",
"isVisible": true,
"key": "QtyDispatched",
"label": "Dispatched, not invoiced (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "MinimumQty",
"label": "Minimum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "MaximumQty",
"label": "Maximum quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "SafetyStockQty",
"label": "Safety stock quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored planning thresholds — NOT an MRP proposal",
"detailRole": "information",
"isVisible": true,
"key": "ReOrderQty",
"label": "Reorder quantity setting",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current unit settings — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "AlternateUom",
"label": "Alternate unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current unit settings — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "ConvFactAltUom",
"label": "Alternate unit factor (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current unit settings — no conversion",
"detailRole": "information",
"isVisible": true,
"key": "ConvMulDiv",
"label": "Alternate method code (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "Supplier",
"label": "Supplier code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "Buyer",
"label": "Buyer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Current purchasing references",
"detailRole": "information",
"isVisible": true,
"key": "LeadTime",
"label": "Lead time (days, native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "237B794E-CE59-529A-8054-816CC0DA228D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "CE0A66E7-464C-5EEE-82B3-B3162DE60E87",
"key": "Warehouse",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Warehouse",
"systemImage": "doc.text",
"title": "Product across warehouses",
"titleKey": "RecordTitle"
}
],
"relations": [
{
"childDatasetID": "AE897A99-0747-5EC1-BD77-096E5B452E78",
"childKey": "StockCode",
"id": "A0323B8A-5418-5E4B-99A1-345593A375D1",
"name": "Current product record",
"parentDatasetID": "E83BADB3-1D37-58B4-ABC5-6A1A0B3A0C2E",
"parentKey": "StockCode"
},
{
"childDatasetID": "DA85A1C0-89AC-55A2-AB2E-0FCBAAAB0833",
"childKey": "StockCode",
"id": "C5CCF0F6-5626-5B1C-B641-4C40FC5F76E2",
"name": "Stock across warehouses",
"parentDatasetID": "AE897A99-0747-5EC1-BD77-096E5B452E78",
"parentKey": "StockCode"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "SYSPRO",
"changelog": "Initial Pro stock dossier, current product and lazy warehouse locations; eight native fictional DEMO images. Not a real ERP test.",
"configurationLanguages": [
"en"
],
"countries": [
"GB"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Documentary and synthetic checks, not a real SYSPRO installation.\n\nFor warehouse teams, purchasing, production and managers: choose a warehouse, find a product, see its on-hand, allocated and on-order native quantities with its stocking unit and product class. Open complete stock Details for WIP allocations/reservations, dispatched quantities and stored planning thresholds. Open the current product record for descriptions, supplier/buyer codes, lead time, references and unit settings, then inspect that product across warehouses on demand.\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 authorised source and your Cifru plan.\n\nPro: one source, three live lists with same-row Details and two nested lazy sub-buttons. No widgets or periodic refresh. The warehouse selection is required at opening before the final 2,000-row cap. Existing workspace resources count towards plan limits. Search/local filters apply only to loaded rows; a capped result is not a complete inventory.\n\nQUANTITIES: exact native decimal text, no rounding, sums, valuation or available-to-sell formula. On hand includes held stock and is NOT freely sellable inventory. On-order is not only purchase orders; WIP reserved is the stock-code-level value, not all lot reservations. Allocated fields remain independent native values, without guessed reclassification. NULL is not zero and negative quantities remain negative. Quantities sort/filter as text in local views.\n\nUNIT REPRESENTATION: stocking and alternate units, current factor and method code are shown separately. SYSPRO unit quantity processing can present a native 10.5 as 10/06 with 12 alternate units per stocking unit. Cifru shows the native decimal, NOT a converted boxes/pieces display. Confirm the installed quantity basis/settings before operational use. No StockAndAltUm physical SQL column, Units/Edited API property, kg/m3 or case conversion is inferred. Current product settings are not historical movement units. Thresholds are stored settings, not an MRP or automatic replenishment recommendation. Currency/cost, bin, lot, serial and movement history are not included without their own verified contracts.\n\nIDENTITY/SCOPE: complete StockCode+Warehouse within the authorised inventory database; technical length-prefixed UTF-16 key is hidden. Missing/empty/duplicate warehouse identities are not arbitrarily selected. Missing or ambiguous optional product records preserve the stock row with an explicit context warning; no first match or multiplication. Product drill-down requires a unique current product. Shared inventory/company scope and actual warehouse authorisation must be enforced at the source, not inferred from Cifru filters.\n\nCOMPATIBILITY: selected vendor SQL examples (2019 R2/2026 R2), 2026 R1 explicit direct-table OData mapping/native inventory manuals, older COMFCH business identity and March2021 default dbo architecture, plus INVSST quantity-format semantics only. Business-object input/output is not installed SQL DDL. Mixed editions do not certify a current deployment. SQL Server2012+ for CONCAT; validate dbo, all selected fields/types, collation, full identity uniqueness, units, results and read performance at import. Row caps do not guarantee a cheap query; correlated uniqueness checks need appropriate indexes. Narrow the authorised source if needed.\n\nSECURITY: user-authorised least-privilege SELECT-only connection. Direct SQL does not inherit ERP operator ACL; read access to shared inventory must be reviewed separately. No production rows, credentials or server addresses are in the package. Eight native fictional DEMO gallery images are approved; they will not constitute a real ERP/SQL Server/iOS compatibility test. Unofficial configuration, not endorsed by SYSPRO.\n\nDocumentation: https://help.syspro.com/business-object-library/G_Objects/inv/invsst/invsst.htm ; https://help.syspro.com/syspro-8-2026-r2/topics/machine-learning/machine-learning-ovr.htm ; https://help.syspro.com/syspro-8-2026-r1/topics/syspro-services/syspro-odata-service/syspro-odata-service.htm ; https://help.syspro.com/syspro-8-2026-r1/g_programs/inv/invpen/invpen.htm ; https://help.syspro.com/syspro-8-2026-r1/g_programs/inv/invpws/invpws.htm\n\nGallery: Eight representative native Cifru images show complete stock cards, stock Details, the actual product drill-down and its Details, all three warehouse cards for that product, and selected warehouse Details. All data are invented and marked DEMO. The gallery demonstrates every level but does not display all 62 useful Detail positions simultaneously. All 62 populated positions were independently checked across 16 personally viewed original private PNG/XML pairs; repeated contexts are not 62 distinct physical columns. Fields were not removed or images retouched to fit the eight-image gallery. Entire RAW is retained privately, pending its separate video audit. This is not a real SYSPRO, SQL Server or iOS connection/compatibility/performance test.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "45103FE9-C6DE-5079-9E45-804927C04FBB",
"rootButtonCount": 1,
"summary": "Choose a warehouse; inspect native quantities, planning settings and the product across warehouses.",
"tags": [
"SYSPRO",
"SQL Server",
"Stock",
"Warehouse",
"Inventory",
"Purchasing",
"Production",
"Pro"
],
"title": "Warehouse stock, product dossier and locations — Pro"
}
}