DynDeveloper.com

I want to access the Microsfot dyamic global variables in my .Net Project So I written code like this
          
 try
            {
                string UserName = Microsoft.Dexterity.Applications.Dynamics.Globals.UserName.Value.ToString();

           }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

But I am getting error : the specified module could not be found. (Exception from HRESULT: 0x8007007E)

I have installed VSToolsInstallRuntime, VSToolsInstallSDK and also I added all reference

using Microsoft.Dexterity.Applications;
using Microsoft.Dexterity.Applications.DynamicsDictionary

I need some help please,

I am using Visual Studio Tools for Dynamics GP 9.0 . I added event handlers to trap the "save" event for the SOP Transaction Entry form in GP. The trap is working fine but I need to know how to tell if GP actually saved the transaction or reported an error and did not save it so I know whether or not I should save the information in the secondary window.

Thanks in advance,

Stanley

Edit 9/16/15 View the main article for this error here 

Here was the problem:

During my testing today, I came across an error from eConnect:

Error Number = 724 Stored Procedure taSopHdrIvcInsert Error Description = Invalid Currency, a Functional currency must be set up

I figured that it was a GP sales setup issue and looked for a default currency but couldn't find one.  So I then passed in a valid currency id ("Z-US$") and received the following error:

Error Number = 492 Stored Procedure taMCCurrencyValidate Error Description = This company does not have access to this Currency ID or is Inactive

I then went into GP and set up access for the test company to "Z-US$" (Tools >> Setup >> System >> Multicurrency Access).  I received the following error:

Error Number = 356 Stored Procedure taMCCurrencyValidate Error Description = The table MC40000 does not contain a Rate Type ID or is empty

Here was the suggested solution:

Go into Tools>Setup>System>Multi-Currency Access and make sure that the company that you are trying to access has access to Z-US$

Go into Tools > Setup > System > Currency Setup and be sure that Z-US$ is set up

Go into Tools > Setup > Financial > Multicurrency and set up a funcional currency

It sounds like 1 of 2 things:
1.       Even thought the customer may not use Multi-Currency they still need to give the company access to Multi-Currency (Tools>Setup>System>Multi-Currency Access) as well as setup a functional currency for the Company
2.      You are not passing a valid Currency ID into the transaction.

864342 Activity for this currency already exists. The functional currency cant be changed

863727 Error message when you try to enter a transaction in General Ledger in Microsoft Dynamics GP: "No functional currency has been selected"

I want to open the Unit of Measure window. When I call the Open method, the window opens but it has no data in it.

Dynamics.Forms.IvUofMLookup.Open();

What do I have to do for the window to fill up with data? 

 How do I iterate through the lines of a scrolling window?

I'm using visual studio tools.
I cannot find a property with information of the lines in that window

This code will allow you to get connection data from VS Tools

Hi.  I have a form IvItemMaintenance that i open from another form.  I want to be able to pass it a parameter (the item number) and open the IvItemMaintenance Form showing the item i passed. 

The same way it works when inside a sop entry, you set the focus to an item, click the Item Number link a little above and click the Item Maintenance menu.

That what I want to be able to do.

 I cannot find what function to invoke, like I would if i was opening a SOP
 

Thanks in advance. 

From a recent email: 

Yesterday, I extracted two tables from a customer’s DYNAMICS database - SY01500 (User Master) and SY60100 (User-Company Access), so I could show him which users had which access to their various databases (they have several).  It took me quite some time to do it and I know there is a script I could enable in Query Analyzer/Management Studio to cut something like this down to nothing at all from a time perspective.  I DTS’d the data out into two Excel sheets, did a VLOOKUP on CMPANYID, which is the common field for both, and then sorted the data by USERID.  I listed a User ID for each database/company name they had access to as it is pointless to show the customer a CMPANYID and not a company name.  I know I could have written some sort of script in SQL to join the tables on this field so I could have skipped the whole Excel piece completely.
 

Here is the query:

select company.cmpanyid,
  company.cmpnynam,
  company.interid,
  users.userid
 from sy01500 company
  join sy60100 users on users.cmpanyid = company.cmpanyid
 order by 1,4