web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

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... / "Sales Blocked" items...
Small and medium business | Business Central, N...
Suggested Answer

"Sales Blocked" items are now listed in dropdown list of items in a sales line (BC27)

(10) ShareShare
ReportReport
Posted on by Maria Sa 140
Hi,
After update to V27, we noticed BC is now including in the dropdown list of items, items that are blocked for sales and purchase. In the previous versions these items didn't appear on this list, and this made sense because if user selects an item that is blocked for sales, user gets an error.
 
Example:
 
This item appears now in this dropdown and it shouldn't. 
 
 
Anyone with same situation?
 
Should I take this as a bug of this V 27? 
 
Maria
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 5,338 Super User 2026 Season 1 on at
     
    Initally i blocked item , it allowed me to select the blocked item . at the next instance i closed the environment and tried to select the item it gave me error
     
     
    Can you re-try the same . Its refresh issue . Validation is working fine in Envirionment 27
     
    Warm Regards
    Pallavi Phade 
     
     
     
     
     
  • Maria Sa Profile Picture
    Maria Sa 140 on at
    Hi, 
     
    I know that if I select the item that is blocked, BC retrieves an error to not let user to proceed. 
    The issue is that the Item should not be listed to be selected by the user. 
    In previous versions (before V27) the items blocked for sales didn't appear in the dropdown list, and now they appear. This is the issue.
     
    Maria
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 15,668 Super User 2026 Season 1 on at
    Hello,
     
    After upgrading to Business Central v27, items marked as blocked for sales or purchase now appear in dropdown lists, even though selecting them still triggers an error.
     
    This behavior differs from previous versions and seems to be a regression or bug, as blocked items should normally be excluded except for returns or credit memos.
     
    The recommended action is to check v27 release notes, report the issue to Microsoft, and consider a temporary customization to filter blocked items from lookups.
     
     
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,612 Super User 2026 Season 1 on at
    Hello,
     
    Yes, you are right. In v27, Sales Blocked items will be visible on the drop down selection.
    I am not sure if this was intended, but the filtering was indeed removed.
     
    this is the code in table 37 "Sales Line" in v27.
    field(6; "No."; Code[20])
{
  ...
  if (Type = const(Item)) Item;
  ...
}
     
    whereas the version before is
    field(6; "No."; Code[20])
{
  ...
  if (Type = const(Item), "Document Type" = filter("Credit Memo" | "Return Order")) Item where(Blocked = const(false));
  ...
}
     
     
     
  • Suggested answer
    Aman Kakkar Profile Picture
    Aman Kakkar 2,977 Super User 2026 Season 1 on at
    Hi,
     
    Agreed with @Yi Yong, the standard code has been changed in version 27, you can refer the below screenshots -
     
    Before version 27, there was a filter for Blocked = false, and "Sales Blocked" = false
     
     
    But after version 27 was released, this filter has now been removed -
     
     
    Do mark as verified if this helps.
    Aman K
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,242 Super User 2026 Season 1 on at
    It might be related to a feature update for the sales order agent; I'm not entirely sure. But I think it's worth submitting to Microsoft.
     
    Thanks.
    ZHU
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 11,392 Super User 2026 Season 1 on at
    Hello,
     
    Blocked items now show up in the lookup list, even though selecting them still gives an error.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    Rishabh Kanaskar 6,215 Super User 2026 Season 1 on at
    Hi, 
     
    This change is due to updates in lookup behavior introduced in v27. Previously, filters excluded items blocked for sales from dropdown lists. In v27, the standard lookup no longer applies that filter automatically, blocked items are still selectable but will trigger an error on validation.
    This seems like a design change, not a bug.
     
    Thanks
    Rishabh
  • CK-13021646-0 Profile Picture
    CK-13021646-0 26 on at
    Hi everyone,
     
    did Microsoft mention in the meanwhile, if this is a bug/programming mistake or a design change? I cannot believe that this behaviour could be intended, this would be a horrible UX downgrade.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,242 Super User 2026 Season 1 on at
    You can submit new issue here.
     
    Thanks.
    ZHU

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans