We are using GP2013 SP2 with SQL2012.
In MR2012 CU6 when GL Accounts Detail level (Finance,Accounts and & Transactions) selected. In MR output some of the GL account Period1,2 and 3 ending balance does not match with GP Account summary.
1) We ran checklink
2) We ran reconcile (Finance-->Utility-->Reconcile)
If any one has come across same type of problem and found solutions, please share the same.
*This post is locked for comments
Hi Babu
Example you have completed year end for 2013. In MR if you are extracting GL for 2014 P1 than
I found root cause is that if you have all unposted transaction in P1 than MR is having problem in generating Opening balance. The closing balance is printed in MR correct.
Hi Amit,
Have you selected period covered Periodic BB or YTD BB (in column definition) which might bring beginning balance of that period.
thanks,
babu
Thanks Babu for your reply,
Actually it is happing only for 1 or 2 accounts randomly for a given company.
IN MR2012 period 1 closing balance is zeor . After printing of Period 2 transaction the closing balance dumps the period 1 last transaction which prints as closing balance for 2 and closiing balance for 3. (because all period 2 and 3 transaction debit and credit amount same and balance is zeor for period 2 and 3).
Let me know, if you need further detail.
Thanks
Amit
Hi Amit,
This will happen if you have given any segment on column more than once in a row. You may check the summary balance is less than MR balance so you will know its getting doubled up.
Thanks,
Babu
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
