Notifications
Announcements
No record found.
Our client recently applied the Year end update and are now running GP 18.3.1200. We've found at least one SQL Server Reporting Services doesn't run (the Historical RM Aged Trial Balance). I've redeployed the reports but the same error persists:
I doesn't look like I can do much with that dataset.
Any suggestions?
I have 18.3.1200 and that SSRS report works fine.
I'm interested in the 'Invalid object name 'dbo.Customers' message. Does the 'Customers' view exist in the company database that you're running the report against?
You can use these scripts against the company database to verify:
1. Select * from Customers
2. Select * from sysobjects where name = 'Customers'
'Customers' is a SQL View that should exist in each company database.
Thanks
That appears to be the issue. The report was running against a TEST company so I was looking at data. Their database is missing the customers, customer items and customer address views - and I'm guessing several others. I'll move these three over from TEST but any suggestion on recreating any others that might be missing?
That was it - the report was running against their TEST company so I was looking at possible data issues. I can tell we're missing multiple VIEWS somehow. Is there an easy way to find/recreate them?
Easiest way would be to script them into a query window from another company database, then use that script to create them in the company database missing them.
Otherwise, Database Maintenance Utility is used to re-create Views.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 422 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
