another blog

Icon

About Microsoft Dynamics GP :-)

Getting the current active window in Dexterity.

Using dexterity there is not a direct way of getting current active window information, but with set of available GP functions and triggers can make this task happen. Below I am sharing a trigger and function which can tell the active window name. Below code needs to be changed according to the needs of developer, I have hard-coded values just to give an idea of how it can be work. There is a good discussion regarding the same topic on below dynamics community link to understand different ways of getting active window information in dex and .net.

https://community.dynamics.com/gp/f/32/t/199211?pi53330=2#responses

 

local long l_result;

l_result = Trigger_RegisterFunctionByName(0,
“Security”, TRIGGER_BEFORE_ORIGINAL, function getResourceID_fun);

getResourceID_fun

function returns integer i;

inout integer dictid;
in integer resourcetype;
in integer resourceid;
optional inout string strValue;
optional in boolean bolValue;

warning Resource_GetResourceName(0, 2, resourceid);

 

 

 

 

Filed under: Dexterity Triggers, Dynamics GP, Uncategorized

Dexterity Can Wait and Respond.

https://evspakistan.wordpress.com/microsoft-dexterity-can-wait-respond/

Filed under: Can i, Dexterity Development, Dynamics GP, dynamics-gp, Uncategorized, , ,

Cross Dictionary Development.

https://evspakistan.wordpress.com/cross-dictionary-development/

 

 

Filed under: Dexterity Development, Dexterity Triggers, Dynamics GP, dynamics-gp, Uncategorized

Chunk file converted into dictionary but showing no custom forms in GP.

This happened today why my junior colleague was deploying customization on client machine, His chunk file was prompting to add code, code gets included but when log-in to GP and tried to access custom forms find nothing. He thought issue is with chunk file and recreated chunk file twice but no luck.
He asked me to help him out. So I check GP folder,custom dictionary was there, then I checked dynamics.set file but product information was not there and which makes me to look GP folder properties and what I found is that the GP folder was marked read only so Just unmarked the read only option and un-chunk the file again will solve the problem. 🙂

Filed under: Dexterity Development, Dynamics GP, dynamics-gp, Uncategorized, , , ,

If you are using ‘STR5’ datatype of Dexterity.

then please note, it actually a numeric only field. 🙂

Better create your own string 5 data type.Image

Filed under: Dexterity Development, Dynamics GP, dynamics-gp, Uncategorized, ,

Finding Field Name and Table Name of custom table.

This post is specially for our.NET team members who find it difficult to know field names and table names of custom table when need to use in sql scripts for their add on application for Dynamics GP.

Each time they need to come to some dexterity developer and ask for fields and tables, By similar way they can find field and table information of any GP additional product.

 

 

Let take an example of Customer Maintenance. We have added a table evsTable and it’s two fields on a window.

Field 1 and Field 2.

Image

Now what you have to do is to open the window for whose field information you need, lets say we need to know in which table Field 1 will save data and what is the physical name of Field 1 to use in sql.

 Just focus on some other field and press Alt+F8 and save macro file anywhere.

Image

Now focus Field 1.

Again press Alt+F8.

 

Now go to the path where you have saved macro file and open it on notepad. You will find field name in it.

Image

Now to find the table name, go to below navigation and open a window.

Image

Select the product of your window, if you know the core good otherwise you have to use commonsense for window type, like customer means it must be sales.Image

Now you have table name as well as field information.

 

🙂

 

Thanks,

almas

 

Filed under: Dexterity Development, Dynamics GP, dynamics-gp, Uncategorized, ,

Finding Field Name and Table Name of custom table.

Finding Field Name and Table Name of custom table.

This post is specially for our.NET team members who find it difficult to know field names and table names of custom table when need to use in sql scripts for their add on application for Dynamics GP.

Each time they need to come to some dexterity developer and ask for fields and tables, By similar way they can find field and table information of any GP additional product.

Let take an example of Customer Maintenance. We have added a table evsTable and it’s two fields on a window.Field 1 and Field 2.

1

Now what you have to do is to open the window for whose field information you need, lets say we need to know in which table Field 1 will save data and what is the physical name of Field 1 to use in sql.

Just focus on some other field and press Alt+F8 and save macro file anywhere.

2

Now focus Field 1.

Again press Alt+F8.

Now go to the path where you have saved macro file and open it on notepad. You will find field name in it.

3

Now to find the table name, go to below navigation and open a window.

4

Now to find the table name, go to below navigation and open a window.

5

Select the product of your window, if you know the core good otherwise you have to use commonsense for window type, like customer means it must be sales.

6

Now you have table name as well as field information.

🙂

http://www.facebook.com/notes/almas-mahfooz/finding-field-name-and-table-name-of-custom-table/471195756284558

Filed under: Dexterity Development, Uncategorized

Microsoft Dynamics GP Functional Blog

Haven’t found any functional blog for Dynamics GP. Which explains GP as a business software, it’s options, it’s flow.

😦

Filed under: Uncategorized

Categories

Enter your email address to follow this blog and receive notifications of new posts by email.

Enter your email address to follow this blog and receive notifications of new posts by email.

almas

Error: Please make sure the Twitter account is public.

Blog Stats

  • 7,671 hits

RSS dynamics-gp

  • Getting the current active window in Dexterity.
    Using dexterity there is not a direct way of getting current active window information, but with set of available GP functions and triggers can make this task happen. Below I am sharing a trigger and function which can tell the active window name. Below code needs to be changed according to the needs of developer, […]
    Almas
  • Hints and Tips… On going Post
    This is on going post and points will be added from time to time. 🙂 .. with Field Level Security we can not restrict document access on Sales transaction entry Window. Means we can not make user to choose only ‘Invoices’ in SOP Type drop down. .. we can not add custom table in table […]
    Almas
  • Reversing the sort order of Receivable Transaction Inquiry – Customer by Document Date
    Last few months we got more request on changing sort orders of Inquiry windows and lookups and to cover them all in a one place I have been working on a small project which will provide a simple sorting without much effort. In Dynamics Community there was a post having similar situation, I have already […]
    Almas
  • Getting the current open window in .net GP Add In
    There are many ways of getting information of active window in GP, but it changes according to the developing tool we are working on. 1.Dexterity.(the best tool 🙂
    Almas
  • Not all RW_Function are meant for reports.
    There are lots of RW functions available in a report writer Calculated Field Definition window and almost all of them are so handy while working on report writer, but it is a matter of fact that some of them are not actually meant for report writer. Usually RW functions are associated with report writer and […]
    Almas
  • Dexterity Can Wait and Respond.
    https://evspakistan.wordpress.com/microsoft-dexterity-can-wait-respond/Filed under: Can i, Dexterity Development, Dynamics GP, dynamics-gp, Uncategorized Tagged: Delay, dexterity, Wait
    Almas
  • Cross Dictionary Development.
    https://evspakistan.wordpress.com/cross-dictionary-development/    Filed under: Dexterity Development, Dexterity Triggers, Dynamics GP, dynamics-gp, Uncategorized
    Almas
  • Calling Sales Document Numbers Lookup
    Often developers need to open available lookup on their custom form from dynamics GP.Sales Document Number lookup is a very common and much used lookup and every dynamics technical person needs to call it in once (or more) in their lifetime. 🙂 Dynamics GP SDK provide a prototype of coding on how to open various […]
    Almas
  • This datatype name is already in use.
    This datatype name is already in use.
    Almas
  • Adding Customer Inactive checkbox to National Accounts Form.
    RE: Adding Customer Inactive check box to National Accounts form. https://community.dynamics.com/gp/f/32/p/134427/292770.aspx#292770 To run this code you need to add a reference. Mark a reference to a Microsoft Active X Data Object Library in the VBA editor.        1. Open up the VBA editor and go to Tools | References.2. Scroll down until you see the […] […]
    Almas
Coding Notes

Code, News, Tech & Stuff

Dynamics GP Builders & Reporting

How to use MS Dynamics SmartList Builder, Excel Report Builder and other Reporting tools to get the data and analysis you need.

%d bloggers like this: