Mark Polino's Blog, page 304
November 7, 2011
Support Debugging Tool Customization #9 – Credit Limit Check Skip in Receivables Transaction Entry (using Native Dexterity Save Logic) | Interesting Findings & Knowledge Sharing
Sivakumar keeps cranking out interest Support Debugging Tools customizations like Support Debugging Tool Customization #9 – Credit Limit Check Skip in Receivables Transaction Entry (using Native Dexterity Save Logic)
Weekly Dynamic: ReQLogic Mobile Opening Attachments
We've been doing a lot of work with ReQLogic lately and with a client wanting to get the most out of ReQLogic mobile.
The client wanted to be able to open and review attachments prior to approval without having to separately download the attachment and go find the attachment to open it. Specifically, they were looking at PDF, Excel and Word files. After much trial and error we've got some suggestions.
One note, ALL mobile devices download the file in the background, the key here is that they would like the download and open step to be transparent.
iPhone – iPhone handles this without any adjustments. iPad – The iPad handles this without adjustments and the ReQLogic regular site works fine as well. Android – For some reason the default Android browser had problems with this scenario. Downloading Opera MOBILE (not mini) and accessing the ReQLogic mobile site solved the issue. Most Android devices seem to come with the QuickOffice viewer installed which allows viewing PDF and Office files. Blackberry – Blackberry will download and open the files in two steps but we haven't been able make this work in a single, easy step for users. Windows Phone 7 – None of the users at this location have Windows Phone 7 devices so we couldn't test this.
November 3, 2011
Making A Drive Available Over The Remote Desktop Connection | azurecurve
Over at azure curve, Ian Grieve looks at Making A Drive Available Over The Remote Desktop Connection.
Since he mentions my name in the post he gets and automatic mention here. Not that he needs it.
Language settings for Windows client must match SQL Server Language - Developing for Dynamics GP
David Musgrave worked through a thorny problem only to end up with an issue where Language settings for Windows client must match SQL Server Language
[image error]
Weekly Dynamic: Complex Web GoTos in SmartLists
Developing for Dynamics GP has covered passing complex parameters through shortcuts in the past. Similarly, I recently had a chance to pass a complex parameter to a web page through a GoTo on a SmartList. I thought I would spend a few minutes showing how this works.
The basic scenario was simple. A client needed to pass an invoice number as a parameter to an internal web page connected to an imaging system. Clicking the GoTo would open a web browser, pass a URL with the embedded parameter and an invoice image would open.
When using SmartList Builder there is a button to create a GoTo. Clicking the button opens the GoTo window. The Plus (+) button creates a new GoTo and one option is to open a webpage. So far so good.
Clicking the Open Webpage option lets you set a description to appear and a enter a URL. To just open a web page, that's all that needs to be setup. Clicking the plus sign allows the assignment of parameters. This useful for sending search strings to say Bing or Google and in our example, an imaging website.
The parameter gets a name that is actually passed as part of the parameter string. The parameter can only be 30 characters long. In addition, you select a table and field from the SmartList to pass. Multiple parameters can be added by clicking plus.
For the first parameter, GP Actually passes the website, a question mark (?) to indicate a parameter, the parameter name, an equal sign and the field value from the select field in the SmartList.
For example, a Bing search for Dynamics GP would look like this:
URL: http://www.bing.com/search
parameter: q
SmartList field value: Dynamics GP
The GoTo would put it together like this: http://www.bing.com/search?q=Dynamics GP
For basic queries this works great, but what if the parameter is more than 30 characters?
What if the parameter you're passing needs to be in the middle of a parameter string?
Don't worry, there's a way around this.
The secret is to create a calculation and pass the calculated result to the GoTo. My client had a very long parameter string with the invoice number at the end so here is what I did:
I grabbed the entire parameter string AFTER the first equal sign (=). I would need that for the parameter later. Created a calculation in SmartList builder using the calculation button and pasted the parameter string in as a calculation with single quotes around it for SQL. Then I added a plus sign (+) and selected the invoice number from the available fields at the right. This gave me almost the entire parameter string. The calculation looked like this:
Finally I created a new GoTo with the parameter information before the equal sign as my parameter name and selected the calculated field instead of the invoice number as the field to append to the end.
Everything worked perfectly and now selecting a GoTo from that SmartList reports fires up a web browser and displays the related image.
As we worked with this for a few days we learned a couple of things. The invoice number passed through the calculation could also be passed as a second parameter instead of being embedded in the calculation. The only real benefit is clarity.
Secondly, the SmartList field being passed as a parameter needs to be included as a key field in table. We missed this the first time. The SmartList was built off a single view and didn't need a key field except to satisfy SmartList Builder so Batch Number had been randomly picked as the key field.
Consequently, until we added Invoice Number as a key field, SmartList Builder was passing as parameter an invoice from the batch that included that invoice number, but not necessarily the right invoice number. It was occasionally right and often wrong. Including Invoice Number as a key field in the SmartList solved this problem.
Originally posted by Mark at 11/23/2009 09:00:00 AM 
[image error]
November 2, 2011
How do you setup a Payroll Garnishment in Microsoft Dynamics GP? - Dynamics GP Support and Services Blog
The Microsoft Dynamics GP Support and Services blog answers How do you setup a Payroll Garnishment in Microsoft Dynamics GP?
![[image error]](http://3.bp.blogspot.com/_BFj0p8giN1k/Sv9FQPxdFpI/AAAAAAAAAdw/_6p3_wgNEts/s1600-h/Web+Goto+1.PNG){kind=link}