Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Financial Report error...
Finance forum
Answered

Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

Posted on by 410

Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

How can I set up or fix this issue ?

2335.Untitled.png

  • Verified answer
    Tanyaboon Profile Picture
    Tanyaboon 410 on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    I try reset MRdata on SQL Server as below link. It's work.

    I can run report now.

    docs.microsoft.com/.../reset-financial-reporting-datamart-after-restore

    Thanks you so much everyone.

    If you have any idea, Please share.

  • Tanyaboon Profile Picture
    Tanyaboon 410 on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    Thank you very much Dr. Ludwig. I will try your suggestion.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    Hello Tanyaboon,

    Can you try generating the report again from the Management Reporter (MR) console? Simple select the report and then select 'edit'. This should

    open a new form that allows you generating the report directly from MR.

    Before doing that please ensure that your company's ledger accounts are matched to the lines in the default balance sheet report. That is because the default balance sheet record that you use refers to the MS Contoso demo company chart of account. If your company uses a different chart of account the report cannot be run directly without a prior mapping of the ledger accounts in the row definition of your report.

    Best regards,

    Ludwig

  • Tanyaboon Profile Picture
    Tanyaboon 410 on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    Hi Murali Dorai,

    1) Did you try resetting the data mart?

    No, I didn't. Can you suggest ?

    2) Did you apply the hot fix fix.lcs.dynamics.com/.../Resolved.

    Not yes. I'm a newbie for Dynamics 365.

    3) Are having office 2016 on your machine?

    Yes.

    4) Are having this issue on only this report or any report?

    I have a problem with all of reports.

    5) How large is the report is it more than 10000 lines?

    Less than 10,000 lines. I guest. That too large.

  • Tanyaboon Profile Picture
    Tanyaboon 410 on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    When I selected report and generated. The error has occured.

    "The operation could not be completed because the item no longer exists"

    2018_2D00_08_2D00_09_5F00_13_2D00_12_2D00_12.jpg

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    Hello Tanya,

    1) Did you try resetting the data mart?

    2) Did you apply the hot fix fix.lcs.dynamics.com/.../Resolved.

    3) Are having office 2016 on your machine?

    4) Are having this issue on only this report or any report?

    5) How large is the report is it more than 10000 lines?

    Kind regards,

    Murali Dorai

  • Jie G Profile Picture
    Jie G on at
    RE: Financial Report error when export to Excel "Function.FinancialReportingViewer.onShowSaveAsDialog has been incorrectly called"

    Hi Tanyaboon,

    Which report under "Dynamics 365 for Finance and Operations -> General ledger -> Inquiries and reports -> Financial reports" are you trying to export?

    Have you generated the report successfully? Can you open the generated report?

    8625.1.PNG

    8625.1.PNG

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