Combo Box with a dynamic list of values (in this example warehouses) based on the customer
Option 1: with the same list of warehouses for all customers
Option 2: display specific warehouses relevant by AccountID
To implement same list of warehouses for all Accounts:
- Create and load a User defined table like this:
Note the MainKey is empty (this is the whole catch! (Don't put the warehouse names in the main key). The Values are the WH code.
MapDataExternalID,MainKey,SecondaryKey,Values
CityWarehouseList,,Raanana,01
CityWarehouseList,,Tel Aviv,02
CityWarehouseList,,General Warehouse,03
CityWarehouseList,,Eilat,04
CityWarehouseList,,Zfat,05
CityWarehouseList,,Dimona,06
- Create a custom field of type “User Defined Tables Dropdown”
Main Key = None
Add this field to the order header, and the list of all warehouses will display in the drop down.
- Create another custom field of type Number from UDT (select it on top button).
The User defined table object is the table you loaded above, main key=none, secondary key = the TSA you created above. Get Data from column = 0
Add to Order Header
The code for the selected warehouse from the combo box will appear in this number custom field.
To implement it with different list of warehouses depending on AccountID:
Same as above, but the UDT looks like this with Mainkey = AccountID
MapDataExternalID,MainKey,SecondaryKey,Values
CityWarehouseListbyAccount,509,Raanana,01
CityWarehouseListbyAccount,509,Eilat,04
CityWarehouseListbyAccount,509,Tel Aviv,02
CityWarehouseListbyAccount,509,General Warehouse,03
CityWarehouseListbyAccount,510,Raanana,01
CityWarehouseListbyAccount,510,Eilat,04
CityWarehouseListbyAccount,510,Tel Aviv,02
CityWarehouseListbyAccount,510,Pardes Chana,05
0 comments
Please sign in to leave a comment.