We use cookies to improve your experience on our website.

Andosi Blog

Exploring Great Design

The Dynamics GP Blogster has published his list of the Top 10 Dynamics GP Freebies.

 
I'm excited that the 2 I have produced made his list:
Check them out if you haven't already.
 
This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.
Read more

I didn't run across any documentation on an eConnect proc that I found very useful while working with some eConnect integrations recently.  I needed to update, not insert, a SOP Header record after adjusting some line item prices through code.

I found that using taSopHdrRecalc worked great for this.  The schema is basically the same as the taSopHdrIvcInsert so you can consult that schema reference in the eConnect Help when working with this proc.

If you weren't already aware, Steve Gray has posted the eConnect Help Online here.

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

Read more

If you want to control for which users your VBA Code runs... you can... in some situations.
VBA Code can run behind a Modified or Original Window in GP, or not at all, based on the event mode you select in the window properties in the VBA Editor:

You could modify a window mildly and place your code behind the modified version just so that you can control for which users the VBA code runs by only granting access to the modified window to certain users.  This won't work in every situation such as those in which you need to

Read more

If you want to prevent users from adding new Serial Numbers on the fly when fulfilling Sales Documents in Dynamics GP try this:

  1. Add the Sales Serial Number Entry window to VBA
  2. On the Window_BeforeModalDialog event paste in this code:
If PromptString = "Do you want to add this serial number?" Then
    Answer = dcButton2
    MsgBox "You must select a serial number from the list of available serial numbers."
End If
 
Now, when a user attempts to add a serial number on the fly when fulfilling a Sales Document they will be presented with a message instructing them to
Read more

If you ever need to cancel Contract Lines (Field Service Contract Administration Module Contract Lines that is) outside of GP try this:


DECLARE @RC int
DECLARE @CONSTS smallint
DECLARE @CONTNBR char(11)
DECLARE @LNSEQNBR numeric(19,5)
DECLARE @CANCELDATE datetime


-- TODO: Set parameter values here.


EXECUTE @RC = [dbo].[SVC_Cancel_Contract_Line] 
   @CONSTS
  ,@CONTNBR
  ,@LNSEQNBR
  ,@CANCELDATE
GO

The team that developed the Field Service Series made it quite easy to leverage some of the same stored procedures called by GP to perform various functions such as this.

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

Read more

You can assign default SOP Process Holds to Doc IDs so that when Documents are entered Process Holds that could control the flow of work in your processes are automatically applied.

 
You might use default holds if, for example, every Order entered needs to go through a manual Credit Check OR all Backorders needs to be manually allocated.  Then, you could use SmartList to view documents on holds that are important to you.
 
To assign a Default Hold to a Doc ID:
 
  1. Navigate to Sales Document Setup through Sales Order Processing Setup.  Depending on which type of
Read more

It is pretty simple to apply custom filters to grids in Dynamics GP to control the data that loads into Lookups and Transaction Entry Windows.
In this example, my client wanted to be able to filter the Contract Maintenance - Lines window by Item Number and/or Serial Number.  Their contracts can be quite lengthy.  Research and contract maintenance would be cumbersome and inefficient without the ability to filter the records in this window.
To do this, use Modifier to add 2 new Text Boxes to the Contract Maintenance - Lines window in which to capture the filter criteria.  I placed them directly

Read more

Being able to do row by row data analysis and manipulation with SQL could be something that's missing from your toolbox.  Whether you're converting data or developing a customization, cursors can prove to be quite useful.  I use this template often.  Loops are generally preferred to cursors for better performance but I still go to cursors often.

 
This example will pass all of the ACTINDX and ACTNUMST values from the GL00105 table into a cursor called curCursorName and select the variable values, displaying them in the SMS query results pane, before going to the next.
 
All you have
Read more

Last year, I posted a VST customization I thought I would sell to a client that would give users advanced notice that their GP Password was about to expire. That version was locked to only work in Fabrikam. Since that sale never materialized, I have unlocked it and am distributing it for free, "AS IS" with no warranties. You can download the unlocked version here! Just drop it in the GP\Addins directory. I have only tested this on version 10 of Dynamics GP.
The Dynamics GP Blogster has talked about why system administrators are not taking advantage of the

Read more

Yesterday I posted a SQL proc that would reconcile SOP Batches and delete any that were empty.  I realized that was somewhat incomplete after learning about a problem another client was having with missing batch headers.  That also is not for everyone since there was not an option to NOT delete empty batches.

To that end, I have posted a new SQL proc that will reconcile SOP Batch Totals, optionally delete any empty batches, and add any missing batch headers.  If this sounds like something that would be useful to you, feel free to download the proc here,

Read more

I took a support call recently in which a client explained that they had accumulated hundreds of empty SOP Batches that they wanted to delete.  In response, I produced a simple proc that will scroll through the "Sales Entry" Batches and, like Check Links on Sales Work, will update the Number of Transactions and Batch Total on each.  This proc goes one step further and deletes any Batches for which the Number of Transactions is 0.  Of course, there are many reasons why you might want to keep some of your Batches even though they are empty so this might

Read more

I read an article in the Nashville Business Journal with survey results that more companies are spending but more are opting to lease their equipment instead of buying.  I too am seeing the same out in the field.
If you're already using Dynamics GP to manage your sales operations you're just a few clicks away from using it for managing your leases.
http://mbsguru.blogspot.com/2009/04/dynamics-gp-for-equipment-rentals.html

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

Read more

I've been approached recently by a couple of organizations to speak at Dynamics Conference/Learning events this fall.  I'd like nothing more than to give back to the community by offering up my time and experience to share with those that might be interested to hear what I have to say.

I'd like to hear from the community on this if you would be kind enough to spare a moment.  What kind of topics, content, etc. do you feel are lacking at these types of events?

My technical expertise spans general GP functionality, SQL Server (Administration, SSIS, SSRS, T-SQL Development,

Read more

Straight Arrow Consulting, Inc. has made Advanced RMA Entry R2 available for download and evaluation.
The Advanced RMA (aRMA) Add-on for Dynamics GP will help you to maximize the value of the investment you made in your Dynamics GP solution in a number of ways.  This add-on is particularly well suited for manufacturers/distributors and equipment rental companies but has a place in any solution that leverages the Dynamics GP RMA module to service customers.  aRMA extends the Dynamics GP RMA Module to accomplish the following goals:
1.  Allow lines on a single RMA originating from many SOP Invoices. 2.  Allow users

Read more

I highly recommend that you take some time to browse the content in Mark Polino's recently released "Microsoft Dynamics GP 2010 Cookbook" at Amazon.com.  You will be very impressed with the content.

This book is a must have for everyone.  There are many, not very well known nuggets of information documented in the book that will help everyone from users just beginning to learn Dynamics GP, to Dynamics GP Administrators, to the most experienced field consultants.

We just don't get the opportunity to apply these concepts everyday.  Having them at your finger tips like this is great.  I'd like

Read more

Accounting Software blogger Chris Thorman has a new article up exploring trends towards a decline in demand for horizontal accounting software.  There's little doubt that medium sized and large enterprises are looking for integrated solutions (often industry specific vertical solutions) and that the days of selling standalone, horizontal accounting solutions are winding down.

Dynamics GP does a great job of filling most of the needs of medium sized and large enterprises across most industries.

GP delivers functionality to create an integrated, enterprise wide footprint across you organization; Accounting, Distribution, Manufacturing, Project Accounting, Retail Management, and Field Service Management are just a few

Read more

The Dynamics GP Blogster is passionately taking on the challenge to get IntelliSense implemented in Dexterity.  When I made the statement to him that the likelihood that this would ever happen is ridiculously low his response to me was inspiring; "Good inventions were never right the first time around, they took several tries and awareness".

I voted for this feature.  If you want to get everything you can get out of GP you should vote for it too.  Go vote today at http://connect.microsoft.com/!

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

Read more

Dynamics GP 2010 is available for download on PartnerSource and CustomerSource:

PartnerSource Download
CustomerSource Download

Microsoft isn't sending out media automatically opting for a green distribution strategy.  Go download your copy and get started today!

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

 

Read more

Dynamics GP MVP and consultant extraordinaire Mark Polino of DynamicAccounting.net has been working hard on a new book titled "Microsoft Dynamics GP 2010 Cookbook".  It's now available for preorder at https://www.packtpub.com/microsoft-dynamics-gp-2010-cookbook/book and scheduled for release in the August/September time frame.

If you know Mark Polino, have attended any of his Dynamics GP 50 Tips Sessions at Convergence, and/or have been following his blog over the years you know his overall knowledge of all things Dynamics GP is unmatched.  If you are brand new to the world of Dynamics GP I have no doubt that you will find this tips style book,

Read more

I had a great time at Convergence this week.  With ~8,500 people in attendance this was quite an event that Microsoft pulled off remarkably.  Here's are some of my takes on the conference and some reasons why you should consider attending next year:

1.  Learning Opportunities galore!  The opportunity for education and learning for everyone at Convergence is at an all time high.

I don't have to administer GP systems on a day to day basis in my role BUT getting the opportunity to sit through another Mariano and Dave show on the Support Debugging Tool reminded me how

Read more