Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Inventory calculation - Avoid certain location

Posted on by 20
Hello,

I have different locations setup, including one as my Quality Management.
 
This stock is pending various information (or sent for scrap), therefore not available for production.
 
However, this is taken into consideration when having my calculation (shown below - green one is my real stock - pink one is blocked stock and should not appear)
 
 
Could anyone help me with that ?
 
Thanks a lot in advance.
 
Laszlo
Categories:
  • LaciM Profile Picture
    LaciM 20 on at
    Inventory calculation - Avoid certain location
    Hello,
     
    In a way it does, thanks !
     
    However, I need to have it done for the Planning Worksheet / MRP to have the calculation right.
     
    I tried using the same technique, and it does not seem to have an impact.
     
     
    I also tried to filter at Item level
     
     
    I hope you can help me on that, and wish you a nice day !
     
    Laszlo
  • Suggested answer
    Shauna Langley Profile Picture
    Shauna Langley 612 Super User 2024 Season 2 on at
    Inventory calculation - Avoid certain location
    Hi,
     
    You should be able to use the location filter to exclude this.  See example below.
     
     
     
    If I enter a filter as follows then the EAST location will be removed.
     
     
    Hope that helps,
    Shauna

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans