Archives

 

More articles like this can be found on our SQL Data Access menu.  

This is the 'Merge' stored proc for the SOP10200 table

More articles like this can be found on our SQL Data Access menu.  

This is the VB SOP10200 data access class

More articles like this can be found on our SQL Data Access menu.  

This is the SOP10200 Select by ID procedure

More articles like this can be found on our SQL Data Access menu.  

This is the SOP10100 'Select by ID' stored proc

More articles like this can be found on our SQL Data Access menu.  

This is the SOP10100 'Merge' stored proc

More articles like this can be found on our SQL Data Access menu.  

This is a class for use in Visual Studio that represents the SOP10100 table

More articles like this can be found on our SQL Data Access menu.  

This is a datasource for a report, against the Bill of Materials (BOM) tables.

Most of the data comes from BM30200 and BM30300.
We query the assembly items and add up the usage for the past 26 weeks, and then show average usage, quantity on hand, and lead time.

The purchasing department would use this report to order items.

The final query looks like this:

This is a code example for how to update one line in a SOP document using eConnect for GP2010.

There are a certain number of fields that need to be populated in the documents, we've shown those. You can include additional fields if you need them.

Earlier I wrote an article about how to update one line in a SOP document using eConnect 2010.

I traced the code using SQL Profiler, and extracted the SQL stored procedure calls that do the same job.

Pretty cool... 

More articles like this can be found on our SQL Data Access menu.  

This is the 'Select by ID' script for the SOP10103 SOP Payments table

This piece of code will iterate all the subdirectories in a folder. It will then process all the files in those subdirectories

In a recent project I had to validate that a user was valid against Active Directory. I'm not that good at LDAP queries so I thought I'd document this code in case it came up again.

The code shows a successful and failed lookup against a domain. Note that there is no password, we're only validating that the user exists.

I'm showing two different approacher, one uses the DirectoryServices namespace and the other uses DirectoryServices.AccountManagement. I'm not expert enough to know which is better... I just need the end result.

 

 

It turn out that you can't 'default' the line number in a Project Accounting Employee Expense integration. This came up today and we worked through the process of adding the line number programmaticaly.

Screen shots below to walk you through it.

 

We'll use this article to aggergate coding techniques for the Telerik ASP.NET ComboBox

This is a code example for the DataGrid / DataView ItemDataBound event.

In this example, we show how to

  • Get the value of items that are in the datasource (if the field is not present in the grid, only in the data)
  • Get the value of or get a reference to Bound Columns in the grid
  • Get the value of or get a reference to controls in Template Columns in the grid
  • Format a bound column

This concept applies to any Header Detail table relationship, for this example we'll talk about the SOP header/detail/serial lot relationship. We want back one line for each item in the order; and we want the serial/lots concatenated into one field. The final result will look like this:

The entire query that we need is below. Run the second script first, it's the function that makes the whole thing work.

 This code is based on the TWO database

This code sample shows how to navigate to a specific URL from VB.NET. Basically, the process shells out to the default browser on the computer

This is a really great technique. This article will show how to open an SSRS report from Dynamics GP VBA.

We had to overcome several challenges on the way to do this, I'd like to hear if anyone else has a more elegant technique.

First, we had to get the name of the report server and report from an ini file. Normally I'd store config data in SQL, but I'm trying to stay as light as possible and I don't know of any other way to do this so we use GetPrivateProfileString.

Second, we had to open a browser from VBA; so we used ShellExecute for that.

 The code below is fully commented.

We just added an article on a larger technique, but we wanted a separate article on just this sub technique. This article will show how to read an INI file from VBA

 

This is another 'sub post' to my last one, but the boss wanted a separate article for this topic to better fit it into the menu. BTW, are you using the menus?

The topic here is how to open a browser from VBA. Useful if you're shelling to SSRS...

This article will show how to call an SSRS report from code and pass in the parameters

I am trying to query (RM) Receivables Management tables (RM20201 & RM30201). I trying to understand which account # these record were applied to. Is there a column n the RM table that you can join on to get the account numbers for these records? or Is there another table I can join on to get the account number? Please help me. If you have an example let me know too.

Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect' or one of its dependencies. An attempt was made to load a program with an incorrect format

Sirs:

I'm getting the error above trying to connect a website to IIS 7. It works fine in dev...

We'll use this article to aggergate coding techniques for the Telerik ASP.NET ComboBox
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3