web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

List Page values

(0) ShareShare
ReportReport
Posted on by

Hi,

I want to create a page that is almost identical to page 20 - General Ledger Entries. 

So I set the source table to 17 - G/L Entry.

I also want to display 4 values that are stored in the Purch. Inv. Header table 122.

How do I display these values on the page if they are coming from a table that is not the source table?

Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    50,080 Super User 2025 Season 2 on at
    RE: List Page values

    Patrick,

    Please send the full code, in the OnAfterGetRecord first you need to find/GET the Purch Inv. Header Record then you assing the values to the variables.

    Something like this

    CLEAR(InvHeader);

    CLEAR(VendorNo);

    IF InvHeader.GET("Document No.") THEN BEGIN

     VendorNo := InvHeader."Buy-from Vendor No.";

    END;

  • Community Member Profile Picture
    on at
    RE: List Page values

    Hi Mohana,

    thanks for your help.

    I've done everything you've said and this is the code I have in the OnAfterGetRecord trigger for one of the variables - VendorNo := InvHeader."Buy-from Vendor No.";.

    Unfortunately this value still does not appear on my page, even though I have the variable in the source expression. Any ideas?

    Thanks,

    Patrick

  • Suggested answer
    Mohana Yadav Profile Picture
    60,939 Super User 2025 Season 2 on at
    RE: List Page values

    the new page which you are creating..

  • Community Member Profile Picture
    on at
    RE: List Page values

    H

  • Community Member Profile Picture
    on at
    RE: List Page values

    Hi Mohana,

    Do I declare these global variables in the new page or in table 122?

  • Mohana Yadav Profile Picture
    60,939 Super User 2025 Season 2 on at
    RE: List Page values

    you need to declare global variables same as field types in table 122

    you need to calculate/get those 4 field values in OnAfterGetRecord trigger of page with link between table 17 and 122 and show those 4 gloval variables in page sourcexpression

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans