Finance | Project Operations, Human Resources, ...

relation between salesinvoicetmp and salesinvoiceheaderfootertmp tables

(3) Share

Report

Posted on by charan12

296

HI All,

I am printing sales invoice report , but the report is getting with empty values but the fields which are getting empty in report they actually have values. I think to get new values in report we have to delete or update the records in the salesinvoicetmp table by joining with the salesinvoiceheaderfootertmp table. I checked there is no direct relation between them.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Slow down. Are you talkling about a standard report, the standard report that you customized in some way or a report developed by yourself?

If it's about the standard report, it should work. You shouldn't have to do any development to get it working. If you find a bug, you can ask Microsoft to fix it.

If it's a customization, debug your changes. If you need help, tell us what you've customized and what you found during the debugging.

If it's your report, we can't tell you what tables you're using there and how. It's you who needs to give us some information about your development. And of course, don't forget to debug your solution to isolate the part that doesn't work.

Was this reply helpful? Yes No
Syed Amir Ali 179 on at

Like (0)

Report

Hey,
What I understand is that you have added a new field to the SalesInvoiceTmp table by creating its extension. You have mapped it in the DP class and added it to the report design as well. However, when you print the report, the field appears empty even though it is being populated in the table when you debug it.

If that's correct, please try restarting the "SQL Server Reporting Services." and go to search option and type "Report Server Configuration Manager." First, stop it , then start it again. After that, refresh your Dynamics 365 application and try printing the report again

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

If this is the scenario (which we don't know yet), my first step would be verifying that the extension of the RDP class works and the data is correctly inserted. If not, there so no pointing running the report, restarting SSRS etc.

Was this reply helpful? Yes No
charan12 296 on at

Like (1)

Report

HI Martin and Syed Amir,

I printed the report in UAT not in Dev, I connected my UAT DB to Dev and inserted records into fields of my custom table, those custom fields present in the salesinvoiceheaderfootertmp table. Already created extension and added custom fields in report design previously developed developer. based on some condition in salesinvoicedp class extension the salesinvoiceheaderfootertmp table getting values from my custom table.

Was this reply helpful? Yes No
Syed Amir Ali 179 on at

Like (1)

Report

Charan, you cannot made changes directly in the UAT environment. Instead, implement the changes in the Development environment and then deploy them to UAT.

If the changes still don’t reflect in UAT after deployment, try restarting the Reporting Services from Lifecycle Services (LCS)

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Test your changes in the development environment. If they don't work there, don't event attempts to deploy the non-working solution into UAT. If it works in DEV but not in UAT, make sure that all your changes have been deployed correctly. If so, debug your code to see whether the problem is in the data preparation or later.

By the way, give us more details about situation next time. We can't help you if you don't tell us enough about your problem.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,407 Super User 2025 Season 2 on at

Like (0)

Report

Hi charan12,

There is no need to delete data or update any data in the temporary tables like salesinvoicetmp tables by joining the salesinvoiceheaderfootertmp table. Add the desired field to SalesInvoiceTmp.

In your DP class modify the populateSalesInvoiceTmp with the required fields and based on the data required retrieve the data from the relevant tables. Screen clip gives a glimpse of how the data is populated in SalesInvoiceTmp table.

In case of SalesInvoiceTmp table data population, in most of the cases data is retrieved from either CustInvoiceJour, CustInvoiceTrans or CustTrans.

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

The report does not uses the temporary tables but the Regular tables. Having regular tables means data would not be deleted on closure of the session.

In both cases (whether standard report or customized version), report needs data cleanup.

For standard report it happens via auto healing process, where you have opportunity to change the schedule. The standard job for cleanup is labelled as Sales invoice report clean up for temporary data

For customized version of the reports if you are adding a new tables (not adding a field in the existing tables via extensions), you MUST write the delete logic as written for many tables in the SalesInvoiceDP class (via extension class). Please look inside the code of SalesInvoiceDP class and search using keyword delete_from (You would be able to find many deletions).

Your custom table (if you have any) must has the CreatedTransactionId field getting same value as transactionIdForCurrentSession

You could also look at extending the self cleanup class (SalesInvoiceTempDataCleanup) in case if you have added custom tables.

If you are customizing the report by extending the existing/standard tables only and not adding a new table, You can live with self healing process which cleans up the report data as per schedule. You can run that anytime to flush all data of this report.

Was this reply helpful? Yes No