NOTE: This is an article for the legacy API. To access updated information on this endpoint, please reference the HTML guide attached to the bottom of the REST API Access document
Description: Returns the Projected Stockout Detail grid from the Projected Stockout screen in the Purchase module
Resource: ProjectedStockOutDetail/
Verb: GET
Returns: JSON Array of projected stockout objects
Example JSON:
[
{
"AlertKeyId": 37,
"AlertType": 22,
"PrimaryId": 37,
"PrimaryIdProperty": 2,
"MostBalanceBelowPanicPoint": 169.8500000000,
"UnitsBelowPanicPoint": 53.00000,
"ValueBelowPanicPoint": 209.3500000000,
"ProjectedDaysOfSupply": 3.18,
"ItemSiteSupplierId": 37,
"ItemSiteId": 33,
"OutOfStockQuantity": 0.00000,
"StandardCost": 3.95000,
"StandardPrice": 3.95000,
"ShipperId": 1,
"ItemId": 3,
"SiteId": 1,
"PrimarySupplierId": 16,
"ItemCode": "0101026",
"SiteCode": "271",
"SupplierItemCode": "0101026",
"BuyerName": "AJ Foyt",
"ItemDescription": "Contoso 16GB Mp5 Player M1600 Green",
"ActiveOrderPolicy": 2,
"ResolvedItemStatus": 1,
"ActivePanicPoint": 96.00000,
"ActiveSafetyStock": 192.00000,
"AbcClass": "A",
"XyzClass": "X",
"PrimarySupplierCode": "V0027",
"PrimarySupplierName": "Tyrell Corp. ",
"TargetServiceLevel": 0.990000,
"ActivePlanningLeadTime": 3,
"WorstProjectedInventoryPosition": 2,
"InventoryPositionAtLeadTime": 2,
"TotalOnHandQuantity": 43.00000,
"TotalAvailableQuantity": 40.00000,
"TotalAvailableQuantityAtLeadTime": 40.00000,
"TotalOnOrderQuantity": 80.00000,
"TotalHistoricalDailyUsage": 7.558139534883721,
"InventoryPosition": 2,
"LostRevenuePerDay": 30.0,
"TotalOnDemandOrderQuantity": 3.00000,
"TotalOnDemandValue": 11.85000,
"ItemSiteCategory1Name": "Audio",
"ItemSiteCategory2Name": "MP4&MP3",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"ReplacementFlags": 0,
"IsOnHandCopied": false,
"ItemSiteCategory1Id": 7,
"ItemSiteCategory2Id": 24,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ItemSiteCategory6Id": 1,
"ItemSiteCategory7Id": 1,
"ItemSiteCategory8Id": 1,
"BuyerId": 3,
"BoMPosition": 0,
"ProjectedBelowPanicPointDate": "2024/06/17",
"ProjectedAbovePanicPointDate": "2024/06/18",
"LowestQuantityAfterBelowPanicPoint": 43.00000,
"NextExpectedShipDate": "2024/02/12",
"NextExpectedDockDate": "2024/02/14",
"NextErpOrderNumber": "0024",
"NextOrderRemainingReleaseQuantity": 80.00000,
"TotalForecastedDailyUsage": 13.505952380952381,
"AlertSummaryId": 1982,
"AMsg": "Item is projected below panic point on 6/17/2024, eventually reaching 53.00 units below panic point.",
"DateCreated": "2024/06/17",
"DateUpdated": "2024-06-17T00:00:00-05:00",
"ASt": 1,
"APri": 1,
"Rank": 453,
"AlertTypeName": "ProjectedStockOut"
},
...
]