Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / AR Payment Application...
Microsoft Dynamics SL (Archived)

AR Payment Application Batch appears to be in limbo

(0) ShareShare
ReportReport
Posted on by JenWal 750

Hello!

I'm having an issue with an AR Batch that appears to be in limbo. From what Accounting has told me, nobody interrupted the process when Payment Application was running and no errors were received. Here is what I'm seeing:

Batch 534353.

In ARTRAN I see all lines for this batch. First thing I notice is that the DrCr column is all at U's for Unposted. The Rlsed field is at 0.

I query the BATCH table by batch id. The batch has a status of C (for Completed, right?) and Rlsed is at 1.

I query GLTRAN by the batch id and no records are found.

I searched CustomerSource and found KB 864408 - Researched the Missing GL Records solution (5618).

Problem:

I can go into Initialize mode and I select Journal Type of AR. The batch 534353 does not exist anywhere in the batch list. For funsies I tried looking under a few other modules and no where in there can I find batch 534353. I concluded that obviously the records are missing from GL, however I can't add detail lines to a batch that isn't there! lol.

I'm wondering if I set the BATCH table record back to status of U and the Rlsed column to 0 and run it again - Would this cause any issues? How is it possible the BATCH table thinks this one processed and ATRAN doesn't?

Please let me know the best route to get this fixed and if you have any ideas how it happened in the first place. Thanks!

-Jenny

*This post is locked for comments

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Hello to all!

    We ended up opening a case after the suggestions here and various other things we found in KB articles didn't work for us (Thanks to all who suggested!)

    The resolution to this issue was to change the batch status to B and just delete the transactions with the drcr of U, set the applbatnbr to blank on the ardoc records, and they just apply the payment in a new batch.

    delete from artran where drcr = 'u' and batnbr = '534353'

    update ardoc set applbatnbr = '' where applbatnbr = '534353'

    This did the trick!

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Figured out the prior JE issue - I wasn't in Init Mode and hadn't selected my module. Got past that. :-)

    Once I did that though, the batch was completely missing from the list. What we ended up doing was removing the 10 lines from the ARDOC table and manually writing off the amounts of the payments. Probably not the best way to do this, but it will be good enough to close our books for the period.

    Should we see this again, we'll explore additional methods. I also happened upon the ARDebug script that was from a prior case with a different AR issue, and it flagged the same items that we corrected using the 21795 resolution in KB 872705.

    Thanks again for everyone's help! I think we are good for now.

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Found some additional information in KB 872705 mbs2.microsoft.com/.../KBDisplay.aspx

    Appears these records are showing as described in the resolution 21795. Working through that one now. I'll update again to let you know if this does or doesn't do the trick!

    -Jenny

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Hi Ricardo!

    I think I'm missing something here. My AR batch is number 534353. When I tried to look into the GL Journal Transactions screen, this is not an available selection in my PV list, nor can I hard key the batch number in. Checking both of these in Customize Mode, it is telling me that both the Payment Application screen and the GL Journal Transaction screens are pulling the batch number from Batch.batch. Is there another field in either ARTRAN or GLTRAN that I am missing? Example - From Project the batch numbers there are not the same as the ones in the financial modules, so you have to use a separate field with a reference number to find them. Is that what I need to be looking for in this case, too?

    I apologize for the obvious, but I am not fluent with the financial modules and at this point am grasping at straws to try to get these line items moving. It's holding up our month end and aside from somehow re-creating and applying the lines, I have no idea what to do.

    Thanks for all of the help!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Payment Application Batch appears to be in limbo

    Status = C al rlsed = 1

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AR Payment Application Batch appears to be in limbo

    Hi When you have this combination

    Status = C and Rlsed 0 the transaction not create a journal transaction

    "I query the BATCH table by batch id.

    The batch has a status of C (for Completed, right?) and Rlsed is at 1. "

    And for this you can see the batch on the jornal trasnaction screen.

  • Fujimi DB Profile Picture
    Fujimi DB 275 on at
    RE: AR Payment Application Batch appears to be in limbo

    Did you try changing the status of the Payment Application batch to 'B'?

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Well, that didn't do it either. Looks like the status change does reflect as expected, however the drop down on Payment Application is now disabled completely so we can't do anything with it to try to reprocess. It's also not sitting in the Release AR Batches screen.

    Our other thought was to run AR Integrity Check, however we have several processes that run at various points during the day so even by narrowing it down to the Payments only, we have no idea how long it would take to run as it would likely interfere with these other processes.

    Looks like for now we will be making the changes back to be Completed and Released and see if there is anything else we can do. This is going to hold up our month closing, so I have to figure out something by Monday.

    Thanks for your suggestions!

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Having a heck of a time trying to figure this one out.

    I can't get hits off of anything on the Payment Application report. Tried every type of refnbr and batnbr there is, and it's not pulling anything. I get a giant long list for the applied batch number, but none of the entries I'm looking for are in there.

    In the Customer Maintenance / Customer Activity Screen I see the lines with a doc balance of negatives on the payment lines and the same negative amounts in the DocBal in Orig Cury column. It's like the payments aren't being applied or regognized at all, so they will never 0 out.

    I also ran the Release AR Batches - Batch Control Report for batch 534353 and there are no debit or credit amounts listed. Not even 0's or anything. Just no amounts on there at all, so the Batch Total for both debits and credits is 0.

    Looks like it didn't even start to apply anything for these entries. We are going to roll back the batch from the Batch table and try to run it again. I'll let you know what happens!

  • JenWal Profile Picture
    JenWal 750 on at
    RE: AR Payment Application Batch appears to be in limbo

    Gotcha - I was thinking you were asking for screen shots. I was going to clean them all up after I knew you (or anyone else), had taken a look at what we are seeing. :-)

    I'll run down that ref number and see what that looks like. Thanks!

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