SQL Script to get all vendor purchasing accounts

I recently needed to select all assigned purchasing accounts for a particular vendor; this would include both the normal purchasing one on the Vendor Account Maintenance window and the additional ones in the Additional Vendor Accounts window.

The SQL is fairly straightforward, but I had to make sure each account was only included once:

/*
Created by Ian Grieve of azurecurve|Ramblings of a...

Continue Reading Ian Grieve’s Article on their blog

SQL Script to get all vendor purchasing accounts

I recently needed to select all assigned purchasing accounts for a particular vendor; this would include both the normal purchasing one on the Vendor Account Maintenance window and the additional one‎…

Blog Syndicated with Ian Grieve’s Permission