Get filed Address form table Vendor

vnproc
vnproc Member Posts: 41
edited 2014-05-21 in NAV/Navision Classic Client
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.

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    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

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • vnproc
    vnproc Member Posts: 41
    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.

Categories