October 25, 2012 • 7:33 pm
To insert value in DEX_ROW_TS from back end GETUTCDATE() will be used in sql.
Filed under: Dexterity Development, SQL, dex, DEX_ROW_TS, GETUTCDATE()
October 25, 2012 • 7:28 pm
Filed under: Dexterity Development, SQL, adding CR in text field, Carriage Return, CMMTTEXT
October 25, 2012 • 7:25 pm
local integer item_number;
item_number = finditem(esUserLevel of window Enter_User_Names of form Enter_User_Names, CH_SPACE);
if item_number = 0 then
add item CH_SPACE to esUserLevel of window Enter_User_Names of form Enter_User_Names;
Filed under: Dexterity Development, Adding NULL values in dropdown, CH_SPACE, Dexterity Dropdown, Dexterity finditem()
October 19, 2012 • 9:36 am
To Show relevant currency symbol in custom Dynamics GP window we need to do the following.
- Drag a Currency Index field inside window, but keep it off the window main area.
- Link all currency fields to that index field through ‘Link Format Selector’. One can find it under “Tools” Menu.
- Read the currency index value on change of your currency ID field from MC_Currency_SETP table.
- Now the fields will show the relevant currency symbol on window.
Filed under: Dexterity Development, Adding Symbol to Currency fields, Currency Symbol in Dynamics GP windows, Dexterity Currency field, Link Format Selector
October 16, 2012 • 11:07 am
Where COLUMN_NAME =’ITEMNMBR’
and table_name like ‘IV%’
Filed under: Code Snippit, SQL, finding specific field in tables, INFORMATION_SCHEMA.COLUMNS, SQL Script to Find column in tables
October 5, 2012 • 5:36 am
We have one database named “Other”, a non GP database.It has some table we need to use within GP.(read/write/edit/delete record)
On our GP Company Database ‘TWO’ we have created a view.
CREATE view [dbo].[VOtherTable001]
select *,ID as Dex_row_id from Other..OtherTable001
Let’s add a button on sales transaction entry window to read the first record of table.
we will give permissions to our view.
grant select , insert, update, delete on VOtherTable001 to almas
Now the next messages we got are
To solve these above issues
Create a new role like below in ‘OTHER’ database .
Create a user loging for user ‘almas’ in ‘OTHER’ database so it could be mapped with TWO user.
How to access non gp database table within GP window.
Filed under: Dexterity Development, Dynamics GP, dynamics-gp, 3rd party database access, The SELECT permission was denied on the object "XXX", User access