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)

Sort by

André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,974 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 16,520 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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. 22,424 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 32,689 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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