Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Applying Sales Document
Microsoft Dynamics GP (Archived)

Applying Sales Document

(0) ShareShare
ReportReport
Posted on by Justin N 245

I was applying sales to a payment of by clicking of the sales in the "Applying Sales Document" module. About halfway through my dynamics froze and I had to restart it. When I went back into the module, everything was still click off, but my original amount was showing nothing was applied. When I unclick ed everything, It now shows an unapplied amount that is twice the original amount. I attempted to void the transaction and start over, but I was unable to. Is there any way to bring my unapplied amount down to the amount of that was paid? Thanks in advance.

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Applying Sales Document

    If you delete the apply document from backend, it will shows on GP "Apply Sales Document Amount" window, but the applied amount of that payment still shows on the old values. You also need to verify and update the current transaction amount in RM20101 table for that particular payment.

    Normally correcting issues on backend is the last steps for us. First try to run the reconcile for the customer outstanding documents and check the apply sales documents. If the issues still there, then try the backend solution.

    Hope this helps!!!

  • Suggested answer
    Mohamed El-Tohamy Profile Picture
    Mohamed El-Tohamy 305 on at
    RE: Applying Sales Document

    Dears,

    1. Open SQL management studio.

    2. Click on RM20201 table.

    3. Then add your customer ID in the "Filter" in "CUSTNMBR" row, then run.

    4. This table contains all the applied docs if your payment one of them highlight the line then delete and you will find it open in the "Apply Sales Document"

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Applying Sales Document

    I am also experiencing the same exact issue. Does anyone know any trick to fix this issue?

  • Justin N Profile Picture
    Justin N 245 on at
    Re: Applying Sales Document

     

    Dan, I tried both of these options and still no luck. As you can see by the image above, I have applied the original $211,268.50, but it is still showing an inapplied amount of $144,857.75.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Applying Sales Document

    I would first run check links on the open receivables files.   Then try a reconcile of the customer for outstanding amounts.   As always, be sure to have a back up prior to doing maintenance.  

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans