Share
Report
406Hello,
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;
where accDistribution.SourceDocumentLine == purchReqLine.SourceDocumentLine
&& accDistribution.SourceDocumentHeader == SourceDocumentLine::find(purchReqLine.SourceDocumentLine).SourceDocumentHeader;
anyone can help?
I have the same question (0)
All responses (
Answers (
