You’re offline. This is a read only version of the page.
285
I was using the PSTL vendor combine tool last week and it was unable to perform the expected task because of a Violation of Duplicate Key issue. Turns out there were four tables in this series that had 'both' of the vendors I wanted to combine and the PSTL tool could not do that.
But, after asking Leslie and Richard, and doing a reasonable amount of searching on Google and PartnerSource I had to give up on finding out what application was utilizing those tables.
So I'm reaching out to the community to see if anyone knows about the AMS tables in these queries.
select * from AMS00100 where vendorid in ('18153','10637') 17 rwos – only vendor 18153
select * from AMS00200 where vendorid in ('18153','10637') 45 rows mix of both vendors
select * from AMS10100 where vendorid in ('18153','10637') 2 distince rows - Nothing in them only NoteINDX
select * from AMS10200 where vendorid in ('18153','10637') 138 rows mix of both vendors
select * from AMS20100 where vendorid in ('18153','10637') 92 records but NO VendorID records
select * from AMS20200 where vendorid in ('18153','10637') 1275 records but NO VendorID records
select * from AMS20200 where vendorid in ('18153','10637') 1275 records but NO VendorID records
select * from AMS30100 where vendorid in ('18153','10637') 2341 records but NO VendorID records
select * from AMS30200 where vendorid in ('18153','10637') 0 records but NO VendorID records
select * from AMS70100 where vendorid in ('18153','10637') 0 records but NO VendorID records
select * from AMS70100 where vendorid in ('18153','10637') 0 records but NO VendorID records
select * from AMS70200 where vendorid in ('18153','10637') 0 records but NO VendorID records
Thank you,
Mike Lupro
*This post is locked for comments
Is it possible that these are custom created tables? The numbering scheme seem to follow taht of the payables tables(PM). I am surprised the the PSTL tool cares about them. Perhaps there are triggers on the PM tables that goes after them. Run SQL Profiler while running the PSTL tool and see if anything shows up.
Several times I have combined vednors,customers and Items. I have not faced any issue. I don't found 'AMS00200' table in my GP production database. Is it third party application blocking you?
Thanks
Sandip
For the sake of others who find this problem here is what I did (brute force) to get the PSTL Vendor Combine process to work.
These were the two vendor ID's
18153 remains
10637 goes away
select * from AMS10100 where vendorid in ('18153','10637') 2 distince rows - Nothing in them only NoteINDX
delete AMS10100 where vendorid = '10637'
select * from AMS10100 where vendorid in ('18153','10637') 2 distinct rows - Nothing in them only NoteINDX
delete AMS10100 where vendorid = '10637'
select * from AMS00200 where vendorid in ('10637') 45 rows Mixed
update AMS00200 set vendorid = '18153' where vendorid = '10637' 39 rows updated
select * from AMS10200 where vendorid in ('18153','10637') 138 rows Mixed
delete AMS10200 where vendorid = '10637' 67 rows deleted
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (