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

Remove "Blank" Location Code from Physical Inventory Reports

(5) Share

Report

Posted on by AXEON Man

1,144

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

Like
a
(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,144 on at

Like
a
(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 10,184 Super User 2026 Season 1 on at

Like
a
(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,144 on at

Like
a
(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 102,054 Super User 2026 Season 1 on at

Like
a
(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

Join the conversation

Community site session details

Remove "Blank" Location Code from Physical Inventory Reports

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Remove "Blank" Location Code from Physical Inventory Reports

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates