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

Availability by Location for all items on Released Production Orders

(1) Share

Report

Posted on by October Sky

242

Hello

Is there an ability to view Availability by Location for all items on Released Production Orders. While it can be done individually by going into the Line fasttab and then item by BoM and then by location but this only does it item by item. I would like to have a view for the whole production order. The materials requisition report or shortage report doesn't fit the requirement either.

If there is such a report available, does it contain Bin code or would such a report need to be developed in PowerBi or customised?

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Suggested answer

Khushbu Rajvi. 8,151 Super User 2025 Season 1 on at

Like (1)

Report

Availability by Location for all items on Released Production Orders

Hope this helps as well: https://learn.microsoft.com/en-us/dynamics365/business-central/production-reports

If nothing work then you can consider customization.
Suggested answer

YUN ZHU 77,254 Super User 2025 Season 1 on at

Like (0)

Report

Availability by Location for all items on Released Production Orders

If the functions proposed by Valentin cannot meet the needs, I think customization is the only way to do it.

For example, create a list page, show the value of Items by location when it is opened, but the filter for items on Production Order is added by default.

Hope this can give you some hints as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 25,794 Super User 2025 Season 1 on at

Like (0)

Report

Availability by Location for all items on Released Production Orders

You can use the Shortage List report. For example:

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

Like (0)

Report

Availability by Location for all items on Released Production Orders

Thanks guys

I was aware of Items by location but it does not allow you to filter by Released Production order number so it was not useful for me. Even with co-pilot, it will not cross join to another table to perform a filter no matter how good the syntax of the prompt is.
Suggested answer

PRao 142 on at

Like (0)

Report

Availability by Location for all items on Released Production Orders

Hi,

I believe you can get the details based on Copilot based report "Enter Analysis mode". Refer the below screenshot.
You may also extract the data in Excel or prepared the pivot report based on your requirement.

I hope this will be helpful for you and fulfil your requirement.

Regards,
PRao
Suggested answer

YUN ZHU 77,254 Super User 2025 Season 1 on at

Like (0)

Report

Availability by Location for all items on Released Production Orders

Hi, The data can be found in the standard Query below. I think you can customize a Factbox to display the data more simply.

Hope this can give you some hints.

Thanks.

ZHU