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) / Accounts Receivable Ou...
Microsoft Dynamics SL (Archived)

Accounts Receivable Outstanding Payment Application

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I'm having a hard time figuring out what to do with an outstanding payment application. I have a 17K outstanding payment application in our AR for a customer. The payment was originally released and then voided by one of our employees. Instead of reapplying the payment correctly in payment application, she created a new PA document and applied the payment - so now I have the original 17K payment application sitting in AR as a credit. What would be the best way to back this out? I'm worried if I do a small credit right off it will hit the cash account which is already in balance.

*This post is locked for comments

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

    When you say that the original payment was "voided" it sounds like the person simply used the application inquiry screen to reverse the selected application (the default option setting) as opposed to using the void selected application.  that would leave this payment as an open item.  If you use the application inquiry/reversal screen, select this payment and void (NSF) to payment then that will clear the payment.  However, you stated that cash is in balance already which does not make sense if this payment is still showing with an outstanding balance.  If cash is, indeed, in balance then you would not want to perform the NSF action on this payment else that would reduce cash.

    I believe you need to run down the situation a bit more before taking any action.  Use the application inquiry/reversal screen to look up this payment and see if the grid portion shows both the payment and the reversal of that payment.  If both show then the person did use the NSF action on this payment and the original should not have a balance on it.  You might want to see if the NSF batch is actually posted yet or not.  Note that the application inquiry/reversal screen does not allow you to specify a posting period so the batch related to an NSF action defaults to whatever the current AR period is set to when the action was taken.  This could mean that the NSF batch is in a different posting period then the original payment batch (e.g., the payment batch was posted to a future (relative to the current AR period) and the NSF batch is in the current AR period.  Still, if the NSF action was used, the original payment should have a 0.00 balance.

    Let me know what you discover and then we can look at the best course of action to resolve the issue.

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,348 on at

    Hi Rick

    I have a similar situation where the NSF option was chosen.  The user is stating that there is a balance shown in the TB and statement for the customer but it should be 0.00 after using that option.

    In addition, if she tries to select the document a message indicates that the payment is already selected in a payment application batch.  But so far the batch cannot be located.

    Any ideas on what may have gone wrong or any suggestions on how to fix this issue?

    Thanks for your assistance.

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,348 on at

    I was able to resolve this issue when I realized that there were some stray records in the APTran table.  By deleting those records the user was able to reapply the payments that were voided.

    Regards

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Lisa,

    The first thing I would do is run a query against the invoice and look at the field ApplBatNbr.  This field will contain the batch number of the application batch that is set to pay some or all of the document.  When a payment application batch is created and items applied to documents, this field is set in the documents and is not cleared until the application batch is fully released.  While this field is set you will get the message you indicated.  If the value in that field represents a batch that does not exist then you can clear this field and the ApplAmt field and the document should then be available.  However, you should run a separate query against the batch table to make sure the indicated batch does not really exist.  Remember, that batch could have been created by a screen other than the payment application screen.  Looking at the Crtd_Prog field in the batch table will tell you what screen created that batch.

    Having said the above, your post is not clear as to whether you are talking about an invoice/debit memo that should have a 0.00 balance or a payment that should have a 0.00 balance due to an NSF action against that payment.  If the later, then the above does not apply.  In that case, you need to find where the payment is showing as part of an application batch.  In that case there will be one or more ARTran records where the refnbr field is equal to the payment reference number and the siteID field will not be blank.  The batnbr field of that ARTran record will indicate the batch number using that payment.

    Let me know if none of the above resolves your issue or you need more assistance.  My clients use the NSF action with some frequency and have not had your situation so, as far as I know, there is not an issue with doing an NSF action.  As you probably know, the Application/Inquiry screen does not allow you to set the posting period of the corresponding transactions (if defaults to the current AR period) so, when you say the trial balance, if you mean the period sensitive trial balance then make sure you run that report for the correct posting period.  Or, use the regular trial balance report to examine the document in question.

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