Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AR can't apply cas...
Microsoft Dynamics GP (Archived)

AR can't apply cash receipt

(0) ShareShare
ReportReport
Posted on by PaulaCam1 1,005

I have entered a cash receipt an posted the transaction.  When I navigate to the Apply window and try to apply the payment I receive the following message:

You can't choose this document because it is part of a recovered batch or is still in the process of posting.

The cash receipt is availabel in the deposit entry window as well as in the GL in the cash account and AR accounts.

I have run a check links and a reconcile and I still receive the same message.  If I try to void the transaction, thinking that I could reverse it out and reenter, I receive the same message as above.

the transaction is in the RM10100, RM10201 table, the CM20300 and the GL20000

Can anyone advise as to how to proceed to correct?

Thanks,

Paula

 

 

*This post is locked for comments

  • Dedi Hermawan ZR Profile Picture
    Dedi Hermawan ZR 85 on at
    RE: AR can't apply cash receipt

    Hello Paula,

    try this one

    delete a

    --select a.DOCNUMBR,b.DOCNUMBR,a.CUSTNMBR,b.CUSTNMBR,a.RMDTYPAL,b.RMDTYPAL

    from RM10201 a

    inner join RM20101 b on a.DOCNUMBR = b.DOCNUMBR and a.CUSTNMBR = b.CUSTNMBR and a.RMDTYPAL = b.RMDTYPAL

    where a.BCHSOURC = 'XRM_Cash'

  • Verified answer
    Leo J Profile Picture
    Leo J 35 on at
    RE: AR can't apply cash receipt

    This problem is resolved by deleting the transaction from RM10201.

  • Suggested answer
    Biser Marinov Profile Picture
    Biser Marinov 30 on at
    RE: AR can't apply cash receipt

    What I've found that works in these circumstances (incl. Credit Notes) is:

    -- update RM10301 set RMDNUMWK = 'yourdocnumbr_' where RMDNUMWK = 'yourdocnumbr'

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: AR can't apply cash receipt

    It seems this comes up on an irregular basis for us also - trying to determine the cause - some interruption  that prevents the post from fully completing? - maybe posting level transaction and user didnt close the entry window?   The problem may be the GL batch is stuck as well as the RM entry - the fix I have found was resetting the GL batch status and, if its still an issue with the RM transaction stuck with this "you cant choose this...",  try running a checklinks on the Receivables Trans Open - in our latest instance checklinks cleared out a user id record in the RM10201 table and it corrected this error.  I suppose the table(s) impacted all depends on exactly when/where the interruption occurred.

    I think its best to always use the checklinks first - rather than SQL table updates - only use SQL as a last resort and when you are confident of all the tables.

  • Suggested answer
    quattr0 Profile Picture
    quattr0 185 on at
    RE: AR can't apply cash receipt

    You had a posting corruption on the invoice that you tried to apply against the payment.  If the invoice was posted, you could remove the record, the invoice, in RM10301.  This works for me.

  • Arayan Sinanan Profile Picture
    Arayan Sinanan 65 on at
    RE: AR can't apply cash receipt

    I know that this reposnse is very late however have you tried the following.

    **working knowledge of SQL is required**

    If you know the batch id (BACHNUMB) Run the following query against the SY00500 Table within your company db Where BACHNUMB = the bach you are looking for.

    Once you obtain a result get the values for the following fields MKDTOPST and BCHSTTUS.

    Ideally you want to see all zeros for each of these feilds for the batch in question. If it isnt set MKDTOPST and BCHSTTUS = 0.

    Once this is completed the batch should be available now for you to print and edit list from or try and post once more.

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at
    Re: AR can't apply cash receipt

    There is not Batch in the Batch recovery window to bring back to the transaction entry window.  

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    Re: AR can't apply cash receipt

    Tools >> Routines >> Batch Recovery will allow you to recover the batch. If it can be posted it will be otherwise it will be available via the transaction window.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans