I have a strange occurrence that one account number with 62 variants due to other segment combination, doesn't match the correct info in GP. I am using the Data Mart. I have recreated three times but the same results. I have created a new Column, Row and reporting tree and get these wrong amounts. It isn't consistent differences and no patterns are there. I'm hoping someone may have come across this. Also, no AA or MDA being used.
Thanks
Mike
*This post is locked for comments
After drilling around I discovered a stuck batch that was sitting in the GL work table. I then looked back at MR and noticed that they has selected posted and unposted transactions. After clearing the transactions the statement is fine. I also set the report to posted only. Thanks for your help!
Could there be some potential duplication of variants of accounts on the tree? Are there other accounts that have the same variants?
Are you specifying units of the trees at all in your row or column formats. I've seen duplication and/or wrong balances on some complex reports when you have a fairly complex tree and start specifying tree units on the other formats.
I hadn't thought of that. I created a simple report with that one account number using the whole account and that balances perfect to the GL TB. I'm just confused how this could happen to one account number.
If you don't use a tree, do you get the same results?
I have and found it strange. Most of the accounts have incorrect balances but there are a few that are correct.
Have you tried drilling down to the 62 variants in MR and compare them to the 62 variants on a GL TB in GP? Is it one account or multiple accounts that's throwing it off?
Your mentioning "it isn't consistent differences" is interesting. So if you run the same report twice, you don't get the same results or is it inconsistent differences per month?
Share
Report
All responses (
Answers (
6,912