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 new 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