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

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

(8) Share

Report

Posted on by Maria Sa

113

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)

All responses (8)

Answers (0)

Suggested answer

Pallavi Phade 3,834 on at

Like (3)

Report

Namaste @MS-03092100-0

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

Was this reply helpful? Yes No
Maria Sa 113 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

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.

https://yzhums.com/18968/

https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-block-items

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,555 Super User 2025 Season 2 on at

Like (3)

Report
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)); ... }

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 2,319 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,449 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 5,798 on at

Like (2)

Report

Hello,

Blocked items now show up in the lookup list, even though selecting them still gives an error.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,148 on at

Like (2)

Report

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

Was this reply helpful? Yes No