SQL Script to get all accounts set as available in Purchasing lookups

Following on from the last post, in which I posted a script to get accounts linked to a vendor, this post is a script which returns all accounts which are set as available in lookups in the Purchasing series.

The SQL is straightforward, but I had to work out the binary entries to check for by saving and checking each combination.

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

Continue Reading Ian Grieve’s Article on their blog

SQL Script to get all accounts set as available in Purchasing lookups

Following on from the last post, in which I posted a script to get accounts linked to a vendor, this post is a script which returns all accounts which are set as available in lookups in the Purchasin‎…

Blog Syndicated with Ian Grieve’s Permission