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

Hiding items from Stockkeeping Units

(4) 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

All responses (5)

Answers (0)

Suggested answer

Suresh Kulla 47,787 on at

Like (1)

Report
Hiding items from Stockkeeping Units

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."))); } } }
Gerardo Rentería Ga... 18,726 Most Valuable Professional on at

Like (0)

Report

Hiding items from Stockkeeping Units

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
Suggested answer

YUN ZHU 82,915 Super User 2025 Season 1 on at

Like (0)

Report

Hiding items from Stockkeeping Units

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
Suggested answer

Khushbu Rajvi. 16,335 Super User 2025 Season 1 on at

Like (1)

Report

Hiding items from Stockkeeping Units

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
Suggested answer

Jainam M. Kothari 7,933 on at

Like (2)

Report

Hiding items from Stockkeeping Units

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