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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to Get Lookup tabl...
Small and medium business | Business Central, N...
Answered

How to Get Lookup table value in Business central

(0) ShareShare
ReportReport
Posted on by Inkey Solutions 2,122

Hi All,

Here I am talking about General Journals page of business central. you can see in the below screen print Shortcut Dimension 1 Code field is renamed by Property code.

and I need to get CorporateId value from this lookup as per selected Property-code by general journal line.

Is there any way to achieve lookup table column value?  using AL code.

 

pastedimage1671286638588v1.png

I have tried some code as you can see in the below screen print., but it didn't work for me.

pastedimage1671285944830v2.png

pastedimage1671285990422v3.png

Thank you.

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,423 Super User 2026 Season 1 on at

    hello

    why do you cycle the recGenjournal?

    you should loop the rec

    trigger OnAction()

    begin

     repeat

       CorporataId:=GetCorporateId();

       if Corporateid<>14 then

           message('Not 14');

     until rec.next:=0;

    end

    check my answer if it helped you, thanks

    DAniele

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 102,361 Super User 2026 Season 1 on at

    Hi, hope the followings can give you some new hints.

    https://yzhums.com/22220/

    https://yzhums.com/5985/

    https://yzhums.com/27561/

    Thanks.

    ZHU

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 649 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans