Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

(0) Share

Report

Posted on by WendyT

140

I have a Purchasing batch that currently shows No Transactions and will not let me post. However, when you drill into the batch you can see that there are several receipt transactions entered there.

The batch will not print, will not process through Master Posting and does not show up in batch recovery. How can I process this batch and the transactions through?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

Please have a look on the below my blog.

dynamicsthoughts.wordpress.com/.../user-idbatch-id-stuck-while-postingreconcilingdeleting-etc-in-dynamics-gp

Hope this helps!!!

Was this reply helpful? Yes No
WendyT 140 on at

Like (0)

Report

Thanks for this, however for this batch, both the MKDTOPST AND BCHSTTUS are both already set to 0.

Updating this does not change anything.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Have tried to run the Checklinks for Purchasing transactions?

Was this reply helpful? Yes No
WendyT 140 on at

Like (0)

Report

I have not as I currently have close to 100 users on the system and do not have a planned outage window for at least another week. Looking for a way I can force trigger it so I don't require an outage.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

When you print the edit list does it list any errors?

Was this reply helpful? Yes No
WendyT 140 on at

Like (0)

Report

Edit list will not print. I receive a system message saying there are no transactions to print.

Wonderful little loop to get caught in!

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

So the SY00500 table is messed up for this batch. Do you have access to SSMS? If you could locate the record containing this batch and change the field SY00500.NUMOFTRX to something other than zero, that will allow you to print the edit list.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

If not, then check links is the only way to correct this. You could also write your own script to correct the transaction count but setting it to a non-zero value will get you the edit list.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

I'm with Richard. If you cannot run Check Links, just change the value of the field he has identified and you should be good to go.

Kind regards,

Leslie

Was this reply helpful? Yes No