News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Get orgNumber from dir...

Microsoft Dynamics AX (Archived)

Answered

Get orgNumber from dirOrganization

(0) Share

Report

Report

Posted on by Oush Mi Ta

190

Hello,

I need to get the orgNumber to display on a report. This can be found in dirOrganization table. But there are no relations that I can use.

How can I link it to DirPartyTable or to vendTable?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Oush Mi Ta 190 on at

Like (0)

Report

RE: Get orgNumber from dirOrganization

Thanks for the help. It works.
Verified answer

fatihgork 3,815 on at

Like (1)

Report

RE: Get orgNumber from dirOrganization

Hi Oush,

There is a method under VendTable that returns Organization number of a vendor: VendTable.organizationNumber()

And the relation between these two tables are:

DirOrganization.RecId=DirPartyTable.RecId

and

DirOrganization.RecId=VendTable.Party

It can be found in relations section of related table under AOT/Tables

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans