Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to get the ledger ...
Finance forum
Unanswered

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

Posted on by 320
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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans