Open Forum

Expand all | Collapse all

Unapplied Amount Error

  • 1.  Unapplied Amount Error

    Posted Jun 22, 2017 04:46 PM
    Friends,

    While applying funds received we ran into an error where when we unapply the full amount of the receipt the unapplied amount doesn't match the original amount. We have played with restarting GP and reapplying amounts, however none of this works. I then attempted to void the original transaction in order to post a duplicate without the error. At this point I received the error "Unable to void this document".

    I then attempted to run check links on the Sales Series, but it was of no use.

    Images are below regarding the failure to void, as well as Original Amount and Unapplied Amount Differential. I assume this means that something is locked in a table and needs to be fixed, but I lack the technical know how to go about this without further assistance.






    Thank you for your time!

    Nick

    ------------------------------
    Nick Stage
    University of Minnesota Physicians
    Minneapolis MN
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Unapplied Amount Error

    GOLD CONTRIBUTOR
    Posted Jun 23, 2017 07:01 AM
    Did you try running a sales reconcile (under routines) on the customer id?  Normally that would clear up any discrepancy like this.

    ------------------------------
    Jim Harris
    Director of Information Systems
    ExamWorks, Inc.
    Atlanta GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Unapplied Amount Error

    Posted Jun 23, 2017 09:16 AM
    Worked Perfectly!!!!

    Thank you!

    Quick note - it was under Tools > Utilities > Sales > Reconcile

    From there I just selected Outstanding Document Amounts and hit Process.




    ------------------------------
    Nick Stage
    University of Minnesota Physicians
    Minneapolis MN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Unapplied Amount Error

    Posted Jun 23, 2017 08:50 AM
    Nick,
    You either have a phantom record in your RM apply table or your RM keys current transaction amount is not updating with the checklinks.  You can try to go old-school on this one for a quick fix:

    1.  Enter a dummy credit memo for the amount that shows as the current unapplied and apply to the invoice to get the invoice fully applied.  (Your window showed all of the invoices for the customer - there is probably just one or two where the current transaction amount and the original amount do not match - see if you can locate.)

    2.  Run paid transaction removal just on that customer to get the invoice and dummy credit memo to history.

    3.  Re-enter what needs to be done.

    For the SQL fix required, you may want to contact your Microsoft Dynamics GP Partner for assistance.  We do have SQL experts at Implementation Specialists who can help if your partner needs to refer you.

    ------------------------------
    Heather Maneiro
    Senior Consultant
    Implementation Specialists (IS)
    Hawley MN
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role