Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Run Checklinks? -- Original Amount / Amount Remaining not matching up

Posted on by 6,775

A user is experiencing a cash distribution error in the Apply Sales Document window. The Original Amount and Amount Remaining do not match when amounts are fully unapplied. Amount Remaining (or Unapplied Amount) is greater than Original Amount.  Bank Rec processed the payment for amount indicated in 'original amount' field. I have clicked the 'Unapplied Amount hyperlink' and there are zero documents the payment has been applied to.

I have already performed a Reconcile - Remove Outstanding Documents and the discrepancy remains.

I am attempting to run Checklinks for Sales > Receivables Open Trx Files to see if that will do the trick. However, this is for a closed period. I assume we will have to reopen the closed period and run Checklinks for it to be effective, though I am not fully sure. Can anyone confirm?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Hello RL,

    That is great to hear!

    I wouldnt be able to tell you exactly why it happened in your case but usually it is caused by a system interruption of some sort such as a power loss or crash while saving/posting. You are correct, the Unapplied Amount shoud not be greater than the Original Amount.

    I have also seen this happen when a customer is using a 3rd party customized window when entering these transactions.

    You are correct, if the GL is off after running Reconcile for the AR module you may need to manually correct the GL by entering a manual GL entry to correct the accounts. There wont be any drill back between this manual entry and the Sales module but at least now sales and GL will be correct.

    If you still need assistance with the AR to GL balance after running reconcile I would recommend opening a support incident so that an engineer can take a closer look at it.

    I hope this helps!

    Best regards,

    Dan Moore

    Customer Online Technical Community

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

    We hope you get value from our new forums platform! Tell us what you think:

    social.microsoft.com/.../threads

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

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

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Thanks Daniel.

    It looks like running a Reconcile on the Outstanding Documents did the trick so that the fields reflect the accurate values for this customer's specific payment.

    My question is whether or why GP allows the Unapplied Amount to ever be greater than the Original Amount because in theory, that should never be valid, correct?

    Next, it looks like the GL balance does not reflect the same AR balance... but first, we will run a Reconcile for the AR module to GL, after we correct this specific transaction.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Hello RL,

    I have seen this happen before if some documents are applied and then unapplied and there is a disconnection to the server. The way we usually can fix this would be to run a Reconcile on the Customer from the Reconcile Receivables Amounts window (Tools | Utilities | Sales | Reconcile). You will want to run the reconcile on both Current Customer Information and Outstanding Documents Amounts, not sure if you did both. They do have to be run at separate times but can be run against just the one customer.

    As you mentioned, if reconcile does not fix the problem, then you can try to update (please make a backup before doing this) the RM20101 table to show the correct amount in the CURTRXAM (Current Transaction Amount) field. This field holds the Amount Remaining information. An update script would look like the following:

    update RM20101 set CURTRXAM = XXXXX.XX where DOCNUMBR = 'YYYYY'

    The XXXXX.XX will be replaced by the Amount Remaining and the YYYYY will be replaced by the Document Number.

    Best regards,

    Dan Moore

    Customer Online Technical Community

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

    We hope you get value from our new forums platform! Tell us what you think:

    social.microsoft.com/.../threads

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

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

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Reconcile & Checklinks did not resolve the error.

    After digging around, it looks like this is a common error in GP caused by network interruption or user crashing out of GP while entering or applying a cash receipt. This results in a corrupt record.

    My next step is manually adjusting the entries in SQL Management Studio in RM20101 table to reflect the correct amounts in 'Original Amount' and 'Amount Remaining' fields.

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Hi Melissa,

    We've attempted running the Sales Reconcile routine already but no such luck.

    Is the next step looking into SQL?

  • Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Run Reconcile on outstanding document amounts in the sales module (Sales - Utilities - Reconcile).  This should fix the unapplied amount.  I would run for hte specific customer(s) you are having the issue with.

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    Thank you Donnette, but documents are currently unapplied. I cannot seem to get the 'unapplied amount' balance to equal that of the 'original amount.' Normally, the two, if documents are unapplied, should read identical balances, but in my case, the unapplied amount is a larger value than the original amount. Not sure how this is possible, except that it may be a hiccup in GP. Any ideas?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Run Checklinks? -- Original Amount / Amount Remaining not matching up

    I had a similar problem.  Check links did not resolve.  There is a PSTL tool to unapply

    support.microsoft.com/.../855487

    You can use the RM Transaction Unapply tool in the Professional Services Tool Library (PSTL) to unapply documents in the history table and automatically move the records back to the open table even if there are discounts and/or writeoffs associated with the document in Microsoft Dynamics GP. Then, you can reapply the records as needed. Using this tool is an alternative to removing history and reentering data if records were applied incorrectly.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans