Hi ​@Namrata13 ,

• Use the Inventory Summary screen (IN401000) via the REST API.
• Create a custom endpoint or extend an existing one.
• Add the InventorySummary entity to the endpoint and include the required grid fields (like InventoryID, Warehouse, QtyOnHand, Available Qty, etc.) under the Details section.
• Use the PUT method with appropriate filters (like InventoryID) in the request body to get real-time changes.
   

  

   

  

   

Hello ​@jinin ,

Thank you for your reply. I already checked and tried inventory summary entity. But the problem is that here it is asking for InventoryID. But I need the entity where only I can pass LastModifiedDate filter I don’t want to pass InventoryID. And without InventoryID it is not giving me the result. 

Hope you get my point. 

Help me on this.

Thank you

Hi ​@Namrata13 ,

Since the information can't be retrieved directly, you'll need to create a custom Generic Inquiry (GI) using the INSiteStatusByCostCenter table. Apply a filter on the Last Modified DateTime field, and then create an endpoint entity based on that GI. Please give this approach a try.

​@Namrata13 you can get ‘storage details’ inquiry via OData to get this data.

E.g.

{{sitename}}/t/Company/api/odata/gi/DB-StorageDetails?$filter= LastModifiedDateofWarehouseQty ge 2024-01-01

 (example for 2025r1 Acumatica version)

Hello,

Thank you for both response ​@jinin and ​@Dmitrii Naumov .

​@jinin regarding creating Generic inquiry, I never created before. So, I need to do some RNDs on that. If you can suggest any tutorial regrding this..

​@Dmitrii Naumov, Will try your approach and let you know whether its working or not. 

​@Dmitrii Naumov I tried with odata concept but it is giving me unauthorized error. I want to ask I am using oauth in rest api but same token not working for odata.

Can you please guide me on that?

Thank you

​@Namrata13 the same token should be good for OData too. 

What version of Acumatica do you have? 

Reference:

How to Access Data Efficiently Using Contract-Based APIs

Hello ​@Dmitrii Naumov ,

I dont know which version I am using. I have shared url which I am trying

https://staniosindustrial.acumatica.com/t/Staging/api/odata/gi/DB-StorageDetails?$filter=LastModifiedDateofWarehouseQty ge 2024-01-01

this is staging acumatica in which I am testing. and also shared postman where I am getting unauth error

Hi @Namrata13,

As suggested by @jinin, we can retrieve a list of items using a date filter.

Please find below the steps to achieve this using a Generic Inquiry:

you can access GI using Endpoint as below,

http://localhost/ACV24R1241120026/entity/EndpointName/20.200.001/InventoryLastModified?$expand=InventoryLastModifiedDetails

Request:

{  

    "Date": {

        "value": "2024-02-15T18:25:43.511Z"

    }

}

Steps:

1. Import the Generic Inquiry.

2. Create an Endpoint for it.

3. Pass the date parameter in the request.

Hope above helps!!

Hi @Namrata13,

As suggested by @jinin, we can retrieve a list of items using a date filter.

attached generic inquiry for your reference

Please find below the steps to achieve this using a Generic Inquiry:

Steps:

1. Import the Generic Inquiry.

2. Create an Endpoint for it.

3. Pass the date parameter in the request.

Hope above helps!!

Hello ​@Rakshanda ,

Thank you for your response. Will try that Generic Endpoint and let you know if it is working or not

​@Namrata13 You are on 24r1 version. 

In this version you can use the following URL instead

https://staniosindustrial.acumatica.com/odata/Company/DB-StorageDetails?$filter=LastModifiedDateofWarehouseQty ge 2024-01-01

​@Dmitrii Naumov Thank you. 

The URL you shared is working perfectly—thank you for that! I do have a few questions for clarification:

1. Will the same URL structure work for other Acumatica customers, or can it vary based on their environment or configuration or version?

2. If any inventory-related transaction occurs—such as sales order creation, purchase receipt, item receipt, item issue, etc.—will the /DB-StorageDetails OData endpoint reflect the updated inventory accordingly?

3. How can I retrieve the company name using the API?

I hope my questions are clear.
Thank you again for your support!

​@Namrata13 

1. It should work for all currently supported Acumatica versions and configurations. For 2026 version it’ll probably need to be changed to the one I’ve provided first here

   ​@Namrata13 you can get ‘storage details’ inquiry via OData to get this data.

   E.g.

   {{sitename}}/t/Company/api/odata/gi/DB-StorageDetails?$filter= LastModifiedDateofWarehouseQty ge 2024-01-01

    

    (example for 2025r1 Acumatica version)

    

2. Yes, correct.
3. I don’t think there is a good way to do it. You should consider the company name a part of credentials and have a setting for that along with site URL