Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / AR Invoices showing on...
Microsoft Dynamics SL (Archived)

AR Invoices showing on Aged Report but not on Payment Applcation

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

 I created an invoice using "Invoice and Memo" in the AR module.

The invoice turned out to be wrongly put in and now I created an Credit Memo using "Invoice and Memo" to correct the wrongly put invoice.

I then tried to apply that CM to the invoice, so as to clear it off the AR Aging report, us the "Payment Application" screen in the AR module.

My question is - When I went to apply the CM to that invoice, the invoice was not in there to be applied to. I see the invoice (as well as the CM) I created on the AR Aging but not on the "Payment Application" screen and. Basically I can't find the invoice to apply the CM to when I use the "Payment Application" screen. 

I've doubled check that it is the same customer. 

Can someone please advise what the best solution is?

Thank you.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: AR Invoices showing on Aged Report but not on Payment Applcation

    Many Thanks

    I found the Batch where my documents are selected for payment.

    Problem Solved

    Kind Regards

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: AR Invoices showing on Aged Report but not on Payment Applcation

    There are a couple of different queries you could run.

    The first is to look at the AR document that you want and look at the AppBatNbr field.  This field will tell you what payment application batch has a pending application to this invoice.

    Select AppBatNbr,* from ARDoc where custid = 'xxxxxx' and refnbr = 'yyyyyy'

    Or you can look ar ARtran for SiteId = to the invoice number.  the BatNbr field will tell you what pending payment application batch touched this invoice.

    Select * from artran where custid = 'xxxxxx' and siteid = 'yyyyyy'

    However, what you should do is open the payment application screen and press F3 on the batch number field and scroll through the PV list looking for a batch that has a status of hold.  It is most likely that someone started a payment application batch and applied something to this invoice but never released the batch (left it with either a no action status or hold status).

  • Community Member Profile Picture
    Community Member on at
    RE: AR Invoices showing on Aged Report but not on Payment Applcation

    Hi

    I have the same issue and I cannot find any application batch in the release batches screen. Could I check trough SQL if the invoice is selected for payment in any batch?

    Thanks in advance

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: AR Invoices showing on Aged Report but not on Payment Applcation

    The most likely cause of what you are describing is that another, un-released or suspended, payment application batch has been applied to this voucher that you are not seeing.  Look for a suspended batch on the release batch screen and look for a payment application batch that has not been released.

    The payment application batch will not show an invoice that an application to it is in progress.  However, the aging report will show that invoice as open since the application has not been released.

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

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 > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans