web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
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

I have the same question (0)
  • THE Italian Profile Picture
    THE Italian on at

    What's the version and build number of the application?

  • Lars Lohndorf-Larsen Profile Picture
    Lars Lohndorf-Larsen on at

    +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,

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    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

  • THE Italian Profile Picture
    THE Italian on at

    Version and build no.?

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    Sorry - Platform 16.0.12630.13893 Application 16.1.12629.12805

    Cheers

    Heather

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at

    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

    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

    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

    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

    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

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,090 Super User 2026 Season 1

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,090 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,277 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans