web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to get the ledger ...

Finance | Project Operations, Human Resources, ...

Unanswered

How to get the ledger account value from the view distribution in purchase requisition

(1) Share

Report

Report

Posted on by D365FO DEV

406

Hello,

I need to get the value of the ledger account field in the view distribution in purchase requisition.

basically i checked the relation between the two tables, purchreqline and AccountingDistribution, its on sourcedocumentline field. i need to show this value in my ssrs report.

i added this relation but for some reason its coming blank when i debug:

select firstOnly LedgerDimension from accDistribution
where accDistribution.SourceDocumentLine == purchReqLine.SourceDocumentLine
&& accDistribution.SourceDocumentHeader == SourceDocumentLine::find(purchReqLine.SourceDocumentLine).SourceDocumentHeader;

anyone can help?

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 414 Super User 2026 Season 1

#2

#3

Martin Dráb 275 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans