Finance | Project Operations, Human Resources, ...

Journal are not opened using Excel Add-in

(0) Share

Report

Posted on by Finance and operations

Hi,
We are not able to open any journal in Sandbox using Excel Add-in. We are using D365 version 10.0.23.

(We are planning to upgrade to 10.0.25 but we are seeing this issue as a show stopper)

However, in PROD, the add-in are opened.

Any suggestions

Thankyou !

Kamel.

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 300,970 Super User 2025 Season 2 on at

Like (1)

Report

Hi Kamel,

Based on the information you provided, it is not clear on which environment you are running which version. Is the Sandbox running now on 10.0.23 or 10.0.25? If it is on 10.0.23, then first update the Sandbox to see if that solves the issue. If it is 10.0.25, check if there is a quality update or consider updating to 10.0.26.

Do you have customizations in this environment? A customization on any data entity might impact the behavior of all entities.

Was this reply helpful? Yes No
Suggested answer

A.Prasanna 8,223 on at

Like (1)

Report

MS Docs Says:

Issue: When trying to use a document template with Open in Excel a "Record for id GUID not found" error displays

Issue: The "Record for id GUID not found" error can display when copying a database from one environment to another.

Explanation: Copying the database is problematic for document templates, record attachments, and other files that are stored in Azure blob storage. When the database is copied from one environment to another, the files are not copied along with the records, so the files that the application tries to access are not found.

Solution: For document templates, the solution is to identify the templates that are needed and load a copy of those template files into the target environment.

So try to reload System document templates

Organization administration→ Setup→ Office integration→ Document templates. Click "Reload system templates"

and try again.

Regards,

AP

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

It must be because of data restore. So follow these steps

1. Down the excel template from environment where it is working or design new template

exploredynamics365.home.blog/.../

2. Navigate to env where this error is, Common Module > Common > Office integration > Document template > Import the template which you prepared

Note: You can also try restoring system default templates but that might remove all your custom templates if any

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Kamel Sadek

Please try to

1- Delete usage data (Reset usage data)

2- "Reload system templates" from Organization administration > Setup > Document template and then check if there is template for "VendInvoiceJournalTemplate" and then try again to import journal lines

Was this reply helpful? Yes No