Finance | Project Operations, Human Resources, ...

Cash Receipts apply window froze, user cannot see transactions How to resolve wo check links

(2) Share

Report

Posted on by ABrown

Cash Receipts apply process was interrupted and user cannot see open (apply) transactions via the window. How can I replicate the check links process for these transactions?
I have a user who was in the middle of applying cash receipts when the process was interrupted. GP froze, and she had to close out. Upon going back in, she does not see 3 transactions in the window where she needs to select them to apply cash receipts. Behind the scenes, I see the transactions in the RM20101 – Open Transactions table and RM20201 – Open Transactions Apply table. What other tables would these transactions be in or be affected?
Backstory and the bigger problem. Check Links works to correct this transaction. Unfortunately, there are two pages of data that running check links will affect, and this will cause further problems. I did not realize this was not being run or maintained, but that’s for another day. I am looking to perform the ‘check links’ process without running it, if at all possible, for this particular transaction. I have tried deleting the rows from RM20201, but that doesn’t appear to be enough. If I delete the rows and run the reconciliation, that appears to bring the transactions back in the correct state. I am going to have the user test it tomorrow, but in the meantime, are there other options or suggestions? Reconciliation for sales alone is not enough, and deleting from the table only is not enough. Both appear to work, but I am looking for insight or alternatives other than deleting directly from the tables via SQL.
TIA!

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Adis 6,048 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

Could you please share some screenshots and describe them, what is being done and when the issue arise?

I am not familiar with GP to be honest, but with only text I think it will be quite hard for others to follow.

Kind regards, Adis

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 921 Super User 2025 Season 2 on at

Like (0)

Report

Try Microsoft Dynamics GP > Tools > Utilities > Sales > Reconcile > Outstanding Document Amounts. You can restrict it to just a specific customer/range

Was this reply helpful? Yes No
Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (0)

Report
you're on the right track with your investigation into the RM20101 and RM20201 tables. These transactions typically reside in the following tables:

RM20101 (Open Transactions): This table stores open receivables transactions.

RM20201 (Open Transaction Apply): This table stores the links between open transactions and payments

There are a few additional tables that might be involved or affected by the interruption of the cash receipt process:

RM10101 (Receivables Transaction History): If the transaction has been processed at some point and moved to history, this table might be relevant.

RM20103 (Open Transaction Amounts): Stores the amounts of open transactions and applies.

RM30201 (Cash Receipts Work): Temporary table used for cash receipt entries. This might be relevant if the application was interrupted at the point of applying cash receipts.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
ABrown 81 on at

Like (0)

Report

@Ramesh, Thank you. I was not able to find RM20103 (Open Transaction Amounts), but was able to verify the others. I think we're good with just the deletion of transactions from RM20201 – Open Transactions Apply table, and then running the 'Tools > Utilities > Sales > Reconcile > Outstanding Document Amounts' for the specific customer. The user tested and all looks good from the front and back end.

Thank you to those who replied. I appreciate your input.

Thank you,

Angela

Was this reply helpful? Yes No