850
I have created a Consolidated Cashflow Statement for multiple companies. The last column (total column for all companies) totals perfectly except for the Cash @ the beginning of the period. This is showing as blank thus the End of the Period balance is incorrect. Thank you so much of your help.
*This post is locked for comments
I would like to find out the following additional information.
1. What is the exact build of Management Reporter? Help | About
2. Are you using the Data Mart?
A. If so, I would like to get the results of the following SQL statement, run against your Company Database.
SELECT GL200.JRNENTRY,
GL200.SOURCDOC,
GL200.ACTINDX,
GL105.ACTNUMST
FROM GL20000 GL200
JOIN GL00105 GL105
ON GL200.ACTINDX = GL105.ACTINDX
WHERE GL200.PERIODID = 0
In order for Beginning Balances to be brought forward into the current year, has your last year been closed? If not, you would need to close last year. There is also column option which includes Beginning Balances for both Periodic and YTD (PERIODIC/BB & YTD/BB) you might use as well.
Our MR is currently version 2.1.1037.15. Microsoft Dynamics GP is 2013 version 12.00.1538 (SP2). Thank you.
hersheys,
I'm sorry to hear you are having issues with Management Reporter. What Microsoft Dynamics product are you using this with? I will than be able to move your question to that products forum where more professionals will see it.
Justin Salter
Community Manager
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (