Scenario:
The user wanted to restrict showroom inventory staff so they could only create or update transactions using designated showroom locations and prevent them from selecting the Main Warehouse location. However, users still needed the ability to reference the Main Warehouse when creating Transfer Order Requests for inventory transfers to showroom locations.
Solution:
One effective approach is to use a combination of custom transaction forms and workflows to control location access and transaction behavior.
Recommended setup:
- Create custom transaction forms for the affected transaction types, such as:
- Item Receipts
- Item Fulfillments
- Transfer Orders
- Restrict the custom forms to the appropriate user roles or employees.
- Use a workflow to:
- Automatically populate the allowed showroom location in the transaction
- Lock or restrict editing of the Location field
- Prevent users from selecting unauthorized locations such as the Main Warehouse
- Configure exceptions for Transfer Order Requests:
- Allow the Main Warehouse location only for Transfer Order transactions
- Restrict other transaction types to showroom-only locations
Important considerations:
- This approach works best when transactions use main line location fields
- Line-level location restrictions can become more complex due to sublist action limitations within workflows
- Additional scripting may be required for more advanced multi-location or line-level restriction scenarios
Using custom forms combined with workflow logic provides a flexible way to enforce location-specific transaction access while still allowing controlled warehouse transfer processes.