When creating a UDT and validating against it, it always lists all the records you can select from.
it would be great if we can filter these records by mapping them to the MAS200 tables.

For example, creating a UDT that holds a customer Carriers accounts, each customer may have multiple Carriers (hence the need for a UDT and not a UDF in the AR_Customer table)
you would load/enter multiple Carrier accounts for the same customer number.

When selecting which carrier the customer may want to use in S/O entry, you would be able to list only the carriers that belongs to that customer by mapping the customer division and number to similar fields in the UDT.

Take it one step forward and allow to edit records in that UDT also by filtering a specific customer but still allow to edit or remove.

by: Oren L. | over a year ago | General Enhancements