Restricting Subinventory LOV

August 31, 2016 - 1 minute read

In this series of MWA Express Server blog, we will see how to change or restrict the values of an LOV field in any mobile transaction. To illustrate, we are going to look at a specific use case – we will restrict the values of destination subinventory LOV based on the source subinventory in the Subinventory Transfer page.

This may be useful if a warehouse only allows specific path of material movement, e.g. BULK to CASE and EACH is allowed, CASE to EACH is allowed, but EACH to BULK and CASE is not allowed, and so on. Ideally, this personalization will be setup at organization level as each warehouse has its own rules of material movement.

mwaex_poreceipt1

The personalization property we will use is Validate property. This property is used to store a SQL statement that will be executed after user entry. If the SQL returns at least a row, validation passes. Otherwise, validation fails and cursor stays in the field.

This screenshot shows the personalized page where source subinventory is BULK and destination subinventory are CASE and EACH only.

mwaex_poreceipt2

0 Comments
Join the conversation

Your email address will not be published. Required fields are marked *

Leave a Reply