Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Account Schedules - Up...
Small and medium business | Business Central, N...
Suggested answer

Account Schedules - Update Existing Excel file - creates random file

(0) ShareShare
ReportReport
Posted on by Heather Roggeveen 9,146

Hi

I have set up an account schedule in Business Central.  From the Navigate Overview, I chose to Export to Excel --> Create new document.  I saved this document without any formatting changes or anything.

I then went back to the Overview and chose to Export to Excel --> Update Existing Document.  This let me choose the document I wanted to update and the tab to update. 

But at that stage, it doesn't update the document I selected - it creates a new file.  I get a complete random location and file name like:

2020_2D00_06_2D00_16_5F00_20_2D00_54_2D00_17.png

The client who raised this with me had it opening a "Book 1".

I think this is likely a setting - and possibly in Excel rather than BC but I have no idea where to look.  Anyone have any ideas?

I am sure this worked fine in the past.

Cheers

Heather

  • Indira88 Profile Picture
    Indira88 908 on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    Hi,

    I had a query based on this. Presently in BC 19.4 .

    Can I use the same functions to create an extension that would update and existing formatted excel file?

    This issue is very important as the moment for me. Any help is much appreciated!

    Regards,

    Indira

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    You might be in touch with your CSP Partner. They are entitled to create support request through the official channel.

    docs.microsoft.com/.../manage-technical-support

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    Hi Dulio

    That sounds easy - but it isn't - all sorts of issues trying to do that currently.  For over a week we have been trying to get it sorted for how to log calls.  I logged a call successfully end of last year, but no longer can.  Trying to work through it and now involving our account manager.

    So if there is any way to escalate via this forum, I would appreciate it.  My client has the issue and so do I internally.

    Cheers

    Heather

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    File a request to Microsoft support through your CSP partner and development team will dig this through

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    FYI - my systems upgraded at the weekend to 16.2 - this is still an issue.

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    If you have a SaaS environment then you have to wait to be moved to 16.2 where the issue seems resolved. 

    If this is not resolved, then you have to be in touch with your CSP or Reseller partner in order to open a support request to Microsoft.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    Sorry - Platform 16.0.12630.13893 Application 16.1.12629.12805

    Cheers

    Heather

  • THE Italian Profile Picture
    THE Italian on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    Version and build no.?

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    Hi

    I did spot this article - but it is specifically saying BC on premise.  Do I ignore that?  I am on an earlier version.

    Cheers

    Heather

  • Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at
    RE: Account Schedules - Update Existing Excel file - creates random file

    +1 to Duilios input about what build you are on, as there is a fix in latest build which sounds like it will help here:

    CU2 for 16.x:

    https://support.microsoft.com/da-dk/help/4564072/update-16-2-for-microsoft-dynamics-365-business-central-2020-release-w

    355347

    Editing an existing excel sheet creates a random file.

    The description is a bit unspecific but it covers exactly the scenario when exporting an account schedule and choosing "Update existing Document". This used to work OK in Windows client, but in web client there is limited access to your local disk. For that reason after this fix the file name will not be random, but it will be a copy of the document you chose. Maybe in the future this action will be renamed to "update a copy of existing document".

    Just my 2 cents, as this issue is fresh in my memory,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
YUN ZHU Profile Picture

YUN ZHU 428 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 302

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 276

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans