Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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

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