Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

unapplied/suspended payment applications

Posted on by Microsoft Employee

We have two payment applications that show up in the customer history.  They cannot be applied to an invoice because the system is treating them as having already been applied, however it appears that the application applying them has been suspended and I can't access it to clear it.  When I run a quick query on them, the applied batch number has not been cleared out.  How can I get to these batches to properly apply these payments to the invoices?  Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    Thanks for you help.  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    Leah,

    If you are opening the payment application screen and using the PV list to look for that batch and it is not there then I suspect the batch was created but not released and then it was deleted.  The deletion should have removed the application information from the original payment document but it appears it did not which suggests some of issue was encounter during the deletion of that payment application batch or someone with initialize mode rights went to the GL journal transaction screen, switched the module to AR and then deleted the batch on the GL side (which will remove it from GL but would not clear the fields in question.

    So, now we have a situation where we need to clear those fields in the original payment documents and the only way to do that is with a SQL update statement.  Once cleared, you would then be able to apply those payment documents.  However, before doing that, we would want to make sure that no other pieces of that batch still exist in the system because those would also need to be cleared up.

    So, there are going to be some SQL queries that need to be run by someone at your end that has rights to the SQL Management Tool.  Do you have such a person?

    Here are the queries that need to be run:

    select * from artran where batnbr  = '006530"  we want this to come up with no records

    select * from aradjust where adjbatnbr = '006530'  we want this to come up with no records

    select from batch where module = 'AR" and batnbr = '006530'  we want this to come up with no records

    if all 3 of the above come up empty then you can execute:

    begin transaction

    update ardoc set applamt = 0, applbatnbr = '' where applbatnbr = '006530'

    note the number of records affected.  it should be 2 based on what you have said here.  If it is 2, execute the following:

    commit transaction

    if it is some other number, execute the following to rollback the change and we need to discuss:

    rollback transaction

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    Where can I go to find batch 006530  I looked in payment applications and it does not exists.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    Thanks for the added information.  So, we need to determine the status of payment application batch 006530.  This payment was originally entered in batch 006521 but not applied in that batch.  So, the payment is released but the application of that payment in batch 006530 has not completed.  Make sure that payment application batch has a release now status and is still not out there pending release.  Based on your data in the payment document, it sure appears that batch 006530 has not been released.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    The batch is staying status 1.  We don't use auto-apply batches.  Here is a shot of the quick query:

    Batch Number

    Released

    Document Status

    Reference Number

    Original Document Amount

    Document Balance

    Document Type

    Document Description

    Company ID

    ClearDate

    Create Date

    Last Update Date

    Statement Date

    Bank Account

    Bank Subaccount

    Account Number

    Applied Amount

    Applied Batch Number

    Applied Batch Sequence

    Batch Sequence

    Created Program

    Current Period Document

    006521

    1

    1000626213

    35000

    35000

    PA

    MCH

    1

    1/6/2015

    1/7/2015

    5/18/2015

    10060

    000

    35000

    006530

    1

    1

    08030

    0

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    Leah,

    Sorry, when I read "suspended" I assumed you were referring to a batch status and not a general term.  So, to clarify what you have said, you ran a quick query looking at the invoices which were supposed to be paid and those invoice documents have a batch number in the ApplBatNbr field and an amount in the ApplAmt field?  If so, what status is the batch or batches that you see in the ApplBatNbr field?  Do those payment application batches even exist or were these auto-apply batches?  I need additional information in order to assist with what the next steps might be.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    I had already thought of that and the batches do not show up on the “Release AR Batch” screen.  

    Thanks

    Leah

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: unapplied/suspended payment applications

    Leah,

    The first step is to see if you can release that suspended batch.  Sometimes a batch will end up suspended if the release process ran into an issue printing the batch control reports.  Open the Release AR Batches screen and select the suspended batch and try releasing it.  If the process issues the process completed message then it released and you should be good.  If the process issues a message that an event log entry was made then you need to open that event log (process id 08400 with today's date) and find out what is causing the batch to not release.  Look for a line in the event log that includes "error".  If you are unable to determine what the error means, post it back on this forum entry.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans