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!
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.
Check out this post.
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
I just sent you an email.
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of follow-up comments via email.
Notify me of new posts via email.
Enter your email address to follow this blog and receive notifications of new posts by email.
RSS - Posts
RSS - Comments
Blog at WordPress.com. | The Titan Theme.
Get every new post delivered to your Inbox.
Join 28 other followers