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

Notifications

Announcements

No record found.

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,100

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,397 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 95,331 Super User 2025 Season 2 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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans