Is it possible to remove a report completely from Acumatica if it was saved to the server by using the command “Save to Server” in Report Designer.
I tried searching for the reports in the Acumatica folders including ReportsDefault but coming up empty.
I assume it is located somewhere in the database.
Much thanks
Best answer by TimRodman
If you have access to the database, you can remove the record from the UserReport table, but I’m not sure if it’s possible to remove it through the front-end anymore.
If you want to completely remove the report, you can remove the entry in the site map
+1If you have access to the database, you can remove the record from the UserReport table, but I’m not sure if it’s possible to remove it through the front-end anymore.
You can do this in the cloud by creating the script in a customization project, and publishing
what is the script need to look like? sql statement? delete from userreport where name like “deleteme”?
sorry new to acumatica as we are getting ready to deploy.
what is the script need to look like? sql statement? delete from userreport where name like “deleteme”?
sorry new to acumatica as we are getting ready to deploy.
I would include CompanyID to be sure I’m only deleting from the Tenant I want to remove it from.
DELETE FROM UserReport WHERE CompanyID = x AND ReportFileName = 'xxxxxxxx.rpx'
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
