Skip to content

Contact Me

Please fill out the form below.  It will send me an email and I will be back with you as quickly as I can.  Thanks!

 

4 Comments
  1. Hey ron. i saw your blog. and found that you are very much handy with sql server and dynamics GP. Do you have any procedure for auto posting of batches for GP. I am trying out this from past 1 week and not finding the proper answer.

    Can you please help me out in this.

  2. Ron permalink

    Dynamicsstarter,

    Check out this post.

    http://mohdaoud.blogspot.com/2010/07/posting-microsoft-dynamics-gp.html

    Ron

  3. Greetings Ron,

    I have been unable to find in Help nor on web any help with GP Business Alerts. I simply want a total on the db mail report that comes with email. This part is working well, but Reports, I don’t know how to get a SUM or Total at the end: One alert is standard CHECKBOOK Balances. The list is good, but no total. Below I give copy/paste of current formula that will not pass as acceptable. I have developed quite a few and am not JR in SQL, yet not advanced either. In the GP Alert Define Formula I have the following: CM00100_T1.CURRBLNC ’0.00000′ AND SUM(CM00100_T1.CURRBLNC)
    The 1st part works fine and I get emails with TEXT report of all Checkbooks and Balances with last reconciled date and amount. I want a total at the end. the 2nd part after AND SUM, I know I am missing something, but not sure how to write this, as limited use of SQL in this window.

    Your help would be much appreciated!

    Gary Fauser, CPA
    Dynamics GP & SL
    203 253 4968
    rgfgaryf@comcast.net

  4. Ron permalink

    Gary,

    I just sent you an email.

    Ron

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 27 other followers

%d bloggers like this: