Get filed Address form table Vendor

vnproc

Dear EveryBody

I'm sorry, my english is not very good.

When I create one report Purchase Order, problem in here I can't insert field Address form table Purchase Header. I know it relation table Vendor.

Everybody can help code to obtain field Vendor.Address insert in report.

Thanks so much.

mohana_cse06

You can write below code in Purchase Order - OnAfterGetRecord trigger

txtVendname := '';
if recVendor.GET("Buy-from Vendor No.") then
txtVendname:=recvendor.name;

Where recVendor is record type variable of Vendor table
txtVendname is text type variable of length 50

Add txtVendname in SourceExpr property of the text box in report

vnproc

mohana_cse06 wrote:

You can write below code in Purchase Order - OnAfterGetRecord trigger

txtVendname := '';
if recVendor.GET("Buy-from Vendor No.") then
txtVendname:=recvendor.name;

Where recVendor is record type variable of Vendor table
txtVendname is text type variable of length 50

Add txtVendname in SourceExpr property of the text box in report

Thanks mohana_cse06 very much.