Dynamics Community Forum Thread Details

Voiding a Cash Receipt in Sales

I was in the process of entering a cash receipt in Sales - and realized that a credit memo had been entered twice. it was the end of the day and i had to go pick up my kids so i figured i would leave it until the next day (today). Over night my computer shut down on me - not sure if that is the reason for the glitch or not. i was able to void the duplicate credit memo, but i tabbed to quickly through the window and did NOT enter a void date so it shows as 0/0/0000. now when i try to go in and enter the cash receipt all of the invoices that i had previously selected to be applied to the payment yesterday are no longer available to select today. but if i look in the receivables transaction inquiry and select one of the invoices it shows the payment but when i click for detail on the payment (from yesterday) i get a message that says "this document does not exist"

Hello Kim,

Thank you for posting your question on the Forums. My name is Brandon and will be providing information on your issue.

What is happening is the Transaction record for the Payment is missing and all you likely have left for the Payment is the Apply Record and why you can see the Payment when you look Receivables Transaction Inquiry and zoom into the apply records.

When we see this in support, the process we use to correct this is:

Review the Transaction in SQL to determine what records are available.
1. RM00401 (keys)
2. RM10101 (Work/Open Distributions)
3. RM10201 Cash Receipts Table. (Record doesn't exist and why you get the message pop up stating the document doesn't exist) -Would be in this table if in work still.
4. RM20101 (RM Transaction Open) (Record doesn't exist and why you get the message pop up stating the document doesn't exist) --Would be in this table if posted and not moved to history.
5. RM20201 (RM Apply Work/Open.
6. CM20200 (Bank Rec)
7. GL10000, GL10001 (GL Work)
8. GL20000 (Open)
Depending on what records we have determines how you approach this.
1. If the Transaction Record is missing (RM10201 or RM20201) then we would remove the rest of the Records as they shouldn't exist if we dont have a Transaction Record.
2. Once the apply records are removed, you can run Reconcile against Outstanding Document Amounts to correct the Current Amount of the Invoice so a new Cash Receipt can be created and applied.

I would need to review the data for the Payment in question to determine if this is the scenario that you are running into. If you would like to dig into the data further, please create a support case to allow me to pull the data for review.

Another option is to run Check Links on the RM Transaction Logical. If the payment is Damaged, the apply records would get removed. However, you would want to do this in TEST as i dont know what check links will do in your system as i dont know your data. Any additional transactions that show on the report would need to be investigated before running this in live.

The information above is provided As-Is.

I hope this helps!

Microsoft Support Engineer | Brandon Jarrett

Quick Links