Automatic Display Purchase Order list

[Former Member]

Dear All ,

One of my customer create two UDF In Goods Issue VENDOR NAME and Work Order No. he want to when he select perticular vendore in UDF VENDOR NAME and in second UDF Work Order No automatic display Purchase Order only UDF VENDOR NAME .

Any assistance would be deeply appreciated. Thanks.

regards

nitin

[former_member689126 · Accepted solution]

Hi

Create 2 formatted searches first to list all vendors

select CardCode,CardFName  from OCRD where CardType='S'

second formatted search for displaying all the purchase orders for the selected vendor

select CardCode,DocEntry ,DocNum,DocDate   from OPOR where CardCode =$[OIGE.U_VndrCode]

(here U_VndrCode is the vendor code UDF)

Hope this helps

Regards

Arun