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

Hiding items from Stockkeeping Units

(5) Share

Report

Posted on by PB-30041014-0

Hi, is there a way to default hide items from stockkeeping units that are blocked for purchase? I would've used filter, but that only works in Items tab, not Stockeeping Units.

Basic premise is, that we are using company account. Items - All items listed and worked in within enviroment. Stockkeeping units are specirically for my branch with location code and there's no filter option for Purchasing Blocked - TRUE to filter items. Therefore, when I am doing order through Planning Worksheets, I get errors every now and then and changing values for stockkeeping is pain. Any advice?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

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

Like (2)

Report

Hello,

In Business Central, to default hide items from stockkeeping units that are blocked for purchase, you can use a workaround since there's no direct filter option for this.

One approach is to create a custom view or report that excludes items marked as "Purchasing Blocked."

You can also consider using an extension or customization to add this filtering capability to the Stockkeeping Units page.

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

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,612 Super User 2025 Season 2 on at

Like (1)

Report

I am not sure if this helps or not please check this: https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-to-set-up-stockkeeping-units

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, hope the following can give you some hints.

Dynamics 365 Business Central: Can we extend TableRelation Property through a table extension??? (Yes, But…)

https://yzhums.com/26939/

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,365 Most Valuable Professional on at

Like (0)

Report

Hi, good day
I hope this can help you, and give you some hints.Managing Items different per Location or Variant using Stockkeeping Units (SKUs) - Dynamics 365 Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (1)

Report
You need a customization to add a flowfield to the lookup Item table for the blocked , something like below

tableextension 50100 "Stockkeeping Unit Extension" extends "Stockkeeping Unit" { fields { field(50100; "Purchasing Blocked"; Boolean) { Caption = 'Purchasing Blocked'; DataClassification = CustomerContent; FieldClass = FlowField; CalcFormula = Lookup(Item."Purchasing Blocked" WHERE (No.=FIELD("Item No."))); } } }

Was this reply helpful? Yes No