Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by 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

  • L Vail Profile Picture
    65,271 on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

    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

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

    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.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

    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.

  • WendyT Profile Picture
    140 on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

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

    Wonderful little loop to get caught in!

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

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

  • WendyT Profile Picture
    140 on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

    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.

  • soma Profile Picture
    24,410 on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

    Have tried to run the Checklinks for Purchasing transactions?

  • WendyT Profile Picture
    140 on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

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

    Updating this does not change anything.

  • Suggested answer
    soma Profile Picture
    24,410 on at
    RE: Purchasing Batch shows No Transactions but there are several receipt transactions in the batch

    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!!!

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans