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

Remove "Blank" Location Code from Physical Inventory Reports

(5) Share

Report

Posted on by AXEON Man

1,159

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)

Sort by

Suggested answer

Sohail Ahmed 11,173 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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,159 on at

Like (1)

Report
Copy link

Link copied!

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

Like (3)

Report
Copy link

Link copied!

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,159 on at

Like (1)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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