Finance | Project Operations, Human Resources, ...

Electronic Reporting Error - Running a Purchase order

(0) Share

Report

Posted on by SandraS2654

Hi all,

I am trying to run my Purchase Order derived from the Microsoft Configurations GER(without any changes) and I am met with these errors. Can someone help me?

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Hello Sandra,

The error message says that the purchase order inquiry ID is not correctly bound.

Can you check your model and ensure that this field is correctly mapped/bound?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

see if this helps

https://dynamicsax-fico.com/2018/07/05/electronic-report-modifications/

Was this reply helpful? Yes No
SandraS2654 15 on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Hi,

Thanks for the response. Maybe I am a little confused then.

In my model, I see Purchase order inquiry reference item is root node Order.

I have added "Purchase" definition in the "Model to datasource mapping". Inside that designer, I see that "PurchaseOrderInquiry: Record list" is not binded to anything. Would I add the data model source "Order" root?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Hello Sandra,

What D365FO version do you operate?

Have you made any modifications to the electronic reports or just downloaded them from LCS?

Can you share the version of the electronic report (simple screenprint from the electronic reporting workspace where we can see the version number).

Many thanks,

Ludwig

Was this reply helpful? Yes No
SandraS2654 15 on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Hi!

Installed product version : 10.0.10 (10.0.420.10007)

Installed platform version : Update34 (7.0.5600.35524)

Version of the report is 73.56; Order model version 73

I have not made any modification to the report; just derived directly from the imported MS report

Thank you!

Was this reply helpful? Yes No
SandraS2654 15 on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Here are some more screenshots of my model

Reference item is "Order" root node.

I added "Purchase" definition

Inside the designed I added data model "Order" and binded "purchaseorderinquiry" to that data model

Thanks again!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Good morning Sandra,

I tried running this report in my demo environment and things worked.

Here a short summary of that I did.

Step 1: Ensure that you have the latest version imported in your ER workspace

Step 2: Print management setup

Step 3: Create PO, confirm it and print the confirmation

Result: The report is created without error

Can you please test that you have the same version / KB of the report downloaded from LCS?

Also, I run this in a PU35 machine. If you are on an older version try to replicate it in the most recent version.

Best regards,

Ludwig

Was this reply helpful? Yes No
SandraS2654 15 on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Good morning Ludwig,

So thank you for setting up in your environment! This issue is more when I derive a PO from the MS given PO.

I cannot make any changes adding a cell/range with out getting this error

If I then delete it in the ER workspace(cancel what I was attempting to do), the same error wont go away.

If I try added the cell/range in the ER workspace, I cant navigate away because the newly added cell/range "does not exist in Excel sheet 'PurchaseOrder'"

I tried binding it to data, that didn't work. I'm not focusing on adding any new data to the report/data model so I am not sure what I am doing wrong.

The error I showed in my original post was from trying to run my derived PO with an additional cell.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Hi Sandra,

Personally, I prefer to work directly in the electronic reporting workspace and not in the Excel designer because you have kind of limited options there.

If you want to add a cell/range then I would create a copy of the MS default report because you won't be able modifying the MS stuff because of the provider name.

Once you have that copy created, download the Excel attachment, make the changes and upload it again.

That's the fastest and easiest option in my opinion.

When doing that you have to make sure that the old template is removed and that the file name is updated. Otherwise, you will get error messages.

Probably start easy and simply color a cell in the Excel sheet to see how this works.

Best regards,

Ludwig

Was this reply helpful? Yes No
SandraS2654 15 on at

Like (0)

Report

RE: Electronic Reporting Error - Running a Purchase order

Right. I have added my own text in places and changed text colors and that worked great!

I just have one more question. I have seen in some blogs of needing and derived import/export format based model for format mapping.

Is that only needed if you are creating a root model not derived from MS models?

Or do you need that when adding cells/ranges as well?

Thanks!

Was this reply helpful? Yes No