Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

How to get all the records from the Item Availability by locations page as an API

(0) ShareShare
ReportReport
Posted on by 560

I have to get the records from the page Items by Location Matrix (9231, ListPart) as an API Page or What is the filter for getting the items quantity by location in API request. I have to update the data using that API page.

pastedimage1671176590257v1.png

Any help would be much appreciated

  • Suggested answer
    pankaj.k Profile Picture
    976 on at
    RE: How to get all the records from the Item Availability by locations page as an API

    Hi Tamilarasu Arunachalam,

    Item By Location Wise page is based on Matrices calculation and all the data is calculated form Item Ledger Entry Table.

    you need to do customization for gating data by item location wise.

  • Suggested answer
    Nitin Verma Profile Picture
    21,569 Moderator on at
    RE: How to get all the records from the Item Availability by locations page as an API

    Hi,

    Item by location is a matrix page, and its made of Item and Item Ledger entry combination, so you can expose your API page based on Item Ledger Entry.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans