Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Remove "Blank" Locatio...
Small and medium business | Business Central, N...
Suggested answer

Remove "Blank" Location Code from Physical Inventory Reports

(2) ShareShare
ReportReport
Posted on by AXEON Man 738
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
  • Suggested answer
    Mansi Soni Profile Picture
    Mansi Soni 7,736 Super User 2025 Season 2 on at
    Remove "Blank" Location Code from Physical Inventory Reports
    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

  • AXEON Man Profile Picture
    AXEON Man 738 on at
    Remove "Blank" Location Code from Physical Inventory Reports
    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.
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 8,100 Super User 2025 Season 2 on at
    Remove "Blank" Location Code from Physical Inventory Reports
    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.
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

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

#1
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 3,878

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 3,583 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 3,175 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans