unable to open vendor invoice journal in excel in 10.0.6 UAT environment

(0) Share

Report

Posted on by Myrah

Hi All,

We recently updated our D365F&O UAT version from 10.0.3 to 10.0.6, since then we are not able to open invoice journal lines for Accounts payable module and General Ledger module in Excel.

we get the below error: record for id (guid) not found

Any suggestions, how can we resolve this issue?

Thanks,

Myrah

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

WillWU 22,361 on at

Like (3)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

Hi Myrah,

Here is a error description about it:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dm-error-descriptions#data-package-download---error-downloading-data-package-for-job--record-for-id---guid-not-found

Please try to refresh your database:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/database-refresh

And the system templates may need refreshing,click the Reload system templates button in the Common > Common > Office integration > Document templates form:

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (1)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

+1 Will

The record/data seems to be verified?

Can you check in SQL if it's not a production and if production then check in ledgerjournalsline/trans table

Doing a full DB sync after full compile would be better to torubleshoot and then first confirm the data is good in UI and could possibly update and then try to open in Excel and suggest

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

Like (0)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

Hello Myrah,

Please review the answers provided and let us know if your issue has been resolved.

Many thanks and best regards,

Ludwig

P.S. Why are you still using the 'old' invoice journals?

Was this reply helpful? Yes No
Myrah 15 on at

Like (0)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

Hi Will,

Thanks for the guidance. We are able to use the excel templates again.

Regards,

Myrah

Was this reply helpful? Yes No
Myrah 15 on at

Like (0)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

Hi Ludwing,

We managed to resolve the reported issue, with Will's help.

Could you please explain, what do you mean by 'old' invoice journals?

We have recently started using D365F&O, and the migration was done by third party Microsoft partners.

We are not fully verse with the application functionality at the moment.

It will help us in understanding, if we know what is the difference between new and old invoice journals?

We are based in New Zealand.

Looking forward to hear from you.

Thanks & Regards,

Myrah

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

Hi Myrah,

I am a 'fan' of the pending vendor invoice form that you can use for recording expense related and purchase order related invoices.

All is included in a single form and when invoices are entered, nobody has to think whether to record them in the invoice journal - that can only be used for expense type of invoices - or another journal / form.

Maybe that is something to discuss with your local partner/consultant.

Best regards,

Ludwig

Was this reply helpful? Yes No
Myrah 15 on at

Like (0)

Report

RE: unable to open vendor invoice journal in excel in 10.0.6 UAT environment

Thanks Ludwig, will definitely raise this with our local consultant.

Was this reply helpful? Yes No