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
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
Please note, when you run the query, replace my 'xxx' with your actual vendor ID inside the single quotation marks.
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!
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!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156