Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Payment Application - ...
Microsoft Dynamics SL (Archived)

Payment Application - payment unapplied

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Has anyone ever had a problem with applying a payment to an invoice?  The payment seems to be posted to the customer however the payment is showing as an unapplied balance.  The batch was posted and I'm not sure what to do.  On the aged AR report, the customers balance is showing as zero but it's showing me the invoiced amount of $15K and the payment application amount of -$15K.  It seems to be stuck because usually it wouldn't even show up on this report.  Thanks for any help.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Application - payment unapplied

    Great, I'll give this to IT.  Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Application - payment unapplied

    Management Studio/Query Analyzer is something IT typically works with.

    When you have a current backup:

    begin tran

    delete from artran where drcr = 'u' and  and custid = 'whatever' and refnbr = "payment number"

    Change the "payment number"  to the right number and 'whatever'  to the correct custid.

    If a single row is deleted then enter an run:

    COMMIT

    or if uncertain, enter and run:

    ROLLBACK

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Application - payment unapplied

    The batch was posted.  Management Studio...is that something I can do or should my IT dept. get involved?

    Thank you for the help Elaine.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Application - payment unapplied

    Bring up the batch number referenced in the error message.  If the batch is on hold or balanced, you should be able to apply the amt and release the batch.  If the batch is unposted or posted, then an update will need to be made in Management Studio.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Application - payment unapplied

    Thanks for the response Elaine.  I tried what you told me and the payment was there to select, however; when trying to select it I got the following message - "This payment/memo is already applied in batch #".  

    I don't understand the message though because when looking at the batch the payment shows as unapplied.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment Application - payment unapplied

    Hi Kea,

    You can enter a payment and leave it unapplied.

    Create a new AR payment application batch. Enter the customer ID.   F3 on the payment refnbr.   You should see the payment.  Once selected, there should be an unapplied amt.  If so, apply it to the invoice that is expected to display.

    If neither the invoice or payment are available, that could mean that the payment or invoice is in another unreleased payment application batch.  

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