Skip to main content
Solved

Stock Item Data REST API

  • November 5, 2024
  • 5 replies
  • 452 views

Hi All,

 

I wanted to know how to retrieve as much information as possible for a stock item.  At the moment I am using the StockItem end point, but it only returns the QtyonHand which is only partially useful. 

When I go to Inventory Summary I see the following fields. 

 

 

This is great because I can see the full picture of the item’s allocation. I can also see if the Item is already on a PO.  Unfortunately this screen does not tell me which PO’s the item is on.  The Inventory Allocation Details screen will tell me PO’s the order is on.  

The goal here is that when orders come in a quick way to analyze if we have the part in stock.  If we dont what is the ETA.

Are there other end points besides stockitem that will get me more of this information for an inventory item?  

Best answer by Dmitrii Naumov

There are the following endpoints also available:

  • StorageDetailsInquiry
  • StorageDetailsByLocationInquiry
  • InventorySummaryInquiry
  • InventoryAllocationInquiry

 

5 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • Answer
  • November 5, 2024

There are the following endpoints also available:

  • StorageDetailsInquiry
  • StorageDetailsByLocationInquiry
  • InventorySummaryInquiry
  • InventoryAllocationInquiry

 


  • Author
  • Freshman I
  • November 5, 2024

There are the following endpoints also available:

  • StorageDetailsInquiry
  • StorageDetailsByLocationInquiry
  • InventorySummaryInquiry
  • InventoryAllocationInquiry

 

 

You just saved me a lot of time.  Thank you! 

 

In the results returned I get this which is almost enough as it gives me the allocation date so I can estimate the arrival of the shipment.  From here how would I get the actual PO number for my reference? 

 

{

"id": "45081774-a4de-4427-887b-d8fbf82001d9",

"rowNumber": 1,

"note": null,

"AllocationDate": {

"value": "2024-08-21T00:00:00+00:00"

},

"AllocationType": {

"value": "PO Order"

},

"DocType": {

"value": "Purchase Order"

},

"Location": {},

"Module": {

"value": "PO"

},

"Qty": {

"value": 5.000000

},

"custom": {}

},


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • November 5, 2024

@ExcelPerf unfortunately the RefNbr field is not a part of the InventoryAllocationInquiry endpoint.

You can extend that endpoint and add the field. I think that’s the easiest way to do it. 


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • November 5, 2024

@ExcelPerf actually, you can request it via a custom field parameter:

E.g.

{{sitename}}/entity/Default/22.200.001/InventoryAllocationInquiry?$expand=Results&$custom=Results/ResultRecords.RefNbr

 


  • Author
  • Freshman I
  • November 5, 2024

@ExcelPerf actually, you can request it via a custom field parameter:

E.g.

{{sitename}}/entity/Default/22.200.001/InventoryAllocationInquiry?$expand=Results&$custom=Results/ResultRecords.RefNbr

 

Where can I send payment :).  Thank you so much