Plaza 365
Plaza 365

No results found for your search

RegisterLog in

3

Visit article

#dexterityfundamentsbootcamp

#multicurrencyaccesssetup

#projectsetupwindow

#triggers

Dynamics 365 ERP - Development

Category

Dec 18, 2023

Published date

Text

Article Type


AI Summary

  • The article discusses an issue faced by an attendee during the Dexterity Fundaments Bootcamp training, related to the Multicurrency Access Setup window in Microsoft Dynamics GP.
  • The problem highlighted is that the list of companies shown in the scrolling windows on the right-hand side is unsorted, causing frustration and slowness, particularly when dealing with over 300 companies.
  • The companies are currently listed in the order they were created, which is not useful when dealing with a large number of companies.
  • The solution proposed is to add a couple of triggers to the SY_Company_MSTR table to re-fill the scrolling windows using the Company Name index (key 2) after the core code fills them using the Company ID index (key 1).
  • The article provides the trigger scripts for the 'Currencies LB' and 'Exchange Tables LB' listbox field change events in the Project Setup window.
  • The triggers simply issue the fill window command with the additional by number 2 clause to sort the scrolling windows based on the Company Name index.
  • The article also mentions the option to download and install the example code provided, either by importing it using the Project Setup window or using the Configuration Export/Import window for older builds.
  • The code will become active on the next login or after switching companies, and the triggers can also be manually started from the Project Setup window.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.