Skip to Content
0
Former Member
Apr 28, 2009 at 05:27 AM

Query to Lookup Ship To in a UDF for the Inventory Transfer

30 Views

Good Day Experts!

I created a UDF for the Ship To Code in the Inventory Transfer Window. The problem is I do not know how to create a query to be used in the Formatted Search for this UDF wherein it will lookup all the Ship To Codes in the table CRD1 of that particular Customer selected in the Inventory Transfer window. The objective is to choose a Ship to code just like in the sales document.

My next problem would be how to display automatically the whole Ship To Address in another UDF based on the Ship To Code chosen in the UDF Ship To Code.

Your inputs would be highly appreciated.

Regards,

Jen