DynDeveloper.com

This article can be found on the Integration Manager Menu. 

A client recently called with an issue with importing an XML file using Integration Manager (IM). Apparently, IM can't read the attributes in an XML document. After trying for a while to get it to work, we decided to write a small application that would parse the XML file and move the attributes to nodes.

Today’s task has to do with an XML document that has the form:

This document, and all our eConnect documentation, is available on the eConnect menu.  

Are you using the DynDeveloper eConnect class? It’s in all of our sample code. The eConnect class is designed to be easily transportable from project to project and contains all the common code that developers need to code with eConnect. All that's left is the code that changes from integration to integration.

This class is called from all the eConnect samples. You'll need this class first in order to run them. This code is for GP2010/2013, and it encapsulates all the commons tasks in eConnect (getting a document number, creating a transaction)

Methods included:

Connection String - returns the connection string used by eConnect

Serialize - serializes (turns to XML) the supplied eConnect object

CreateEntity (overloaded) Accepts either the eConnect object or an XML document

CreateTransactionEntity (overloaded) Accepts either the eConnect object or an XML document

UpdateEntity (overloaded) Accepts either the eConnect object or an XML document

GetNextIVNumber
GetNextGLJournalEntryNumber
GetNextPONumber
GetNextPOPReceiptNumber
GetNextRMNumber
GetPMNextVoucherNumber
GetNextSOPNumber

Edit 1/9/2018 added support for GetEntity

It is occasionally necessary to find all the occurrences of a field name in a SQL Server database. This script will seacrh the database and return all the tables that contain a certain field name.

Here we show two different ways to get this done quickly

This piece of code is worth the price of admission

It happens that I want to move an accounting database from one server to another (we do a lot of Dynamics GP work), and the logins have to be persisted. You can't just recreate them manually because the passwords are encrypted and there are often just too many of them.

 To migrate a SQL box:

• Run this script on the old server, it will create a script that will recreate the logins.
• Stop the old server
• Copy the .mdf files to the new server
• Attach the databases on the new server

Welcome to our Web Services index

Web Services 101 - sample code for connecting to Web Services

Be sure to see all the other Web Services content on the Web Services for Dynamics GP menu.  

Here is sample code to get all customers in Dynamics Web Services

You'll need to get the common code first, this code will require it

Be sure to see all the other Web Services content on the Web Services for Dynamics GP menu.  

Here is sample code to get a list of POs in Dynamics GP Web Services

You'll need to get the common code first, this code will require it 

Recently I was trying to troubleshoot an MSIEXEC install (you know, where you see MyInstallName.msi in the folder) that wasn’t really giving an error message, and wasn’t logging anything either.

This post shows a technique to enable verbose logging for MSIEXEC so that you can see more of the issue that that you're having.

This article, and all the other .NET development articles, can be found on the .NET Development Menu  

Here is the link for Crystal XI Release 2

http://www.businessobjects.com/products/reporting/crystalreports/xi_release_2.asp

Another important link. This one has the server install, and merge modules

http://support.businessobjects.com/downloads/merge_modules.asp#06

It ends up being harder than it sounds... the javascript methods that we used before are not as freindly now. Here's an easier method:

This piece of code will validate an email address.

This is not a primer on ASP.NET Validation controls, there are plenty of those out there. This is just my handy little piece of cheat code - it's easier to copy it out of here when I need it...

First, place the ValidationSummary control on the page. We'll have the individual controls display an '*' for error, and the Summary control will show the error text

Very simple. Here is the code

There are legions of articles (articli?) out there on how to trap errors in ASP.NET. My purpose here is not to be bigger, better, faster. I'm only trying to blog the code that I use, so that I can use it in the next app that I write. So... keep your expectations low <smiles>

On a recent project, I needed to query Active Directory to get a list of people in a specific group.  I didn't find much sample code for this so i thought i'd post what I figured out. 

This function returns the users in the current active directory group.  It does this by getting a list of all the users and checking what group they are in.

The group itself lists what users are in it, but it stores the display name not the user name.

This code may not be scalable, but it worked for us. I read, but haven't tested, that ldap queries limit to 1000 results so this may be a problem if there are more than 1000 users.

Here's a useful tip for adding lines to an html table in code. Normally I'd define and populate a grid, but sometimes that's overkill 

This article can be found in the VBA/Dynamics Modifier section of the VBA for Dynamics GP menu. 

I've avoided blogging this because I always figured that it would just... go away, but I always seem to need something from here.

Here's the standard adovbs.inc file.

The whole thing needs to be wrapped in <%... %> if you really want to use it right... I usually just want a value

This post shows how to iterate through a ComponentArt grid. In this grid we have a check box column in the grid, and we want to loop through only the selected items.

When restoring a SQL Server backup, the users that are restored in the database are not the same as the users that were created at the server level, even though they may share the same name.  This creates a problem with websites/users/etc that try and log into these databases.  Because the accounts aren't the same, the login is rejected.

There are several ways to fix this problem. 

This code was made with Crystal 11 r2 and Visual Studio 2005.  It may not work correctly with other versions.  It shows the code needed to manually populate a subreport in Crystal.

Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

When deploying a Crystal-enabled web app to a new server.

 I solved this, but it was a long road.

In Visual Studio 2008, merge modules are no longer used for crystal reports controls.

 To add the crystal reports files:

This is a walk through for changing the datasource of a VS 2008 Crystal Report at runtime.

Create a new form in VB, add the Crystal Report Viewer control, dock it. For the sake of simplicity, I've kept the code as concise as possible. The form has two public properties, the report name and the data source. We pass those in before opening the form.

Here's how to loop through an ASP.NET datagrid

This article, and all the other .NET development articles, can be found on the .NET Development Menu  

A word of introduction to the 'introduction'. This is from the magazine ASP.NET. If you are reading this and you don't have a subscripton, stop and get one now - it's invaluable.

 I only copy the article here because the information is so good - I don't want to have to waste time looking for it or worry that it will get archived.

 Again - get the mag. http://www.aspnetpro.com/ 

Introduction to Regular Expressions: Part I

Creating Expressions

By Mitchel W. Sellers

This two-part article series provides a quick and practical introduction to using regular expressions. Regular expressions can be used for many things; however, they are typically used for input validation or to perform advanced searches on text in supporting applications. This first article will explain how to create a regular expression pattern; the expression defines what is considered a match. The second article will provide details on how to implement regular expressions in .NET applications.

Before starting I’d like to point out I have a free regular expression tester available on my Web site (http://www.mitchelsellers.com); you can use this to test the behavior of your regular expressions. During the second article I’ll discuss the specific options available on this test page, as well as how the page was created.

Regular expressions have three basic types of symbols that are used: meta characters, escape characters, and character classes. The following table lists the important meta character(s), a short description, and an example of each.

Meta Characters

The characters in the table below are used to match special characters in regular expressions; we will use some of these later in this article. NOTE: This is a list of commonly used escape characters, not a complete list of escape characters.

Escape Characters

Below are character classes that represent different groups of characters to make it easier to match common groups of characters.

Character Classes

How to Apply this Information

Now that we’ve explained the various characters included in matching regular expressions, let’s walk through some practical examples to illustrate how all these items are pulled together. In the following subsections I’ll walk you through a series of real-world validations and provide examples with detailed information.

Before beginning the examples I want to point out that in ALL of my examples the regular expressions created start with the ^ character and end with the $ character. This is done to ensure that the expression matches the entire string. This is done to ensure that the string is that match, and ONLY that match. Otherwise, you can receive matches for strings with more than the included characters. You may play around with this using my expression tester to see the effects of omitting the ^ and $ characters.

Postal Code Validation

Postal code validation is a very common user input validation; typically, your postal code will either be five digits or nine digits, with a hyphen after the fifth digit. We can validate this input with the following expression:

^\d{5}(-\d{4})?$

First we have the “\d{5}” portion of the expression, which indicates that the input must start with five digit characters (0-9). Next the portion of the expression inside the parenthesis, “-\d{4}” indicates a hyphen (-) to be followed by four digit characters. This is grouped within parentheses and has a question mark appended to the end. This question mark indicates that the input should have zero or one of the preceding items, which happens to be the entire expression in the parentheses. Therefore, in the case of zero, the expression would simply be five digit characters; in the case of one, the expression would be five digits, a hyphen, and four more digits.

Simple Date Validation

Validation of date input is another very common occurrence, full regular expression date validation is very involved; however, it is very easy to restrict users to a MM/DD/YYYY format with basic checking for incorrect input. Below is a regular expression to validate a date in the MM/DD/YYYY format; I’ve added parenthesis for readability:

^([01]\d)/([0-3]\d)/(\d{4})$

The first section of this expression “([01]\d)” represents the month portion of our date, because there are only 12 months in the year we restrict the first digit to either a zero or a one, and the second character can be any number 0-9. This is one portion of this example that can be improved upon; you can modify and create regular expressions that are capable of validating that the input is between 1 and 12 (however, this is outside the scope of this article).

The second section of this expression “([0-3]\d)” represents the day portion of our date. This is separated from our first part by a / character, which is a literal requirement that the month be separated from the date by a forward slash. The first part of our day check requires that the first digit of the day is a 0, 1, 2, or 3, then the second digit can be any number 0-9. Just as with the month portion, this can be expanded to ensure that the day value is appropriate for the month provided; however, it is outside the scope of this article.

The final section of this expression is again separated by a / character, then it allows for four digit characters to be entered. This forms the final portion of the date.

Phone Number Validation

Another common input item to validate are phone numbers, including area codes and extensions. Below is a sample regular expression that validates a phone number that meets one of the following formats; (555) 555-1212, 555-555-1212, (555) 555-1212 x1111, or 555-555-1212 x1111. Portions of the expression have been highlighted to illustrate the different sections of logic. These sections will be explained below:

^ (\(\d{3}\)\s|\d{3}\s) (\d{3}[\s-]\d{4}) (\sx\d+)?$

The yellow portion of this expression validates the area code input. Notice that we have two individual groups separated by the or operator (|). This indicates that one of the two expressions must be true. The first one validates on a left parenthesis (, three digits, a right parenthesis ), and a space; the second option validates on three digits and a space. Therefore, the phone number must begin with either (515) or 515; this validates the area code portion of our phone number.

The green portion of this expression validates the remaining portion of the standard phone number. The first part “\d{3}” requires three digits, then the “[\s-]” allows for either a space or a hyphen. This is then followed by the “\d{4}” portion, which indicates that an additional four digits are required. We now have validation for a standard 10-digit phone number with support for multiple formats.

The gray portion of this expression validates the optional telephone extension. The expression “\sx\d+” indicates that the input string should have a space, the letter x, and then one or more digits. This is enclosed in parentheses and followed by a question mark to indicate that it is optional. This provides for validation of numbers such as (555) 555-1212 x102.

This should provide a helpful overview of regular expressions. Stay tuned for Part II.

Mitchel W. Sellers is a Microsoft Certified Professional Developer with multiple specializations. He’s been developing in .NET since shortly after the release of .NET 1.1 He is the Co-Founder of a startup software consulting firm, IowaComputerGurus L.L.P. He is also very active in multiple online communities, including GotDotNet and DotNetNuke. Find out more about him at http://www.mitchelsellers.com or e-mail him at mailto:mitchel.sellers@gmail.com.

In order to loop through (iterate through) the list of available database in a network using SQL SMO:

Here is a trick I found while trying to delete rows from a DataSet.  I first tried the following code, but it throws an exception because the enumerator has changed.

Here is a VB.NET code sample that shows how to process arguments for a console app

Create a console app, and in the project properties click on DEBUG, then specify something in the 'Commant Line Arguments' area. For the sample app, you might put 'olap diskspace' and those two items will be processed.

Once you build and deploy the app, you would call the app like this: MYAPP.EXE OLAP DISKSPACE, where OLAP and DISKSPACE are my example arguments

We want to be able to set this XML file as the datasource for a grid. This is a short code example on how to do it.

Our XML file:

<seriesSermons>
    <series>
        <title>Building</title>
        <desc>As we enter into the construction phase of our building project, Pastor Campbell brings a series on building. Building not only walls and doors, but lives.</desc>
        <author>Dr. Mark Campbell</author>
        <details>
            <date>20080824 Sun AM</date>
            <file>Building with Prayer</file>
            <description>Nehemiah 2:1-11
From old testament and new, Pastor Campbell continues the series on building. This week - building with prayer.
</description>
        </details>
        <details>
            <date>20080817 Sun AM</date>
            <file>Building with Prayer</file>
            <description>
Nehemiah 1:1-11
As our new building is set to begin, Pastor Campbell begins a series in Nehemiah - God’s building story.
</description>
        </details>
    </series>
    <series>
        <title>Acts</title>
        <desc>
Pastor Campbell continues our weekly bible study in Acts
</desc>
        <author>Dr. Mark Campbell</author>
        <details>
            <date>20080720 Wed PM</date>
            <file>Acts 26</file>
            <description>
Pastor Campbell continues our weekly bible study in Acts
</description>
        </details>
        <details>
            <date>20080806 Wed PM</date>
            <file>Acts 26</file>
            <description>
Acts 26:19-20
Pall continues his defense before King Agrippa
</description>
        </details>
    </series>
</seriesSermons>

Selecting data on a dataTable using the datatable.select method

The following example uses a filter expression to return an array of DataRow objects.

I have a SQL database that uses some 'BYTE' datatypes. I ran into some issues getting it converted into a VB.NET datatype:

Conversion from type 'Byte()' to type 'Boolean' is not valid.

I have an application that is designed as a class library (a .dll) that is called by a WinForms app. The class library is trying to do data access using the Microsoft Data Access Application Block (which I really love, BTW).

Anyway, I was getting 'The requested database xyz is not defined in configuration' when I attempted data access. Grrr 

This is the class that I use in VB Win Forms applications for user data. this class has methods to return the userid, current database and connection string

I got first this error: 

The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

Followed by this error

The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.

The solution:

Hi All,

I am getting the error "Sql procedure error codes returned:Error Number = 370
 Stored Procedure taPoHdr  Error Description = Subtotal (SUBTOTAL) does not match the line item totalsNode Identifier Parameters: taPoHdr  
..........

when doing POP transaction into GP. If anyone has seen  this before, I'd greatly appreciate your help.

Thank you.

Regards

Rajesh

I used the example I found on line from Microsoft for eConnect Serialization and using Visual Basic. Everything worked fine, I setup breakpoints in the code to step through it to see the data. It looped through the data, created the xml file exactly like the example BUT no data was moved into GP. As a simple test I was moving customers from one GP database to another GP database on the same server. Anyone have any ideas? No Error Messages were generated.

I'm attempting to import a bank transaction via eConnect into the Microsoft GP2010 sample company, but receive the following error:

--------------------------------------------------------

Sql procedure error codes returned:

Error Number = 7604  Stored Procedure= taBRBankTransactionHeader  Error Description = Originating Debits and Credits do not match (ORDBTAMT <> ORCRDAMT in CM20400)
Node Identifier Parameters: taBRBankTransactionHeader
CMTrxNum = Trx003
CHEKBKID = UPTOWN TRUST

I've made a point of not including the default distribution which eConnect creates automatically. 
Any ideas??

When I am trying to sync the data, the new error is coming.

Unique MessageId =
Line Number=7610 Version=8.0.4.0
Error Source = Microsoft OLE DB Provider for SQL Server
Error Number = -2147217833  Error Description = Arithmetic overflow error converting expression to data type tinyint.  Node Sequence Number = 0
 Document Node:
<taCreateSopPaymentInsertRecord><SOPTYPE>3</SOPTYPE>

<SOPNUMBE>I273427</SOPNUMBE><CUSTNMBR>63939</CUSTNMBR>
<DOCDATE>8/3/2011</DOCDATE><PYMTTYPE>6</PYMTTYPE>
<CARDNAME>RD-SPAN</CARDNAME><RCTNCCRD>5809</RCTNCCRD>
<AUTHCODE>858</AUTHCODE><EXPNDATE>09/08/2011</EXPNDATE>
<DOCAMNT>200</DOCAMNT></taCreateSopPaymentInsertRecord> @ <1:19:55 PM> * <8/5/2011>
Processing Transaction I273427 @ <1:56:28 PM> * <8/5/2011>

Any help will be appreicated.

This is my 'isOpen' function for access, it allows me to tell if a form is open. The idea is that you call it from within a report 'onLoad' after opening a dialog that gets parameters. If the dialog is open (but hidden) you continue processing. If it's not open, you cancel the report

using  

it would return this error:

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

This is a piece of code that will compact (truncate) SQL logs. It's especially useful when a server has not been backed up for a while and the transaction logs have grown to a dangerous size

Editors Note:

There is a more recent version of this script here: http://dyndeveloper.com/ArticleView.aspx?ArticleID=4015

Auditing SQL tables is a very basic concept. You ocassionally need to save all changes to a table so that you have some history of the changes.

This script creates an audit table and triggers for the specified table.

Run the script against any table and an audit table will be created with the same name as the source table + 'AUDIT'. So auditing 'myTable' creates 'myTableAUDIT'.

We also create insert, update, and delete scripts that will populate the table.

You'll also need this script: http://dyndeveloper.com/ArticleView.aspx?ArticleID=1707

This piece of code will truncate the log file size for all the databases in a SQL Server. It has been tested against SQL 2000 and 2005

Following is a T-SQL script you can use to rename your SQL Server after you have changed the computer name. This script will work if you are connected to the default instance or a named instance. After running the script, you must restart SQL Server for the action to complete.

We run a web hosting company and we use SQL Server, it happens that we put up several new SQL databases a month. Invariably, the developer will forget to put the new database in 'Simple' recovery model. If you leave a database in 'Full' mode and only run regular backups, the transaction logs won't truncate and the drive will fill up. .

That's what happened today (sigh), so I developed this script to fix it. The script will show the recovery model of all the dbs, and and set them to Simple (or Full) if desired

Error message when trying to send SQL 2005 mail:

No global profile is configured. Specify a profile name in the @profile_name parameter.

I did this by accidentally deleting the default profile, it took me a half an hour to figure out how to set it again.

 To fix:

This article, along with other great articles, can be found on our SSRS General Index Menu.  

Here is a really nice datetime calc from the MAY 2007 edition of SQL Server Magazine (www.sqlmag.com). I reprint it here because it is too good to loose, and too long to remember perfectly.

If you are reading this and don't have a subscription to the magazine, this code alone is worth the subscription. Click on the link above and... just ... do... it <smiles>

 Itzik, you do good work, I love your column.

select dateadd(month,datediff(month,0,getdate()),0)

This will get the first day of the month of the passed in date (we use getdate() here). Quoting Itzik here:

The logic of this technique is a follows: Calculate the difference in terms of months between an anchor date at midnight (in this case, 0, represending the base date January 1, 1900) and the event date. Call this difference diff. Add diff months to the anchor date.

Here are some useful tips on SQL Server Optimization

If you are experiencing speed issues with SQL Server:

Customer has SOP batches that are created periodically without transactions in them and they want to clean them out on a regular basis.  I have the script to do so but now I want to create a scheduled task in SQL Server 2005 to run this during off hours, say, weekly.  What is the best way to accomplish this task?  Customer is now running GP v10 but in this case, I don’t think it matters since table structures have not changed that I know of within this scenario.

From a recent email: 

What, in your opinion, is the best recovery model for a GP database?  Full? Bulk_Logged? Simple?  They all seem to have their pros & cons but I can't find anyplace where someone says this model is better than the other two because of X, Y or Z reasons.
 

This is a helper function used in DDL scripts 

From a recent email:

Isaac,
 
Need to run a query in SQL to find customers who have not purchased a particular product.  In this case “FNADE*”
 
I can easily query customers who have purchased a particular or range of products, but never had to query a list of customers who have not purchased a particular product…
 
Can you get me going in the right direction?
 
Thanks.

Answer:

From a recent email: 

I am trying to use SmartList Builder to build a query where a calculation is required showing the number of days an A/R transaction is past due.  Obviously, I have the DOCDATE from RM20101 but I need a column that tells me the current date so I can make this comparison…and I am not sure if there is a SQL Server table that I can pull in that shows this information to me.  I am pretty certain that there is not a GP table with current date in it just sitting there by default.

Answer:

Code to create an update statement. You'll need to get the prerequisites also

Sometimes you might need to disable a trigger to keep it from recursing. This is a short code sample that documents how to do that...

This line of code will tell you if a temp table exists in the temp database, so you avoid all those errors..

Tested in SQL 2000 & 2005:

As a Dynamics developer, I'm frequently asked to divide by the USCATVLS fields in the IV00101 table. Since they're CHAR types, there is often no validation on empty values or numeric values. The funtion below will take two VARCHAR values and divide them, returning '0' if there is some validation issue. The code at the end is a test script.

I have occasion to look at large servers, and as part of that process I need to look at all the files to see if they're ok, I'm particularly interested in the size of the log files (we might need to shrink them)

 This query will quickly show you where they all are

I'm always looking for version info and it takes me forever to find it

Applies to: GP9, 10, 2010 

It happens that you need to add a field using modifier to a form, and that field needs to be a required field. There are a host of issues with this, the biggest one is that Dynamics GP doesn't provide you with a hook in the 'save' process to stop a save from happening

The user can save by pressing the Save button, or by navigating using the 'VCR' buttons in the bottom left corner of the form, or by pressing the Print button. Pressing Save will save with no warning, pressing the other 5 buttons will cause a modal dialog to pop up that will prompt the user to Save, Delete, or Cancel.

In order to make a field required, we'll need to do two things - put code in the Save_BeforeUserChanged event, and in the Window_BeforeModalDialog event.

The Save event is simpler. In these examples, our custom field is called Barcode. We're in the Payables Transaction Entry form, so we'll check to see if some of the other required fields are filled in. If they are, we'll stop the save by setting CancelLogic = True

Whenever we need to update AddIns folder for GP, we need to close GP and then we can replace files. This is time consuming as starting GP takes like30,40 seconds. Is there any shorter way where we can deploy files without closing GP?

 i've put a breakpoint on load event of a custom form and Dynamics.exe process is attached already. Assembly is digitally signed as well. But whenever i try to open target form, GP crashes automatically. If i try to remvoe debugging and then load the same form, it works fine. Can any1 plz tell, whats wrong with VST debugging?

I have an external web service that I am calling based on a SAVE event on PMTrxEntry window in GP.  After comiling the code, I see appconfig file with as following:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
        <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
            <section name="DynamicsGPValidation.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
        </sectionGroup>
    </configSections>
    <applicationSettings>
        <DynamicsGPValidation.Properties.Settings>
            <setting name="DynamicsGPValidation_edmswebdev_APOnBaseServices"
                serializeAs="String">
                <value>http://edmswebdev/onbasewebservices/APOnBaseServices.asmx</value>
            </setting>
        </DynamicsGPValidation.Properties.Settings>
    </applicationSettings>
</configuration>

My quesiton is wether or not I should leave this config file part of the GP\AddIn folder?  or merge this into the Dynamics.config file under the GP\ root folder?

Thanks 

I am trying to locate property for PMTransactionEntryWindow where I can select ModalDialog and based my method on SaveButton event.

In VBA I use to specify ModalDialog.Button1 or something of this nature.

The scenario is that I am running a custom logic based on SaveButton.ClickBeforeOriginal.  I have successfully coded the logic based on the SaveButton.  But if the end user clicks on the "x" (upper right hand corner of the window), a Box appears asking if your want to save, delete or cancel.  I am trying to find the event which triggers this Box specifically the Save button on it.

Thanks in advance! 

Scripts designed to run against Dynamics GP

Copy setup information from an existing company to a new one

Company/System

FP_SY00500_UPD - Retotals the SY00500 batch table

GL

GL Trial Balance Summary

PM

taGetPMNextPaymentNumber- Gets the next available PM Payment Number

RM

AR Historical Aging - Loop through the open receivables only

AR Historical Aging - This report is a modification of the Dynamics script, it fills the Aging Buckets

RM00103_SEL

taGetPaymentNumber - Gets the next RM document number

FP_RMCashReceipt_INS - Inserts an RM Cash Receipt

SOP

FP_SOP10102_UPD - Delete and recreate the distributions on an order

FP_SOPGetNextDocNumber/sopGetIDNumber - Gets the next SOP document number

FP_SOPPayment_INS - Insert a SOP payment

sopGetIDNumber - Gets the next SOP document number

Move a SOP transaction from open to history

Posting Sequences - documents the order that tables are Updated/Inserted on a Dynamics GP Post action

usp_SOPTotalTaxes - retotals the taxes for a SOP document

TAX

Get one or all Tax Schedules

Delegates are a tool to raise an event from one class to another, from one form to another, or any combination.

Let's say that you have a form that shows customers, and a popup dialog that gives you a grid of customers to choose from. We'd like to raise an event in the frmChooseCustomer to let frmCustomerEdit know that a customer has been chosen. So, lets start in frmChooseCustomer:

There are four tasks:

This post shows how to use the appSettings section of app.config or web.config to store user data

This is another of those cases where the code is pretty simple, but it helps to have a template someplace to copy the code from. So, here’s my template

 If you need something in VB.NET or ASP.NET to be configurable, the easy thing to do is to put it in the .config file and let the user configure it.

Our first eConnect installs got done under the user account of the consultant and ... the password go changed. Bright, right?

So, I went in to change the account. I created a domain user account and reassigned the account that the service used to log in. Now I've got this:

Service cannot be started. The handle is invalid

and

HTTP could not register URL http://+:80/Microsoft/Dynamics/GP/eConnect/mex/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details).

and

Exception message:
The communication object, System.ServiceModel.ServiceHost, cannot be used for communication because it is in the Faulted state.

This is our primer on the System.Text.Regular expressions namespace and the Regex class

We have sample regular expressions, and sample code that shows how to use it

What is Branding, and why do I need it?

Branding is when you create a certain image for your product. That image may only be font and color, it may include a logo or maybe a slogan. It may include a spokesperson. Your brand represents who you are, what your product is to the world.

You say “We’re a church”, or “We’re a school, why do we need that?” The brand of a church or school is how it is seen by the public. If you think of Florida State, or the University of Florida, what enters your mind? Colors? Mascots?

Branding.

It took me about ten seconds to find an example on the internet: http://visualsystem.fsu.edu/

When I do work for major institutions, they send me reams of branding information that has to be perfect. Colors, logos, fonts are the biggest issues.

I  recommend that you develop a brand for the school, and repeat it every place. Over and over and over. Everything that you do should have that brand on it.

I find that sometimes Christian organizations (which I do a lot of work for) are reluctant to go to the expense to develop a brand (you should have it done profesisonally) but it’s a one time charge, and it is needed in order to effectively promote the organization. Imagine Coke without a brand, or McDonalds. Hard to print T-Shirts <big smile>

This is a short piece of code that will show you how to navigate to a specific line in any Dynamics Grid

Here is a short code example of how to only allow selected columns in a Telerik grid to be editable

Telerik - z-order for the RadEditor FormatCodeBlock window

When I drop a RadEditor onto a form, the FormatCodeBlock window is popping up behind the RadMenu. This code snippet will prevent that

This short code snippet will show you how to set a unique primary key on a datatable

What is the difference between Application.MicrosoftDynamicsGp.ModifiedForms.dll and Application.Dynamics.ModifiedForms.dll

When I ran the following command, it only created Application.MicrosoftDynamicsGp.ModifiedForms.dll

dag.exe 0 "C:\Program Files\Microsoft Dynamics\GP2010\Dynamics.set" /M

There are two paths to take when adding a field to a grid in Dynamics, depending on the source of the data for the field. If the source is a field that's already in the table it's much quicker. But in these two videos we'll explore both options

The XML document below is an example of the XML document sent to Dynamics to create a GL Account. This document uses the GLAccountType and taUpdateCreateAccountRcd nodes.