Finance | Project Operations, Human Resources, ...

Electronic Reporting - Sales order confirmation is printing all the records instead of only one record

(0) Share

Report

Posted on by Mark Loren Manuel

125

Hello,

I configured sales order confirmation report in Electronic Reporting. I use the SalesConfirmDetailsTmp table as my data source. The report is working fine on one of the company we have but when I used it on the other company it's printing different sales order number and all the items in sales orders are showing instead of the items only belong to the specific sales order number.

Thank you in advance.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mark,

Did you create / modify this report yourself?

How did you define and map what you want to see as the output of this report?

Would be great if you could provide more information.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Mark Loren Manuel 125 on at

Like (0)

Report

Hi Ludwig,

Thank you for your reply. I created the report and map it to SalesConfirmDetailsTmp table. Please see below screenshots. Is there any filter or parameters I need to add in order to bind it to the sales order confirmation report?

Model :

Table Records :

Model Mapping:

Please note that this configuration is working in one of the company.

Thank you,

Mark Loren Manuel

Was this reply helpful? Yes No
Arcadi 794 on at

Like (0)

Report

Hi Mark,

I'm interested in seeing how you solve this, what I used to do is to use an object in ER, that returns a Sales Order ID when printing (I think it ends with "DP") and then just filtering the table by this ID. But I think asking for the Query has more sense. Have you tried using the header instead of the lines?

Was this reply helpful? Yes No
Mark Loren Manuel 125 on at

Like (0)

Report

Hi Arcadi,

Not yet. My only confusion is the report is working fine on one of the company entity, the only problem is when I applied it to other company entity. Let me try use the header and try the configuration you are using.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mark,

What filter is applied that ensures that this report is only printed for the sales order you are on?

Please check the other standard MS reports and how they add a specific filter that prints only those data of your active record.

Best regards,

Ludwig

Was this reply helpful? Yes No
Mark Loren Manuel 125 on at

Like (0)

Report

Hi Ludwig,

There is no filter applied. I just add the SalesConfirmDetailsTmp table records and map it on the data model I created. Can you please provide me example on what data I need to add on the filter in order to get the correct information on the sales order confirmation screen.

Thank you

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mark,

You can have a look - for example on the following reports where you see such kind of filters applied:

- Purchase order (Excel)

- ISO20022 payment models where you can have a look at how the covering letter details are filtered out and identified

There are more available but these are the first ones I found.

Can be a bit tricky if you have not applied that before but ultimately you will make it after having a look at those standard reports.

Best regards,

Ludwig

Was this reply helpful? Yes No