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 Purchasing series. The SQL is straightforward, but I had to work out the binary entries to check for by saving and checking each combination.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP19 April 2024MADIC dynamics Knowledge Hub Webinars: Jet Reports & Business Central
Dyn365GP19 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
Dyn365GP18 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
Dyn365GP17 April 2024Splitting a Table on a Microsoft Dynamics 365 Business Central Word Template
