Skip to main content
Solved

Requesting Inventory Balance Report Data via Webservice Endpoint

  • Feb 8, 2023 2:32 PM UTC
  • 5 replies
  • 254 views
  • Translate All

Hello All!

I was looking to collect the content from page IN615000 via a REST Api call.

In the past, i had extended the webservice endpoints list to make a new route, and add the screen ID of choice to collect the information typically returned there.

This time however, when clicking “Okay” to produce the route - I get the error : 

Error: The view  doesn't exist.

Has anyone else successfully asked for the data on this page?

Cheers, 

Chris

Best answer by Dmitrii Naumov

@ChrisHaddy InventoryAllocationInquiry does not really have a ItemClass parameter. 

The only way you can request it is by using InventoryID parameter. 

 

However, what is your requirement exactly? There are other inquiries that may be a better fit for you, e.g. StorageDetailsInquiry

View original

5 replies

Dmitrii Naumov
Community Manager
Forum|alt.badge.img+7

Reposts are currently not supported in REST API

Translate

  • Author
  • Freshman I
  • Feb 8, 2023 3:47 PM UTC

Hey Dmitri,

thanks for your response!

As an alternative, i am attempting to invoke:

InventoryAllocationInquiry?$expand=Results

But using a the PUT parameter

of 
 

{
"InventoryID": {
"value": "12345"
}
}


{
"ItemClass": {
"value": "ABC"
}
}

I can get the results to return for one inventory item with the top block. Would i be able to return an array of results with the second? So far It returns- but the results are essentially all 0’s

Thanks for answering!

Chris

Translate

Dmitrii Naumov
Community Manager
Forum|alt.badge.img+7
  • Community Manager
  • Answer
  • Feb 8, 2023 4:00 PM UTC

@ChrisHaddy InventoryAllocationInquiry does not really have a ItemClass parameter. 

The only way you can request it is by using InventoryID parameter. 

 

However, what is your requirement exactly? There are other inquiries that may be a better fit for you, e.g. StorageDetailsInquiry

Translate

  • Author
  • Freshman I
  • Feb 8, 2023 4:12 PM UTC

Hey Dmitri,

I had added the ItemClass parameter to the response of the /InventoryAllocationInquiry and it was returning the correct entry, but you are correct, i cannot query with any parameter other than InventoryID.

I was hoping to return the totals of all inventory onHand, available, notAvailable for all inventory id’s with the same itemClass and place it within a table, much like the IN615000’s Inventory Report.

I have been using the Web Service Endpoints to retrieve all of my information at this time.

We had been extending endpoint 18.000.000 etc for our work, but i see the StorageDetailsInquiry on route 20.200.001

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Mar 20, 2023 8:12 PM UTC

Hi @ChrisHaddy  were you able to find a solution? Thank you!

Translate