Restrict Item Groups per Warehouse

ERPNext Stock/Inventory
, , , ,
1

Hello Frappe Community :waving_hand:,

I would like to share an app that I am currently building and get your feedback before publishing it on the Frappe Marketplace.

:magnifying_glass_tilted_left: The Problem

In ERPNext today:

  • Item Groups are used only for classification

  • Warehouses are independent storage locations

  • There is no native way to enforce business rules such as:

    “Only certain Item Groups are allowed in specific Warehouses”

This often leads to:

  • Wrong stock placement

  • Operational mistakes

  • Heavy dependence on user discipline

:light_bulb: The Solution (New App)

I am building a new app that introduces Warehouse-based Item Group control.

Core idea:

  • Define rules per Warehouse

  • Each rule specifies which Item Groups are allowed

  • Enforcement happens on stock-impacting transactions

Supported transactions (server-side enforcement):

  • Stock Entry

  • Purchase Receipt

  • Delivery Note

  • Sales Invoice (when Update Stock = 1)

  • Purchase Invoice (when Update Stock = 1)

  • Stock Reconciliation

Design principles:

  • No core overrides

  • No Stock Ledger manipulation

  • Upgrade-safe

  • Marketplace-ready

  • Multi-company aware

If a Warehouse has no rule → behavior remains unchanged (fully backward compatible).

:bullseye: Target Use Cases

  • Raw materials restricted to raw stores

  • Finished goods restricted to FG warehouses

  • Chemicals / hazardous items in controlled warehouses

  • Branch-specific warehouse policies

:rocket: Marketplace Plan

I plan to publish this app on the Frappe Marketplace once:

  • The core logic is stable

  • Community feedback is incorporated

  • Edge cases are reviewed

That’s why I’m posting here first :raising_hands:

:speech_balloon: Feedback Requested

I would really appreciate your thoughts on:

  • The overall idea

  • Missing edge cases

  • Similar solutions you’ve seen (if any)

  • Features you’d expect in v1 vs future versions

:telephone_receiver: Contact

If you prefer a quick discussion, you can also reach me on WhatsApp:
:backhand_index_pointing_right: Share on WhatsApp

(Feedback here on the forum is preferred so everyone can benefit.)

Thanks in advance :folded_hands:
Looking forward to your input.

— Ahmed Yousef

1 Like
2

1-Define Role per Warehouse.

image
image1752Ă—840 55.1 KB

2-Error Message.

image
image1792Ă—476 61.5 KB

3

new custom field “Enable Warehouse Item Group Rules” at doctype Stock settings.

image
image1712Ă—897 115 KB

4

(Official Release Announcement)

:tada: I’m happy to announce the official release of a new app on the Frappe Marketplace

After working closely with businesses managing warehouses and inventory,
I’m excited to introduce:

:small_blue_diamond: Warehouse Item Group Rules

:package: A common challenge
Many companies struggle with:

  • Raw materials stored in the wrong warehouses

  • Finished goods mixed with other inventory

  • Human errors caused by workload or manual checks

  • Time wasted fixing stock issues and audits

:red_circle: The result?
Confusing inventory data and operational inefficiencies.

:white_check_mark: How the app helps
Instead of relying on manual supervision, the system prevents mistakes:

  • Each warehouse accepts only the correct type of items

  • Incorrect stock entries are blocked instantly

  • Rules are enforced automatically for all users

:green_circle: The business impact

  • Clean and organized inventory

  • Fewer stock errors

  • Faster audits

  • Smoother daily operations

:pushpin: Now officially available on the Frappe Marketplace
:link: https://cloud.frappe.io/marketplace/apps/warehouse_item_group_rules

If your business manages warehouses, manufacturing, or distribution,
this app helps prevent inventory problems before they happen.

ERPNext frappe inventorymanagement #BusinessEfficiency

1 Like