web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PMTRX batch question
Microsoft Dynamics GP (Archived)

PMTRX batch question

(0) ShareShare
ReportReport
Posted on by deanne917 2,035

We have a PMTRX batch in a printing status in the GL.  However, there is no batch in payables with the same batch # (PMTRX00005295).  Trying to figure out how this happens....does anyone have any suggestions?  Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Your posting settings for payables transactions must be set to "Post To" and not "Post Through" GL.  Therefore, that batch ID is created from a single PM transaction that was posted in payables.

  • deanne917 Profile Picture
    deanne917 2,035 on at

    tables show no batch in AP with that batch # - it's stuck in a 'printing' status on the GL side

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    hi Deanne

    the pmtrx number will be the audit trail code from A/P.  Go to the reports - purchasing - posting journals and plug that number including the pmtrx into the transaction journal report.  

    you should get back a transaction that as Frank implies was posted in the subledger with no batch and therefore is no longer in the a/p subledger to post.

    the printing status usually indicates a stuck / hung user.  Once the user logs back into that same company they will be prompted to complete processing.

    ian

  • deanne917 Profile Picture
    deanne917 2,035 on at

    I've already done this - the batch is NOT in AP.  I see the detail in GL10000 but nothing in AP.  

  • deanne917 Profile Picture
    deanne917 2,035 on at

    The GL10000 shows a posting status of 2.  

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    ruling out the obvious then we move to more off the wall answers.  Do you have users that would use oddball batch id's like PMTRX?

    does the last user (LASTUSER) or who posted (USWHPSTD) fields have values in them on the GL10000 table that you can see the batch in?  That will lead you at least to which user appears to be hung since the batch is stuck in printing.

  • deanne917 Profile Picture
    deanne917 2,035 on at

    yes - I'm finding that this transaction actually took place in Nov in AP.  It looks like the batch has been hanging there in GL10000 but the user went and manually made a JE to post the amounts in the GL.  The batch still hangs.

    The header part is still in GL10000 but GL10001 does not have the detail/line items.

    Is there a utility I should run to remove it from the GL10000?  (for audit trail purposes)

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    when was the last time you ran check links?

    I'd ponder running against the financial and the company series.

    make a back up before you do any check links  in case something is removed by check links that you need.

    as to a utility?  I've not heard of anything.  Typically you would want the hung transaction to post and the manual JE to reverse to maintain the drill back integrity of the system.  I suppose you could use query analyzer to remove the offending records, but getting all the right tables could prove tricky and who knows if anything lingers around if you miss a table when it comes time to run the year end close or another check links finds something and brings the transaction back.

  • Verified answer
    deanne917 Profile Picture
    deanne917 2,035 on at

    check links run about 1 month ago...won't have to worry about year-end yet because ours is September

    Thanks for your reassurance!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans