AR Payment Application Batch appears to be in limbo

(0) Share

Report

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

I have the same question (0)

All responses (15)

Answers (0)

Fujimi DB 275 on at

Like (0)

Report

Hi Jenny,

What does the Payment Entry batch look like?

Thanks,

db

Was this reply helpful? Yes No
JenWal 750 on at

Like (0)

Report

Hello!

The Payment Application batch shows a status of C on the PV List:

The full screen is pulling in 2 lines that look like this in form view:

Was this reply helpful? Yes No
JenWal 750 on at

Like (0)

Report

It cut off the rest of my reply - Trying again:

Was this reply helpful? Yes No
JenWal 750 on at

Like (0)

Report

And the last part:

There are no customizations on this screen. Due to the size constraints allowed for photos, I had to cut off the header portion of the screen to get it to work.

Thanks!

Was this reply helpful? Yes No
Fujimi DB 275 on at

Like (0)

Report

Sorry, but was the payment batch released okay and does it look correct? You should be able to find it using the reference number N001803859.

I agree with your initial idea that you should reset the status of the batch and (re-)release this payment application batch. However, it might be a good idea to make sure the payment batch is fine first. Please post the result if you do decide to follow this route.

On a side note and as merely a suggestion, you might want to delete the posts with the pictures since they show potentially sensitive information. I should have been clearer about the information I wanted to see.

Thanks,

db

Was this reply helpful? Yes No
JenWal 750 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
JenWal 750 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
JenWal 750 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Fujimi DB 275 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No