nav-left cat-right
cat-right

Setting default values in GP Windows

Sometimes, we need to enter a value in textbox or check on a checkbox every time (or most of the times) we use a window. Sometimes, we want to set a default value in a field to avoid users accidentally missing it. In this post, I am going to discuss following options that  you can use to set default values in GP windows. 1.  VBA 2. VS Tools 3. Extenders 4. Support Debugging Tool I am going to use the Paid Transaction...

SQL query to get companies accessible to a SQL/GP ...

You can easily check list of companies accessible to a GP user using Company Access Window. Or you can use a small query on table sy60100 Something like SELECT * FROM sy01500 WHERE cmpanyid IN (SELECT cmpanyid FROM sy60100 WHERE userid = ‘LESSONUSER1′) However, recently I needed a list of companies a SQL user (not user in GP) had access to. For this I needed list of databases the user had access to and company...

Digging deep into Multicurrency Revaluation

In this post, I am going to explain the MultiCurrency Revaluation feature in GP. This is used to calculate the Realized and Unrealized gain/loss based  exchange rates Setup  accounts for the Realized and Unrealized Gain/Loss: 1.       Turn on the revalue for the accounts 2.       Enter the posting accounts for Realized and Unrealized gain/loss 1.       Revaluation option must turned on  for accounts...

Add data in AutoComplete list from third party app...

Suppose you need to enter data in a field in GP which already exists in some other application. You want users to add exact same values without any minor difference or spelling mistakes. For this kind of situation you can use the following code to add data in autocomplete list of a particular field in window in GP. I am using the dexterity method AutoComplete_AddStringValue for this which  Dave described in his post Adding...

Adding autocomplete to a field

Auto-Complete is generally very useful feature especially when you need to repeat the values in a field. GP has auto-complete feature for all the important fields in version 8 and above. However, fields like user defined fields in various window, custom fields, don’t have this option. Using modifier, you can add AutoComplete practically in any field in the GP. Here, I am adding a autocomplete in the User defined Field 1 in...