Dear Experts, when i take the report from the reconcile to GL for the receivables management module, in my matched transactions the GL table is not showing the same transaction as in the Receivables Transactions side.
also when i click process, it shows me the following message.
Unhandled object exception:
Unable to access field 'Workbooks'
EXCEPTION_CLASS_OBJECT_EXCEPTION
ExceptionSubClass:0
*This post is locked for comments
Hi leslie
With your help i have sorted out the issue with receivables sub ledger matching to the gl.
Payables are almost done too. Now the only issue that remains is the inventory.
I don't have sql support that's why i had asked is there a way to manually reconcile it.
Hi Leslie, Thank you for your precious time spent on sorting out the issue. i Have passed a GL entry for the void of PYMNT000000000017 made it to the RM side, but didn't make it to the GL side. Now the difference shows the opening balances as i told earlier i.e, 95,994.827 (i have reversed the earlier GL entry i passed for this difference) , which comes from these ledgers
- Unearned revenue (11,249.077)
- Advance From Customers (84,745.750)
one question , should i pass (01/01/2014 2081 GLTRX00000402 01-1-11-010-0 95,994.83 )
it again ?? will it solve my issue
Hi Rabia,
Thank you for sending the spreadsheet. It made it much easier to see the issue. On the spreadsheet, GP listed a 'Potential Match' on something that was actually 'Unmatched'. It looks to me like the 'unmatched' transaction was actually a match and the 'potentially' matched transaction on the RM side really didn't match. So, the void of PYMNT000000000017 made it to the RM side, but didn't make it to the GL side. Depending on which side is correct, you either need to make a GL entry or make an RM entry that will not impact the GL.
What do you think?
Leslie
Hi Rabia,
The upload didn't turn out to well on my side. If you would email the spreadsheet to me, I'll be happy look at it. I apologize for being a dunce on this one, but I just don't have my arms around the challenges you are facing.
Kind regards,
Leslie
Dear Ma'am, it is not allowing me to post a larger picture. What i am saying is that the unmatched transactions has 2 tables. RM entries showing in the left side of the table & the G/L entries for the same transactions showing in the right side of the table. In my report what is happening, the left & right sides are not matching transaction wise so that i can find out the problem. It is showing me different transactions on both sides , so it is difficult for me to match them. I will try to upload one row for you to understand what i am saying.
Thanks
Please see below if you can get my point ma'am.
| 31/01/2014 | IWS-C1006 | RMCSH00000002 | PYMNT000000000047 | (5.00) | 31/01/2014 | 117 | RMCSH00000002 | PYMNT000000000007 | 01-1-11-010-0 | 10.00 |
Thank you,
The screenshot is very small so I cannot see the highlighted items. It looks as if they are in the matched section. Are you saying that they do not really match? From what I can see, only one transaction is unmatched and one transaction is potentially matched. Is that right?
Kind regards,
Leslie
Yes Soma, I am able to get the report as i attached. sometimes it shows this error sometimes not.
but the report is not showing side by side the transactions.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
