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) / 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

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

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