Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
GPtip42day - Using SQL Wildcards to search & filter in SmartList
Did you know that you can perform searches and filter using wildcards in SmartList? It's true. Because SmartList is a query tool that uses SQL-like search functions, SQL wildcards can be used successfully in SmartList. So you ask, what are the SQL wildcard characters? Here they are -
* click image to enlarge
For instance, suppose you want to search your Vendor…
gptip42day - Changing the Default GoTo in a SmartList
When you drill into a record in SmartList, you're taken to a default window. For instance, in Receivings Transactions, the default GoTo window is Receivings Transaction Entry. But what if you want the default GoTo to be a different window? Say…
Take the Pain out of SmartlIsts with the Navigation Pane
I've never been a big fan of the Navigation Pane in GP9 and prior versions. I just don't like anything taking up my precious desktop space. However, I've found a great use for it.
As you probably know, there is no easy way (perhaps no way at all - I've tried but gave up) to group unrelated SmartLists. Here's the business case -
Client has many branches, with branch ID's ranging…
Weekly Review: Excel-ing with Smartlists
If you've used Great Plains for 5 minutes you've figured out how to export a Smartlist to Excel. Great feature, simple interface, push the button. But... there is another dimension to Smartlists and Excel that we're going to explore.
With a Smartlist open, pick Extras->Smartlist->Export Solutions to see what I'm talking about. Smartlist allows you to export to the SAME Excel spreadsheet time after time. You can also specify Excel macros to run before and/or after the export for formatting, analysis, etc.
Maybe you export data to…
SmartList Export Solutions in Dynamics GP
If you’re using SmartLists on a regular basis to report on information in Dynamics GP, you’ll want to learn how to use the Export Solutions functionality within SmartLists to add charts, pivot tables, calculated fields, and additional formatting to your data.
Export Solutions allows you to run an Excel spreadsheet macro on the data that SmartLists exports to Excel.
These are the basic steps…
Smart List Tree View Space
Patrick from MS Dynamics GP Developer Support at the Developing for Dynamics GP Blog posted a great article about smart list features in GP 10.0, one of his interesting points was and explanation on the smart list tree view control that displays the favorites and…
gptip42day - SmartList Letter Writing Assistant (LWA)
If you need to send a form letter to your customers, vendors, employees, etc., SmartList provides the Letter Writing Assistant to help automate the process. Let's say you want to send a thank you letter to your customers. Open SmartList and choose the Customers SmartList. Then, click the Word icon. The…
gptip42day - General Journal Posting SmartList
As we're nearing the end of the Fiscal Year for many companies, one of the reports external auditors ask for is a listing of all general journal entries posted for the year, who posted them and when they were posted, primarily to see if entries were posted during non-business hours. Unfortunately, if you're using GP9 or a previous version, the options for this type of report are rather limited unless you're using GP's Audit Trails or a 3rd party audit tool. This is because the GL tables in these versions…
gptip42day - SmartList GoTo
It's a pretty safe bet that anyone who uses SmartList knows that you can double click any record in the results pane and drill into the underlying document. However, did you know you can use the Go To button to access…
gptip42day - SmartList Window Size - GP9 and Prior Versions
One characteristic of SmartList that can be frustrating is the way the SmartList window shrinks when you drill into another window from a SmartList record. When you close the sub-window, the SmartList window remains at its reduced size and you have to click the "Maximize' button to maximize the window size again.
Then, with the…
SmartList .ini switch Problems
What’s the switch?
What’s the problem?
A client of mine was gracious enough to do some testing with this switch and discovered a couple of notable issues.
- Leading zeros are stripped…
Sleuthing Scandalously Slow SmartLists
I recently received an inquiry from a friend at BlueLock. BlueLock provides infrastructure hosting as a service. Don't want to deal with servers? Need to have a virtual infrastructure that allows offices in Tokyo, Paris, Moscow, London, and New York to all easily access your Dynamics GP system? That's what they do--all very fancy cutting edge hosting and virtualization, with enterprise grade Citrix and VMWare hosting.
So BlueLock is hosting a 25 user GP system for an international company with offices around the globe, and they are looking to ensure that the performance will be sufficient. GP is working fine, but there is one strange issue: Some SmartLists take forever…