
We're on CU16, all hotfixes included, not using MDA or AA, yet we continue to have issues with our account balances within Management Reporter.
Has anyone ever tried writing an SSRS report that compares the trial balance numbers within GP to the trial balance numbers in Management Reporter? Is that even doable using just SQL? I'm sure we could find a way to build a trial balance in MR that references an Excel sheet w/ GP trial balance numbers but this really isn't the preferred direction to take.
Thoughts or success stories?
*This post is locked for comments
I have the same question (0)Hi Kyle,
There is already a TB Summary & Detail report in SSRS that comes out of the box with GP.. though I wouldn't venture myself into trying to change it.. as it may prove to be much more difficult to arrange it to your like, whereas MR is natively build for this task.
I'd like to ask if you're using the DAtaMart or the Legacy connector ?
Since you're not using AA or MDA, it might be worth trying the Legacy Connector ? We've been using it since the introduction of MR and tried the DM, but had too many issues and went back to the Legacy connector.