News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... How a tmp table is bui...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

How a tmp table is built for a report

(1) Share

Report

Report

Posted on by Michael Hutcheson

125

Hi,

There is a report in Dynamics 365 F&O called 'PurchStatisticsVendItem'.

When I open the report in Visual Studio, the data source is:

SELECT * FROM PurchVendItemStatisticsDP.PurchVendItemStatistcsTmp

I would like to know how this tmp table is being built - in particular the fields 'LineAmountPrd1' and 'QtyPrd1'

How do I go about this?

I have looked in the Classes for the report but there appears to be only a 'getReportName' class - I believe I need to locate the 'processReport ' class but cannot find this?

Thanks,

Michael

All responses Img

All responses (1)

Answers Img

Answers (0)

Dengliang Li Microsoft Employee on at

Like (0)

Report

How a tmp table is built for a report

Hi Partner,

Based on your issue description, you are using the Dynamics 365 Finance and Operations application.
Therefore, you should post your question in the following forum for further assistance.
Finance forum | Microsoft Dynamics 365 Community

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans