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

Remove "Blank" Location Code from Physical Inventory Reports

(5) Share

Report

Posted on by AXEON Man

1,063

In Inventory Setup, I've got location required set.

When I run a Physical Inventory Journal, I still get duplicates of everything in a blank location code -even though the count is zero.

Am I doomed to filtering this out forever or can I eliminate it?

Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

This usually happens when some items have no transactions or bin content assigned to any location. To avoid “blank” location lines in the Physical Inventory Journal:

Ensure all items have a default location code set in the Item Card.

Run the journal using the "Calculate Inventory" function and select “Include Items Without Transactions” = false.

Use filters to exclude blank locations, or customize the report to suppress them entirely.

If this remains a recurring issue, a minor customization can automate the exclusion. ✅

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
AXEON Man 1,063 on at

Like (1)

Report

There is no way as far as I can tell to set a default location on an item card.

Your reply is helpful but amounts to filtering which is what I was hoping to eliminate.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,907 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

The only way to eliminate them (instead of filtering) is to clean up your data so that no stock exists in a blank location for example, post item reclass journals to move any quantities from blank to valid locations, and ensure stockkeeping units (SKUs) are set up for all active items with the correct locations. Once there are no quantities in the blank location, the Physical Inventory Journal will no longer generate those extra lines.

Hope you can get some idea from this answer!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

AXEON Man 1,063 on at

Like (1)

Report

I like the idea but I already have no stock in the blank location and have no stock keeping units as we just have the "Main" location for now. I guess I'll just get used to filtering.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, hope the following helps.

Dynamics 365 Business Central: How to hide all comment lines in Standard Sales – Order Conf. (1305) report (Do not print comment lines) – Customization

https://yzhums.com/55285/

Dynamics 365 Business Central: Can we change default options/filters on the request page of Report???

https://yzhums.com/40072/

Thanks.

ZHU

Was this reply helpful? Yes No