Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Overapplied Sales Documents

Posted on by 129

Hello,

I have applied payments/returns against an old invoice but unfortunately it is overapplied now (invoice has a negative balance). How do I remove this overapplication or resolve this matter? I'd rather it not hit the GL. I see the payments/returns which need to be removed, but I am unable to unapply them.

Thank you.

*This post is locked for comments

  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    RE: Overapplied Sales Documents

    Very helpful - thank you.


    When you void an invoice, will it automatically delete/remove all the payments/returns applied to it? That's what I'm ideally after. I don't want to void this and for other invoices to now become open because payment has been applied to other invoices. Not sure what happened a week ago, but this appears what transpired.

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Overapplied Sales Documents

    Have you done Check Links on you Receivables data?

    Microsoft Dynamics GP>Maintenance>Check Links>Sales

    Receivable Transaction History Files

    Receivable Open Transaction Files

    This could take a extended amount of time depending on transaction numbers.  Have a good backup before doing this.

    To Void a posted transaction:

    Transactions>Sales>Posted Transactions

    Tim

  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    RE: Overapplied Sales Documents

    Is there any way to run an AR Aging report to EXCLUDE an old invoice which is showing up on my Aging? I have many payments applied against it, but it has a negative balance. The payments are fairly recent, but the invoice year is prior to 2017. If there's some way to just exclude the problematic invoice/payments from my Aging, that may work.

    Thank you.

  • accountinguser2018 Profile Picture
    accountinguser2018 129 on at
    RE: Overapplied Sales Documents

    Thanks!

    I worry PSTL may be too powerful and I shouldn’t have access. How would I void? Within Sales module? It’s 2 small payments which are in History. I voided 2 negative payments yesterday and thought a prior issue had been resolved, but now this issue has popped up.

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Overapplied Sales Documents

    PSTL has the Historical un-apply tool.  It works.

    Voiding is an option (not a very nice one).

    Tim

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans