Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / Cash Transaction does ...
Microsoft Dynamics GP forum
Unanswered

Cash Transaction does not Exist

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,645

Client created Cash Receipt transaction and applied to Sales document, however the system crashed.  When returned to the system the following issues were encountered:

When I tried to find the entry using the receipt number (020296781), it said that "You cannot edit transaction that has been posted".

However, it looks like the "entry" got applied to the invoice as when I tried locating the entry through the invoice, it said that "This document does not exist".

Investigated RM20101 RM Open and found the transaction SALES001 as expected

Investigated RM20201 RM Open Transaction Appy - and found APFRDCNM (02096781) and APTODCNM (Sales001)

So it appears right. However when investigating in the application, open Transaction by Customer, select the Sales doc, see the Cash Receipt attached, however when you click on the Cash Reciept for details, says that the document does not exist.

Investigated the HISTORY tables and no record of the SALES001 or the Cash Receipt are found.

I know i need to remove them Case Receipt but  need to make sure I am getting the entire record when I remove it.  Plus what is the next step that will allow us to re-enter the Cash transaction and apply it correctly.

Thanks. 

Categories:
Financial Management
  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Cash Transaction does not Exist

    Typically the message "this transaction does not exist' is due to the RM Keys record missing in the RM00401 table, as Gavin already suggested.  You can take a current backup and put it in a TEST company and run check links on the Sales series and see if check links recreates the missing record.

    If you need to remove it, typically you can run the "ALL RM' script for the cash receipt and remove all the records for it as listed in those script results (RM00401, RM10201, RM10101, RM20201) and then update the CURTRXAM amount in the RM20101 on any invoices or documents it was applied to, so you can apply to them again.  Then reenter the cash receipt and apply it again.

    But again, check links should clean it up for you too, but be sure to always do that in a test company first to see what it does and review the report to see what else it did and make sure you agree, as you cannot reverse what it did.

    Cheryl Waswick

    Microsoft Dynamics GP Support

  • Gavin Profile Picture
    Gavin 2,331 on at
    RE: Cash Transaction does not Exist

    Hi,

     

    Is the cash receipt present in the RM Key table (RM00401) or RM10201 (RM Cash Receipt Work)

     

    I suspect this is the case which would mean removing from the RM20201 and RM00401 (and possibly RM10201) and then running "Tools > Utilities > Sales > Reconcile" on "Outstanding Document Amounts" on that debtor to correct any unapplied amounts.

     

    You could also use the script here (https://stackoverflow.com/questions/1796506/search-all-tables-all-columns-for-a-specific-value-sql-server) to search all RM tables to see if the document number 020296781 exists in any other tables. (I usually add "and TABLE_NAME like 'RM%'" to the script so it only searches RM tables i.e. see below )

    pastedimage1641976324985v1.png

     

    If it does you can check and remove from those tables as well. Hopefully you'll then be able to re-enter the cash receipt.

     

    As always take a backup prior to removing any data.

     

    Hope this helps

     

    Thanks

    Gavin

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,768 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,985 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans