Error when posting Payables batches

(0) Share

Report

Posted on by csherwood

I am currently receiving an error when i go to post a saved payable batch. " A Payables Mangement transaction that was interrupted during normal processing has been recovered. Use the payables Mangement transaction entry windows to continue processing the transaction."

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Rosemary 10 on at

Like (0)

Report

Hi,

Has the batch been recovered?

Are you able to view the batch?

Was this reply helpful? Yes No
csherwood 20 on at

Like (0)

Report

No it is not in a recovery batch and you can see that it is a batch when you open the transaction by document number window however when you drill down on the actual batch there are no transactions. It is really strange.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

If you go Tools>Routines>Master Posting choose Purchasing is it there?

Was this reply helpful? Yes No
csherwood 20 on at

Like (0)

Report

No it isnt in there either.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Are you able to view transaction via Smartlist or SQL?

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

Have you tried to run checklink against payable. If that doesn't help, please logout all users then run the following on SQL.

When all users are logged off from Microsoft Dynamics GP, these tables will not have any records in them.

Clear the stuck records by using any of the following appropriate scripts.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

On the company database please check the following table as the batch which is having problem.

SY00500

Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post or select in Microsoft Dynamics GP.

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

Was this reply helpful? Yes No
csherwood 20 on at

Like (0)

Report

Well it moved the transaction but did not completely fix it. Now the transactions that were in the batch are "WORK" origin. They arent in a batch now they are just kind of hanging out there. You can see the transaction when you search "transaction by document number" but when you search by vendor they don't appear. However when running a payables trial balance they show up on the report.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Hi,

Can you do a print screen as to 'hanging out there'? Is it that it was not assigned to a batch?

Was this reply helpful? Yes No
csherwood 20 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

You need to select and post the batch first to see it on inquiry window.

Was this reply helpful? Yes No