Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

vendor card maint changes

Posted on by Microsoft Employee

We are currently going through an Internal Audit process and during the testing phase one of the auditors ran across an anomaly.  She looked at the vendor card 1099 type for a particular vendor # on 10/1/14 and took a screen shot.  Then looked again on 10/10/14 and the 1099 type had changed (see attached).  I ran the Smartlist for Vendor Modified Date and this vendor had NOT been modified since 1/17/14 which is when we run our 1099 Vendor Review.  If the vendor had been modified between 10/1 and 10/10 it should show on the Smartlist correct?  Also, as you can see it changed again between 10/10 and 10/14, then back again.  I asked all of our AP people and they assure me that they had not touched this vendor in GP.  It was on no one’s list for review nor had there been any transactions for this customer since November 2013.

 

I’m stumped.

 

Thanks in advance for your help,

*This post is locked for comments

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: vendor card maint changes

    Hi Robin!

    I would try using the SQL statement that Lyn had posted.

    Please let us know what you find!

    ~Thomas Newcomb

    ------------------------

    Dynamics GP Support

    ------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: vendor card maint changes

    Please note, when you run the query, replace my 'xxx' with your actual vendor ID inside the single quotation marks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: vendor card maint changes

    Unlikely.....the only integration set up to run in AP is one that I run every 6 months to inactivate dormant vendors.  No update to the vendor 1099 type.  I'll run your suggested query and see what drops out.    

    Thanks so much!

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: vendor card maint changes

    Could it have been updated directly in the SQL database?  Is there any sort of integration running which does updates to the vendor records?

    I tested this in my system, and the modified date correctly shows when I changed a vendor's 1099 type.

    However, for your particular scenario, you could try also running a SQL query that pulls in the DEX_ROW_TS field.  You cannot get this field in your canned SmartList, but you can get it from the database.

    I used this query to test my data:  select modifdt, creatddt, dex_row_ts, ten99type, * from pm00200 where vendorid='xxx'

    I hope this helps you get to the bottom of your mystery!

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans