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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Missing TRXSOURCE in p...
Finance | Project Operations, Human Resources, ...
Answered

Missing TRXSOURCE in payable chaque payments

(0) ShareShare
ReportReport
Posted on by Jozy 393

Dear Community,

Hope all is well !

Recently we encountered some payable batches issues as I mentioned below step by step for better understanding.

 

1) One of our IT support staff gave payables batch posting rights to someone but he missing to give proper cheque posting rights.

2) Once the user tries to post many batches he saw "User Access Dined" in the print report and the batches go posted.

3) then he notices my posted transaction is only shown in the vendor ledger but those all transaction are missing in the bank inquiry.

4) then he contacts the support dept and asked again to provide proper rights. Once he has proper posting rights he decided to void all those wrongly posted transactions and post again.

5) Then all those voided transactions are appearing in bank inquiries with reflect of the negative amount which is creating issues in bank reconcile.

6) Support dept trace all those transactions via SQL and they found missing TRXSOURCE in all related payable and bank module table of those transactions.

 

Can someone guide what should we do in this situation as we already run Check Links and reconciled the complete financial and payable module but no positive result.

Thanks

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Did anything show up in the ledger?

    SELECT * FROM GL20000 WHERE SOURCDOC='PMTRX'

    Do you see any records where the TRXSORCE value is blank?

    How about SELECT * FROM PM20000 WHERE TRXSORCE is blank?

    Try looking in the CM20200 table. Can you find these records?

    You may want to open a support case for this because there are many table relationships that will need reviewed.

  • Jozy Profile Picture
    Jozy 393 on at

    Richard,

    There is no record in GL20000 related 'PMTRX'.

    There is no record in blank 'TRXSOURCE' in PM2000.

    I can only find voided transactions in CM20200 with 'VOIDED' value is '0' and amount showing in -5429999.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Unposted payables will be in PM10000, with posted but open payables in PM20000 and posted and paid in PM30200. If these got entered in payables they have to be in one of these three payables tables. If you do an inquiry on this checkbook and then zoom back where are they?

  • Jozy Profile Picture
    Jozy 393 on at

    Richard,

    I checked all tables as you said but I found nothing related to these transaction whereas I checked chequebook inquiry and these transaction is also did not exist in inquiry.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    The CM20200 has no column called TRXSORCE. The payables table do. What is the column VOID in CM20200? What column is blank in CM20200? What about PM20000 or PM30200? Please provide a few records of each that illustrate what you are finding or at least the SELECT statement.

  • Jozy Profile Picture
    Jozy 393 on at

    WC-Transactions.xlsx

    Richard, Please see attached file.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    If you were to go to Reports->Purchasing->Posting Journals->Transaction Journal and reprint for batch ID 301120JSCHQADV does it show an audit trail code? That would be the value of TRXSORCE.

  • Jozy Profile Picture
    Jozy 393 on at

    PM-Transaction-Reprint-Journal.pdf

    Richard, It does not showing audit trial code you can check attached file.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    If you issue select statement

    SELECT * FROM PM20000 WHERE BACHNUMB='301120JSCHQADV'

    are all the TRXSORCE values blank?

    If you run this

    SELECT * FROM PM20000 ORDER BY TRXSORCE do you see a gap?

  • Jozy Profile Picture
    Jozy 393 on at

    SELECT * FROM PM20000 WHERE BACHNUMB='301120JSCHQADV' ( No results found related this batch)

    SELECT * FROM PM20000 ORDER BY TRXSORCE do you see a gap? ( There is no gap).

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 461 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 458 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 450

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans