web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

    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

    Many Thanks

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

    Problem Solved

    Kind Regards

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans