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

554

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

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

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

PRao 394 on at

Like (0)

Report

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

Was this reply helpful? Yes No
October Sky 554 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

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

If nothing work then you can consider customization.

Was this reply helpful? Yes No