Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

SOP Unapplied amount shows Double for the Original Amount - Apply sales documents

Posted on 1 May 2015 14:46:36 by 4,156

GP2013 computer crashed and now

  • A batch was created under Cash Receipts with amount 500,000
  • under Apply sales documents  Original amount shows 500,000 but now after turning back on 
  • unapplied box shows 100,000.00 double the original

 

I have run check links and reconciliation but no luck

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on 12 Jan 2016 at 12:47:53
    RE: SOP Unapplied amount shows Double for the Original Amount - Apply sales documents

    I have a sales doc in which credits and payment was applied and unapplied amount on the document is zero, but in sales module the balance shows as ($81.94).  And the transactions are from 2012 and this negative unapplied balance just appeared in 2015.  I've run checklinks and reconcile outstanding document amounts and it did not resolve the issue.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on 04 May 2015 at 12:22:56
    RE: SOP Unapplied amount shows Double for the Original Amount - Apply sales documents

    Mostly if you run the reconcile (Tools-->Utilities-->Sales-->Reconcile) for "Outstanding Documents Amounts', it will correct the applied/unapplied amount. If you already run and still facing the same issue, you need correct from backend.

    Run the below query to check the current transaction amount fields(CURTRXAM) value and correct by update statement.

    select * from RM20101 where DOCNUMBR = 'XXXX'

    Replace XXXX with cash receipt number or invoice number (if invoice unapplied is wrong)

    Hope this helps!!!

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on 04 May 2015 at 05:59:06
    RE: SOP Unapplied amount shows Double for the Original Amount - Apply sales documents

    Hi Syed,

    Which reconcile have did you run? As Steve has mentioned running the Reconcile and selecting "Outstanding Document Amounts" should resolve the mismatch.

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on 01 May 2015 at 17:43:37
    RE: SOP Unapplied amount shows Double for the Original Amount - Apply sales documents

    I would delete the cash receipts batch, including the cash receipt transactions, and then run the "Reconcile Receivables Amounts" routine for "Outstanding Document Amounts."

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