Finance | Project Operations, Human Resources, ...

D365 ER - Not able to populate data from temp tables in custom ER Report VendPaymAdviceReport

(2) Share

Report

Posted on by ManjushaVinukollu

I have a custom template built for Vendor payment advice ER Report. I have added fields to the tmp table BankPaymVendAdviceTmp table's extension, I created a derived config for data model, and model mapping. I created a format mapping and binded them . But the fields that i added wont show any data when i print the report.

What am i missing? Do we need to change the query associated with it? I am new to ER and wnat to understand if queries are involved in processing the report.

Thanks in advance

I have the same question (0)

All responses (5)

Answers (0)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

how the temp table is populated ? Through RDP class ? If RDP class is used to populate temp table ,do you see values when you debug RDP class ?

Was this reply helpful? Yes No
Jeremy_Mounet 170 on at

Like (0)

Report

Hi

Did you adjust the Model Mapping between the data source (where there are Data Provider and temporary table records declaration) and the Data Model ?.

If your temp Table is correctly set with a correct populate in the Data Provider class of your new fields, maybe it miss the binding of them from the Data Source provided by the Model Mapping.

You can open the design of your model mapping (if you create one) corresponding to your Report (component configuration) and check your new fields in the data source (tmp table or data provider method depending your implementation) and check the binding of your new fields with the data model (on the right of the form of the model mapping designer).

The format is communicating with the model, not directly with the datasource.

Jérémy.

Was this reply helpful? Yes No
ManjushaVinukollu 9 on at

Like (0)

Report

Yes, I did adjust the model mapping and i see the new fields under the temp table and they are binded to the datamodel on the right in the designer... Also i debugged and the data is being inserted in the temporary table too... But cant see the data on the report...

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Raga,

My knowledge is that tmp tables / table records are currently not supported through ER.

You would have to create a new class/table if you want to retrieve those data through ER.

Best regards,

Ludwgi

Was this reply helpful? Yes No
CU08051717-0 2 on at

Like (0)

Report

Did you find any solution? Facing same issue I have earlier printed report from tmp table in ER, not sure what am I missing

Was this reply helpful? Yes No