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

All responses (5)

Answers (0)

Suggested answer

Valentin Castravet 27,891 Super User 2025 Season 1 on at

Like (1)

Report

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

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/
Suggested answer

Khushbu Rajvi. 14,928 Super User 2025 Season 1 on at

Like (1)

Report

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

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".
Suggested answer

Jainam M. Kothari 6,567 on at

Like (1)

Report

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

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

YUN ZHU 81,794 Super User 2025 Season 1 on at

Like (1)

Report

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

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

Hope this can give you some hints.

Thanks.

ZHU
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (1)

Report

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

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