You’re offline. This is a read only version of the page.
5
We have a new error message that shows up when we generate Management Reporter Report to the Web View (Web Browser) and then try to export to the Excel. It happens in all the browsers that we use: Microsoft Edge and Google Chrome. I am not sure what can cause it since it worked before without any issue and it happened just few days ago.
I have tried the following:
- Deleted temp files in the C:Users/UserName/AppDate/Local/Temp
- Refreshed the report
- Cleared Cookies, Cache, browsed websites, history and etc.
- Reset Web Browser to the Default
It helped once but after trying exporting on the other user's computer it could not help anymore. Nothing seems working thereafter.
What could cause it?
Thank you for your suggestion, Greg. I agree with you that those characters could cause such problems sometimes. I have checked details in the Configuration Console yesterday and we have rebooted the servers. The exporting works thereafter without any issue.
This error is usually caused by an invalid character somewhere in the data that is being exported. This can be a difficult thing to track down. I'd start by trying to narrow down where it happens. If you generate it for last month, does it happen? If you can narrow it down to what month it happens in, that will help.
You may want to do a File | Save As on the row and use that in the report. Then delete half the rows and try it again. Do you get the error? If you do, delete some more rows and try it again. See if you can narrow it down to the account it happens for.
If you can narrow it down to the month and an account, then you can run a statement like this against the GP company database:
select REFRENCE, * from GL20000 where OPENYEAR = 2023 and PERIODID = 1
*replace the OPENYEAR and PERIODID with the dates that apply to your situation.
If you know the account it happens for, then you can look up the account index in the GL00100 table and then query that:
select REFRENCE, * from GL20000 where OPENYEAR = 2023 and PERIODID = 1 and ACTINDX = xx
*replace the OPENYEAR, PERIODID, and ACTINDX with the dates that apply to your situation.
What usually happens is you find an odd character in the REFRECE column. That can't be export to Excel and you get the error message.
Once you find this, you can update the data and replace/remove the odd character that you find.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
