DynDeveloper.com - Your Dynamics GP Questions, Answered

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

EconenctOut

I am using econnectOut for retieving data. I have created new record in eConnectOut_Setup table and it is working fine.

The question I have is how can I use aggregiate function like sum, group by in eConnectOut_Setup.

Can any body help?

Sajudeen Kassim

Change company from add-in?

Is it possible to change to another company from an add-in? I thought about creating a macro for each company and then calling them from the addin, but I wouldnt be able to handle errors for the user.

Thanks,

Zach

Controlling the position of Add-in windows

I am using GP9 and VS2005 and am wondering is there any way to control the position of addin windows relative to the main GP window ?

I know there are options to control the form position properties to :- screen centred, manual etc. There is also the option of saving and retrieving postion of the window by using the registry. But I want the window to be centred relative to the GP application. There is a form postion property : CenterParent but it does not appear to work correctly.

Is it possible to determine the absolution position of the Dynamics client and then subsequently position an addin window ?

Any help is appreciated

Setup visualt studio tools error

I know this may really look elementary.

I am trying to setup the visual studio tools.

In the setup he doesn't ask me for component I want, at the end I can't find the dyanmics GP add ons in my visual stuido project menu.

I tried many times to use the command of devenv but nothing happened.

Please help if you can, there is a somthing missing, I did it beofre but I can't remember it now.

Thanks,

Amr

how to get eConnectRuntime.exe

i have installed microsoft dynamics gp, and now i want to install eConnect, the install guide could not help, because i could not find eConnectRuntime.exe, and Application Server components. what can i do now......

eConnect: Assigning Multiple Item Sites to an Item

I believe that this applies to any eConnect object that can have multiple 'child' objects (i.e. Customer addresses, Vendor addresses), but in my case I happen to need it for Items with multiple ItemSites. Every example of this that I have seen only has 1 child object, so I haven't found any examples of how to do this properly.

So I have a simple array that contains the list of sites, and every item needs to be assigned to those sites. I then read that array, set the properties of the ItemSite object, and then attempt to assign that ItemSite to my ItemSites array.

Dim ItemSite As New taItemSite_ItemsTaItemSite
Dim ItemSites() As taItemSite_ItemsTaItemSite
Dim siteLoop As Integer = 0
For siteLoop = 0 To UBound(itemSitesArray)
    ItemSite.ITEMNMBR = Item.ITEMNMBR
    ItemSite.LOCNCODE = itemSitesArray(siteLoop)

    ReDim Preserve ItemSites(siteLoop)
    ItemSites(siteLoop) = ItemSite
Next

This code compiles and runs, but the problem I'm having is that the assignment line (last line in the loop) is assinging a pointer/reference to the ItemSite object, and is not assigning a copy of the ItemSite object. So after ItemSites(0) = ItemSite, and ItemSites(1) = ItemSite, when I change the values of ItemSite.ITEMNMBR, it is changing the ITEMNMBR value for ItemSites(0) and ItemSites(1).

I've looked at DirectCast(), but the taItemSite object doesn't support MemberwiseClone.

Is there a different method for assigning the object? Or do I have to write a manual 'clone' function like what is discussed here:

http://www.xtremevbtalk.com/showthread.php?t=177296

Or should I just write a separate function to independently assign an Item Site to an existing inventory item after it is created and just call that function multiple times?

GP AddIn Modal Window

A colleague warned me that using Modal windows for a GP AddIn causes problems. He mentioned that it messes up the tab order, but when I tried it, the window displays, but some controls (save and cancel buttons, control box) do not respond to mouse events. I basically have to use the ESC key to close the window.

Has anyone had problems trying to do a Modal .NET window as part of an AddIn?

If it doesn't work, is there a workaround for avoiding problems if the user goes back to GP and makes changes?

In my case, my .NET window is for the Vendor Maintenance form, and my data on the form is tied to the vendor ID, so I would ideally like to prevent the user from changing the vendor ID on the GP form. Modal seems like the easiest way, but I suppose I could detect a change in the Vendor ID field value and handle the situation at that point, but that seems like more work.

What are the tables for Field Level Security? in Dynamic GP 10

Good day to all,

What are the tables for Field Level Security? in Dynamic GP 10.

I want know how to export the inoframtion of Field Level Security.

Regards

Dex DB Triggers Using Visual Studio

Hi All,

How to implement Trigger_RegisterDatabase() functionality from vstools?

Thanks

Ravi Polepalli

GP 10 .net customization

Hi, I am working right now on Grant Management module under GP 10 using the add on .net tools, but actually I do not have any experience in GP, so this my first project with GP customization and I have some questions if you can help me please:

1- If I need to create a new database table should I create them using sql server 2005 management studio or there is different way

2- Can I use the security modules in the GP 10.

3- I need to generate Microsoft word documents based on the predefined templates( the information for this document will be filled at run time)

4- Is it possible to implement access level per item.

Please if you can advice or help. Thanks in advance. Bashar