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
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Specify Dimensions on Posted Entries Applications With Realized Gains or Losses