Weekly Dynamic: Excel Deployment Problem

Featured Post

I had a client with multiple companies that wanted to start using Excel reports in GP 2013. The reports showed as deployed but some companies were missing the actual reports. “No problem,” I thought. Just redeploy. After a redeploy, two of the primary companies still didn’t have reports. When I tried to deploy them individually, I got a a message that I to select a company, even though I had selected a company.

The internet was only marginally helpful. Mariano Gomez pointed toward some of the tables and that was about the best I could find. So I double checked the SY01500 table to make sure that I didn’t have some kind of weird company setup problem. Everything looked fine.

Then I checked the syDeployedReports table. This client isn’t using SSRS reports yet so the only thing that could be in this table were the Excel report deployments. Sure enough, this table showed deployed reports for my companies that wouldn’t work. I cleared the table and redeployed all reports for all companies. That fixed the problem. I’m hoping this post provides a shortcut for someone else. I spent way too much time looking for a fix.

The post Weekly Dynamic: Excel Deployment Problem appeared first on DynamicAccounting.net.