Description: Returns the new item activity grid from the New Items screen in the Inventory module
Resource: NewItemDetail/
Verb: GET
Returns: JSON Array containing records matching: New Items Activity
Example Response JSON:
[{
"AlertKeyId": 12,
"AlertType": 13,
"PrimaryId": 12,
"PrimaryIdProperty": 1,
"ItemAge": 45,
"ItemSiteId": 12,
"ShipperId": 5,
"ItemId": 9,
"SiteId": 8,
"BuyerId": 8,
"PrimarySupplierId": 57,
"ItemSiteCategory1Id": 3,
"ItemSiteCategory2Id": 31,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ItemSiteCategory6Id": 1,
"ItemSiteCategory7Id": 1,
"ItemSiteCategory8Id": 1,
"ItemCode": "0101019",
"SiteCode": "95",
"BuyerName": "Richard Petty",
"ItemDescription": "Contoso 8GB Super-Slim MP3/Video Player M800 Pink",
"ActiveOrderPolicy": 2,
"PrimarySupplierCode": "V0059",
"PrimarySupplierName": "Contoso Hub Warehouse",
"SupplierName": "Contoso Hub Warehouse",
"BoMPosition": 4,
"AbcClass": "N",
"XyzClass": "N",
"OnHandQuantity": 0.00000,
"TotalOnOrderQuantity": 0.00000,
"TotalAvailableQuantity": 0.00000,
"TotalAvailableQuantityAtLeadTime": 0.00000,
"CurrentCost": 0.81000,
"StandardCost": 0.81000,
"FirstSaleDate": "2024-05-03T00:00:00",
"LastSaleDate": "2024-05-03T00:00:00",
"OnHandBalance": 0.00000,
"ExcessQuantity": 0.00000,
"ExcessBalance": 0.000000000,
"TotalHistoricalDailyUsage": 0.55813953488372092,
"TotalForecastedDailyUsage": 1.04348,
"TotalDailyUsageAtLeadTime": 1.04348,
"ResolvedItemStatus": 1,
"HasForecast": true,
"CustomerShipToCount": 1,
"CustomerCount": 1,
"TotalHits": 1,
"ItemSiteCategory1Name": "Audio",
"ItemSiteCategory2Name": "MP4&MP3",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"SiteGroupInventoryPosition": 8,
"SiteGroupUsagePattern": 16,
"SiteGroupOnHandQuantity": 213.00000,
"SiteGroupAvailableQuantity": 213.00000,
"SiteGroupCurrentExcessQuantity": 0.00000,
"SiteGroupCurrentExcessThreshold": 399.00000,
"AlertSummaryId": 0,
"DateUpdated": "0001-01-01T00:00:00+00:00",
"ASt": 0,
"APri": 0,
"AlertTypeName": "NewItem"
},
{
"AlertKeyId": 23,
"AlertType": 13,
"PrimaryId": 23,
"PrimaryIdProperty": 1,
"ItemAge": 87,
"ItemSiteId": 23,
"ShipperId": 5,
"ItemId": 33,
"SiteId": 6,
"BuyerId": 3,
"PrimarySupplierId": 44,
"ItemSiteCategory1Id": 3,
"ItemSiteCategory2Id": 31,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ItemSiteCategory6Id": 1,
"ItemSiteCategory7Id": 1,
"ItemSiteCategory8Id": 1,
"ItemCode": "0101004",
"SiteCode": "96",
"BuyerName": "Jim Clark",
"ItemDescription": "Contoso 2G MP3 Player E200 Silver",
"ActiveOrderPolicy": 2,
"PrimarySupplierCode": "V0046",
"PrimarySupplierName": "Warehouse 38",
"SupplierName": "Warehouse 38",
"BoMPosition": 0,
"AbcClass": "N",
"XyzClass": "N",
"OnHandQuantity": 0.00000,
"TotalOnOrderQuantity": 0.00000,
"TotalAvailableQuantity": 0.00000,
"TotalAvailableQuantityAtLeadTime": 0.00000,
"CurrentCost": 0.81000,
"StandardCost": 0.81000,
"FirstSaleDate": "2024-03-22T00:00:00",
"LastSaleDate": "2024-03-22T00:00:00",
"OnHandBalance": 0.00000,
"ExcessQuantity": 0.00000,
"ExcessBalance": 0.000000000,
"TotalHistoricalDailyUsage": 0.0,
"TotalForecastedDailyUsage": 0.08762,
"TotalDailyUsageAtLeadTime": 0.08762,
"ResolvedItemStatus": 1,
"HasForecast": true,
"CustomerShipToCount": 1,
"CustomerCount": 1,
"TotalHits": 1,
"ItemSiteCategory1Name": "Audio",
"ItemSiteCategory2Name": "MP4&MP3",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"SupplierItemCode": "0101004",
"SiteGroupInventoryPosition": 1,
"SiteGroupUsagePattern": 8,
"SiteGroupOnHandQuantity": 0.00000,
"SiteGroupAvailableQuantity": 0.00000,
"SiteGroupCurrentExcessQuantity": 0.00000,
"SiteGroupCurrentExcessThreshold": 108.00000,
"AlertSummaryId": 0,
"DateUpdated": "0001-01-01T00:00:00+00:00",
"ASt": 0,
"APri": 0,
"AlertTypeName": "NewItem"
},
,
... ]