reconcile to GL

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (0)

soma 24,410 on at

Like (0)

Report

Did you get the reconciliation report after got this error?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Rabia,

I do not see any attached reports. Where can you get to attached reports?

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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.

leslievail@earthlink.net

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Rabia,

If the void is correct, it seems like the void needs to be posted to the GL. If you have already posted some entries, please re-create the reconciliation spreadsheet and e-mail me the new spreadsheet.

Kind regards,

Leslie

Was this reply helpful? Yes No