A client recently reported a problem whereby users were no longer able to export a SmartList favourite to Excel as they were receiving a permissions error when the Excel file opened:
The SELECT permission was denied on the object 'uv_AZRCRVBudgetByMonth', database LIVE', schema 'dbo'
I did some checking and realised that the problem was that the file being opened when the user tried to do an…
Continue Reading Ian Grieve’s Article on their blog
Permissions error exporting Microsoft Dynamic GP SmartList Object
A client recently reported a problem whereby users were no longer able to export a SmartList favourite to Excel as they were receiving a permissions error when the Excel file opened: The SELECT permission was denied on the object ‘uv_AZRCRVBudgetByMonth’, database LIVE’, schema ‘dbo’ I did some checking and realised that the problem was that the file being opened when the user tried to do an export, was named like a Refreshable Excel report; a little more checking showed that there was a Refreshable Excel report of that name using the view from the SmartList.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP8 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Improved Updates of ARES Data in the Czech Version
- Dyn365GP8 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Report Explorer has Additional Outputs in the Czech Version
- Dyn365GP7 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Improvement of Czech Localization Reports
- Dyn365GP7 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Process Czech Bank Statements, Payment Orders More Productively