New Article on MSDynamicsWorld: In-Transit Transfer Transactions

June 30, 2008

Dear readers,

Check my new article at MSDynamicsWorld.com: “Here’s a Creative Exercise you Probably Won’t Miss: Allocating Inventory in Transit Using Microsoft Dynamics GP”. The article recollects the old tricks used to manage in-transit inventory and explores the new In-Transit Transfer Transactions feature in Microsoft Dynamics GP 10.0.

Once again, thanks to David Gumpert, Managing Partner and Editorial Director at MSDynamicsWorld.com for allowing me the chance to exercise my second passion — writing.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Advertisements

VBScript "Type Mismatch" Error with Integration Manager 10.0

June 25, 2008

For those of you battling it out with a “Type Mismatch” error in your event or field scripts upgraded to IM 10.0 from previous releases of IM, sweat it no more! This issue has been recognized as a bug by Microsoft and was unfortunately not resolved in Feature Pack 1 (or Service Pack 2). The problem seems to occur with all IM VBScript functions that accept parameters.

The issue is that these functions (and many other) accepted OPTIONAL parameters in prior versions of IM. The reason these are now failing is because Integration Manager has been switched over from VB6 to C# .Net code. The problem with that is that C# does not support optional parameters. That means that those existing function’s “Optional” parameters are now actually Required parameters.” said Greg Willson with Microsoft in the Microsoft Dynamics GP Community group.

However, as a workaround, IM developers must supply all parameters for the affected functions until a Hot Fix is made available in July. Willson proceed to explain the issue with an example.

So with that said, the LogDocDetail function has five parameters (message, source, status_code, field_name and field_value). All parameters are string values except “status_code” which is an Integer value. So, now that we know that, if you supply a value for all parameters, it will work as expected.“.

The list of affected functions include (but may not be limited to):

  • CancelDocument [message, source, status_code, field_name, field_value]
  • CancelIntegration [message, source, status_code]
  • Execute path [, timeout] [, window_style]
  • LogDetail [message, source, status_code]
  • LogDocDetail [message, source, status_code, field_name, field_value]
  • LogDocWarning [message, source, status_code, field_name, field_value]
  • LogWarning [message, source, status_code]
  • PlaySound path

Functions not affected:

  • ClearVariables
  • DocumentIsNew
  • DocumentNo
  • GetVariable(variable) — the parameter is mandatory
  • SetVariable variable, value — the parameters are mandatory

To access and contribute to the discussion thread on the Microsoft Dynamics GP community click here.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/


More Deployment Options for Microsoft Dynamics GP: P2P Networking

June 20, 2008

News has surfaced on the US Dynamics GP Field Team blog that Peer-to-Peer (P2P) networking is now supported as part of the growing number of deployment options. Needless to say that P2P is only suitable for very small operations and may require one of the participating workstations to have suitable capacity to run SQL Server Express 2005 and Microsoft Dynamics GP all at once, while accepting incoming requests for posting and all the various operations involved with the system.

The article also clarifies that P2P has only been tested on machines running Windows XP, but expect to have results soon for environments running Windows Vista.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/


Your Must-Have CRM Checklist: 10 Factors to CRM Success

June 19, 2008

This free live webinar will be conducted on June 26, 2008 at 10:00 AM PDT / 1:00 PM EDT with the sponsorship of Microsoft Dynamics CRM Online and InsideCRM.com. If you are interested, register here.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com


Enabling Address Third Line in Microsoft Dynamics GP Report Writer

June 18, 2008

Ok, I felt the need to write about this because I still cannot understand why, after so many years, the Microsoft Dynamics GP development team cannot extend the courtesy of adding the extra calculated field required to display the address third line for customers, vendors, etc., and anyone who happens to have a third line in their address.

Case in point, if your address happens to be:

1972 Western Boulevard
Tower C
Suite 400
COLUMBUS, OH 43203

Dynamics GP will display on all its reports:

1972 Western Boulevard
Tower C
COLUMBUS, OH 43203


Now, that’s just a bummer! Anyways, to correct this issue you will need to modify all reports where you need to display a third line by incorporating a fourth calculated field — follow whatever convention used by Microsoft to create the calc field as it will make your life easier. Your address calculated fields should look something like this:

Address Line 1 = Function_Script( rw_SelectAddLine 1, “”, Address1, Address2, Address3, “”, City, State, Zip, “”)

Address Line 2 = Function_Script( rw_SelectAddLine 2, “”, Address1, Address2, Address3, “”, City, State, Zip, “”)

Address Line 3 = Function_Script( rw_SelectAddLine 3, “”, Address1, Address2, Address3, “”, City, State, Zip, “”)

Address Line 4 = Function_Script( rw_SelectAddLine 4, “”, Address1, Address2, Address3, “”, City, State, Zip, “”)

NOTE: I use commas for readability sake in this post, but in Report Writer these will not exist between each parameter of the function script. Normally, you would find two blank spaces (“” “”) after the Address2 position in the function script. Highlight the first blank space, click remove, and chose Address3 from the appropriate table (RM Customer Address Master, PM Vendor Address Master, Company Address Master, etc.) and insert in its place.

You will also have to pay attention to certain reports, since you may encounter address fields on the Report Header and Page Header sections. In this case, you will have to drag your new AddresLine4 calculated field to both sections. In addition, special attention is required for the field properties on both sections as usually they are different. To have access to the field properties, you can double click on say for example AddressLine3 on each section and replicate the same properties to AddressLine 4 to ensure you obtain the right data.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com


Retrieving Microsoft eConnect 10.0 Version

June 18, 2008

There are two methods that will allow you to retrieve the exact version and build number in eConnect 10.0.

Method 1

In Windows, go to Start > Programs > Microsoft Dynamics > eConnect 10 > Release Information > Release Info. You can verify the Connection String by clicking on Connection. Once this is done, click on Retrieve and the window will be populated with the exact version of eConnect.
Method 2
You can run the following SQL script in SQL Server Management Studio Query window against your DYNAMICS database:
exec DYNAMICS..taeConnectVersionInfoDYNAMICS
Until next post!
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

More Microsoft SQL Server 2008 News!

June 13, 2008

Fresh from Tech-Ed: Microsoft unveils SQL Server 2008 release candidate (RC) which has been declared the last public release before release to manufacturing in Q3, 2008. For now, SQL Server 2008 Release Candidate (dubbed RC0) has been made available to the general public. If you are interested in testing the product (if you haven’t already done so with TCP version), you can click here to obtain a copy.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/