vendor card maint changes

(0) Share

Report

Posted on by Community Member 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

All responses (4)

Answers (0)

Thomas Newcomb 1,810 on at

Like (0)

Report

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 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 on at

Like (0)

Report

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!