Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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 on at
    RE: Payment Application - payment unapplied

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

  • Community Member Profile Picture
    Community Member 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 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 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 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 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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans