web
You’re offline. This is a read only version of the page.
close
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 587

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

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,708 Moderator on at

    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.

  • Suggested answer
    pankaj.k Profile Picture
    994 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans