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

Item Availability Report by variant

(1) Share

Report

Posted on by giovanni79

211

Hi,

I am trying to run the Inventory Availability report, but I don't seem to find a way to specify the report by variant. Am I missing something? Is there any other report to have the item availability by variant by filtering for a specific location?

There is a checkmark to use stockkeeping units, but we don't use those, do we need to set those up by variant in order to have the report by variant as well?

Thanks,

Giovanni

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Umut Dogan Koc 87 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You can filter totals by desired variant(s) as you can see below image.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,710 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

You can also try the Availability by Variant Page here:

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

Like (1)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: How to quickly check inventory quantity for locations at Item-Variant level (Variant inventory per location)

https://yzhums.com/54104/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,533 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Adding more: https://community.dynamics.com/forums/thread/details/?threadid=0cec9634-2810-481e-862a-9a3a092ea155

https://www.dynamicsuser.net/t/inventory-by-variant-vs-location/66380

Was this reply helpful? Yes No
giovanni79 211 on at

Like (0)

Report
Copy link

Link copied!

Thank you Umut Dogan Koc,

This is not quite what I am looking for as basically all of our products have variants, and I need the details of each. Using a wild card (*) gives me the sum of all variants for each product, not the detail.

Was this reply helpful? Yes No
giovanni79 211 on at

Like (1)

Report
Copy link

Link copied!

Thank you Valentin Castravet,

This is what I do for one product at the time, but I need a report for all variants (we need to export that to Excel, change a few things, and share it with our customers). This only works for one product at the time.

Was this reply helpful? Yes No
giovanni79 211 on at

Like (0)

Report
Copy link

Link copied!

Thank youYUN ZHU,

Inventory Valuation seems to be what I am looking for, but it seems I see what you see for W1 (although I should be in FR). I will investigate more.

Was this reply helpful? Yes No
giovanni79 211 on at

Like (1)

Report
Copy link

Link copied!

Thank you Khushbu Rajvi.,

There is some useful information on your link: we might end up building a Power BI report so we can fully customize the export to our needs and export it automatically with Power Automate. Probably easier and more flexible than working with the provided reports.

Was this reply helpful? Yes No