Small and medium business | Business Central, N...

How to Get Projected Available Balance by Item No. and Location Code

(4) Share

Report

Posted on by CU01100812-0

Hi,

I am working on retrieving the Projected Available Balance (PAB) for an item from the "Item Availability by Location" page in Dynamics 365 Business Central.

I have both: Item No & Location Code

My requirement is to get the Projected Available Balance based on these two parameters. Could you please guide me on the correct way to query or access this information programmatically?

Specifically, I would like to know:

Is there a standard table or method I can use to retrieve the PAB for a given Item No. and Location Code?
If not directly available via an API or standard table, is there any recommended approach (e.g., using the Item Availability Buffer or Item Ledger Entry) to calculate the PAB manually?

Any insights or examples you could share would be greatly appreciated.

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (1)

Report

Moved the question from the Dynamics 365 General to the Business Central forum.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Hi, you can write one yourself by referring to the calculation of the standard code.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-availability-overview

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,363 Super User 2025 Season 2 on at

Like (1)

Report

In Dynamics 365 Business Central, the Projected Available Balance (PAB) is not stored in any single table. It's calculated on the fly using inventory data and expected supply/demand. Microsoft uses codeunit to do this calculation behind pages like "Item Availability by Location".

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (1)

Report

As Yun Zhu mentioned you need to calculate this value as its not stored by the system anywhere.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No