Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payables Mgmt Transact...
Microsoft Dynamics GP (Archived)

Payables Mgmt Transaction in Hiding

(0) ShareShare
ReportReport
Posted on by Community Member

We have a PMT transaction that appears on the Historical Aged Trial Balance (w/options) report for a vendor.  This transaction has a Voucher/Payment No. ending 9960.   This transaction does NOT appear on the Vendor/Document inquiry screens, nor does it appear in a Smartlist when selecting Smartlist>Purchasing>Payables Transactions>*.   PMT transactions ending 9959 through 9964 do appear but 9960 is missing. (I purposefully searched Voucher greater than 9958 and less than 9965 and Document Type = Payment.

Any advice would be greatly appreciated!

Jamison Well Drilling

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Payables Mgmt Transaction in Hiding

    Thank you so much for the script.  You were correct, as the results shown below, the transaction that needs removed is showing in the second set of results:

    select * from PM30200 where VCHRNMBR like '%9960'                                                                                                                                                           
    9960 CHRIST01        1 00:00.0 2010-1111             80 0 0 0 0 shelly          PMTRX00000890 XXPM_Trxent     00:00.0 00:00.0                       80 0 0 FUEL/ASHLAND ROAD               0 0 0 0 0 0                 00:00.0 0 0 0 0 00:00.0 shelly          00:00.0 shelly          0                 80 0 0 0 0 0 USDOLLAR                                                                                                              00:00.0 0 0 65489 0 0 00:00.0 0 00:00.0 00:00.0 0 0 0 0 0 0 0                                                                   0 0 1 4 7                   9 31:35.8 25628
    19960 SUMM01          1 00:00.0 B90525-001            73.52 0 0 0 0 JRL091412       PMTRX00001757 PM_Trxent       00:00.0 00:00.0 17854 0 0 0 New Miami - West                0 0 0 0 0 0                 00:00.0 0 0 0 0 00:00.0 sa              00:00.0 sa              0                 73.52 0 0 0 0 0 USDOLLAR                                                                                                              00:00.0 0 0 135098 0 0 00:00.0 0 00:00.0 00:00.0 0 0 0 0 0 0 0                                                                   0 0 1 1 0                   9 13:13.1 24161
    29960 1STC01          1 00:00.0 2052015 2072.2 0 0 0 0 JRL021215       PMTRX00002362 PM_Trxent       00:00.0 00:00.0                       2072.2 0 0                                 0 0 0 0 0 0                 00:00.0 0 0 0 0 00:00.0 Jeremy          00:00.0 Jeremy          0                 2072.2 0 0 0 0 2072.2 USDOLLAR                                                                                                              00:00.0 0 0 220907 0 0 00:00.0 0 00:00.0 00:00.0 0 0 0 0 0 0 0                                                                   0 0 1 4 7                   9 25:59.7 45051
                                                                                                                                                               
    select * from PM30300 where VCHRNMBR like '%9960'                                                                                                                                                          
    GUBIN001        00:00.0 00:00.0 00:00.0 00:00.0 9960 6                       00:00.0                 10 0 0 0 0 0 0 0 0 0 0 0 21951 3 RFND0000000000023     00:00.0 00:00.0 USDOLLAR        1000 10 0 0 0 0 0 0 0 0 0 0 0 0 0                 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33886                            
                                                                                                                                                               

    This record under vendor GUBIN001 I need to delete but am not able to do so using the conventional screens within GP.

    I thank you in advance for your advice!

    Larry

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Payables Mgmt Transaction in Hiding

    If the payment appears on the HATB w/ Options you will want to run the following query to see where the document appears:

    select * from PM30200 where VCHRNMBR like '%9960' 
select * from PM30300 where VCHRNMBR like '%9960'

    I suspect the first query will come back with no results, but the latter will return the apply records you are seeing on the report. Please let me know if this is the case.

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

Check out the New Agent Creator Community

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans