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

Block Item per Location

(7) Share

Report

Posted on by LS-29041148-0

199

Hi All,

Please assist, Is it possible to block items per location for transactions, I have tried the security filter on permissions set but it does not allow.

This would be if I want to sell or buy an item in certain locations and not the other.

Regards

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

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

Like (3)

Report

Hello,

Unfortunately, this is not available even with Stockkeeping Unit. You will have to customize this.

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (3)

Report

As mentioned, this would be a customization to the Stockkeeping Unit. The logic would be pretty easy on this.

Best Regards,

Ben Baxter

Accent Software Inc

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 10,079 on at

Like (2)

Report
As mentioned, Customisation is the way to completely achieve this and below are workarounds but not a complete fit.

1. Use Inventory Posting Setup as a Control Mechanism

If a location is not configured in the Inventory Posting Setup, users will receive an error when trying to post transactions.

This acts as a soft block, preventing transactions from being posted for that location.

2. Use Warehouse Employee Setup

Assign users only to specific locations via Warehouse Employees.

Users will be restricted from performing warehouse activities in locations they’re not assigned to.

This doesn’t block item selection but prevents operational posting.

Mark the Boolean true “Does this answer your Question” if this is Helpful.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (4)

Report

Go for the SKU quick customization.

Trigger the code on OnValidate Item as well as location.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Hi, hope the following can give you some hints as well.

Dynamics 365 Business Central: How to block/disable locations (Four ways)
https://yzhums.com/28256/

Thanks.

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
LS-29041148-0 199 on at

Like (3)

Report

@RockwithNav Please assist by elaborating further this might be helpful

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

Business Central doesn’t have a standard way to block an item by location. The “Blocked” field works at item level only. To control this per location you’d need either:

A customization/extension (common approach), or

Use item variants or separate item numbers per location and block them individually.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

tableextension 50100 SalesLineExt extends "Sales Line"

{

trigger OnValidate()

begin

if "Location Code" <> '' then begin

if IsBlockedItemLocation("No.", "Location Code") then

Error('Item %1 is blocked for Location %2.', "No.", "Location Code");

end;

end;

local procedure IsBlockedItemLocation(ItemNo: Code[20]; LocationCode: Code[10]): Boolean

var

BlockedItemLoc: Record "Blocked Item Location"; // Create a custom setup table with Item No. + Location Code

begin

exit(BlockedItemLoc.Get(ItemNo, LocationCode));

end;

}

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Standard BC cannot block an item per location — you need customization for that.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (1)

Report
Hi,

BC doesn’t offer a native “block item per location” toggle, which makes this kind of control tricky to implement without customization. Security filters on permission sets won’t work here because they don’t evaluate location context dynamically during transactions.

Here’s how to approach it:

Option 1: Inventory Posting Setup as a Gatekeeper

Remove the Inventory Posting Setup for the item-location combination you want to block.

When users attempt to post transactions for that location, they’ll receive an error: “Inventory Account is missing in Inventory Posting Setup.”

This is a clean workaround that doesn’t require code, but it only blocks posting, not selection or visibility.

Option 2: Warehouse Employee Restrictions

Use the Warehouse Employee Setup to assign users to specific locations.

BC filters warehouse activities based on the user’s assigned location.

This doesn’t block item selection in documents but prevents warehouse actions like shipments or picks from unauthorized locations.

Option 3: Customization via AL Code

Add logic to the OnValidate trigger of the Location Code or Item No. fields in sales and purchase documents.

Example: If Location Code = 'X' and Item No. = 'Y', then raise an error.

This gives you full control and can be extended to journals, transfer orders, or service documents.

Option 4: Responsibility Centers

Assign users to Responsibility Centers and link them to allowed locations.

Use filters or custom logic to restrict transactions based on the user’s assigned center.

This is more scalable for multi-branch setups.

Helpful Reference
How to block items or item variants – Microsoft Learn
How to block/disable locations – Dynamics 365 Lab
Access Restriction of Location Items – Dynamics Community
Warehouse Employee Setup – Microsoft Learn
Inventory Posting Setup – Microsoft Learn

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

1 people found this reply helpful.

Was this reply helpful? Yes No