web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to get all the rec...

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) Share

Report

Report

Posted on by Tamilarasu Arunachalam

593

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.

Any help would be much appreciated

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

pankaj.k 1,020 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,872 Super User 2026 Season 1

#2

YUN ZHU 1,110 Super User 2026 Season 1

#3

AndrewThomas81 892

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans