Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Open Journal Entry Lin...
Finance forum
Answered

Open Journal Entry Lines in Excel Blob Storage

Posted on by Microsoft Employee

This issue was specifically brought up during testing in our Upgrade environment but is also seen in our standard Test environment. When we try to use the 'Open lines in excel' functionality of the General Journals form, we receive an error that is thrown from trying to connect to blob storage.

This issue occurs in our non-Production environments only.

We were told to upgrade to PU25 to resolve the issue. We have since upgraded to AU 10.0.1 PU25 and still see the issue. We see this issue in our old 7.1 Test environment as well as our upgrade environment (on both 8.1 and after updating to 10.0.1)

This issue is related to a bad link between the environment and it's blob storage location, I believe from being ported through from Production incorrectly. We have tried re-dropping the DB but it has not solved the issue. We need someone to figure out how the environment is linked to its blob storage - The last Microsoft rep we had on this issue tried recreating the issue in a different environment and was not able to. I need someone experienced with knowledge of how the blob storage functionality works to look at this.

Error message:
Record for Id - {AB29263F-58E7-4379-B1EF-8D28904FB5F0} not found.

Repro steps:
1) Navigate to General Ledger -> Journal entries -> General journals
2) On an open journal, try to use the 'Open lines in excel' functionality
3) Receive error

journal.PNG

journal2.PNG

I appreciate your inputs

  • Raul nr Profile Picture
    Raul nr 10 on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Hi. It worked, Sukrut, thanks a lot

  • Raul nr Profile Picture
    Raul nr 10 on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    ok

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Hi. It worked, Sukrut, thanks a lot

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Hello DynamoJones,

    Have you already tried creating a new template from scratch to see whether you can make the export with this new template?

    Does the new template also fail to export the data?

    Here are some hints how you can create such a new template: dynamicsax-fico.com/.../dynamics-365-general-journal-excel-imports

    Best regards,

    Ludwig

  • Verified answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,643 Moderator on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Try reloading templates from common>Office integration >Document templates

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Hi Sukrut,

    We have tried re-dropping the DB but it has not solved the issue

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,643 Moderator on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Is it happening after DB restore ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Hi André,

    It is a Microsoft Managed environment

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Open Journal Entry Lines in Excel Blob Storage

    Hi DynamoJones,

    Can you tell if you have a cloud instance or an on-premise environment?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans