Forum Discussion

zacb's avatar
zacb
Member
19 days ago

Missing Report File - secaudit.xlt doesn't exist in reports folder

One of our users are getting the following error when trying to generate a report.

They see the preview but when they try to export to Excel they get the following the below error

This specific report is a security audit.

 

The following article suggests there is no template(?).

https://www.myob.com/au/support/myob-business/reporting/exporting-reports/microsoft-excel-templates?productview=Browser#:~:text=Journal%20Security%20Audit 

  • A previous search suggested tried adding the reports folder as a trusted location in Excel.
  • The reports folder is in their documents so they have full control.
  • Copying an existing template and naming it secaudit.xlt results in a successful export but the headings obviously don't match because its the wrong template.

I've done a fresh install of MYOB on my own system and that specific file is still missing.
I've also checked the reports folder for other MYOB users and none of them have the specific report template secaudit.xlt where do I find it?

1 Reply

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    19 days ago

    Hi zacb

     

    Thanks for the screenshot. I can see why it looks like the Security Audit report should go to Excel. You are not missing anything on your side. AccountRight just does not include a secaudit.xlt template, so the Security Audit report from the desktop cannot export cleanly to Excel right now. Copying another template and renaming it will run the export, but the columns and headings will not match, so it is only a rough workaround.

    For now, you can

    1. Run the Security Audit report to PDF from the desktop and give that to your auditors
    2. If your file is online, open it in the browser version and use Export to Excel there
    3. Where available, export as CSV or TSV and open that in Excel

    This limitation is already on the radar with our support and product teams, so they can look at improving it in a future update.

     

    Regards,

    Genreve

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.