Payables batch didn't post through the GL

(0) Share

Report

Posted on by Community Member

Why would a payables batch not post all the way through the GL, aside from being set to post to rather than post through? The system is set to post through the GL and we can only post batches in the sub-ledgers, we can not post individual transactions. This has happened a few times and I am wondering what would cause it to happen. There are no errors in the batch (accounts are active, correct accounts used, transactions balance), so we are able to post it in financials. It just gets stuck there for some reason. I'd like to know if this is just a glitch or something we can avoid happening in the future.

Thanks,

Kelly

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Kelly,

Have you checked the posting window by selecting origin( select the type of transactions you are posting on payable) on posting setup window and see post through general ledger files is ticked.

Administration >> Setup >> Posting >> Posting

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Like I said, the set up appears to be correct and it does not happen all the time. We only enter and post payables transactions one way.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (2)

Report

Kelly have a look at the security of the user that this happens to - if there is a single user you can identify - if they don't have Finanical Posting then that might be the issue.

Another issue that you may encounter could be related to process overload - if you have multiple batches hitting the GL at one time, I am wondering if it is possible that some of the post automatically while others don't make it?

More of a couple of questions rather than answers, but, have to start thinking outside the box to get to the bottom of this.

Was this reply helpful? Yes No
Rich W 25 on at

Like (1)

Report

I see this is a really old question now but today we had a problem where the Payables batch wouldn't post. No errors displayed. It seemed to finish okay but no report came up. Nothing in the GL.

Another user at around the same time was getting a message saying "Unable to Generate a voucher number"

As it turns out, it was fortunate that this was reported at around the same time. When comparing the next voucher number in Payables Setup Options to the largest voucher number used in our database, it was way out of sync.

Reseting the Next Voucher Number to one larger than the largest corrected all the issues we were having.

I'm guessing then that the process of Posting the Payables Batch must create vouchers and it could not.

So, use this query to find the biggest voucher number used in the system:

select max (CNTRLNUM) from PM00400 where CNTRLTYP = 0

and then go to:

Tools->Setup->Purchasing->Payables

Click options and update the Next Voucher number to be one bigger than what the query returns.

Was this reply helpful? Yes No