Dynamics GP & SmartList - Excel Tip - Format as Table
System Manager, MS Dynamics GP
For those of you on Dynamics GP 2013 and later, the SmartList export to Excel has been performance enhanced to make it quicker.
read more
Dynamics GP - Verifying Document Dates Are Valid
System Manager, General Ledger
I have had a couple of support calls recently that have dealt with document dates that were completely invalid - one for the year 3013 and one for 1944.
read more
Dynamics GP - Utilise your Quick Links
System Manager, MS Dynamics GP
I love learning new things about Dynamics GP and better still – I love it when new clients ask questions that make me think. Here is a co-create solution that my client (thanks Sharon) and I came up with to make your Quick Links panel much more suited to a role that works in lots of areas.
read more
Dynamics GP - SmartList - Renaming Columns
System Manager, MS Dynamics GP
This is a simple little tip that is not necessarily that obvious if you haven’t been told about it. I had a client lamenting that users of her SmartList outputs were always asking what the headings meant.
read more
Overview of the ODC (Office Data Connector) for Dynamics GP
System Manager, Business Intelligence
The ODC allows you to view Dynamics GP data in an Excel spreadsheet – without needing access to Dynamics GP itself. This functionality is included with the base licensing of Dynamics GP. Excel Reports can be deployed to Microsoft Office SharePoint Server (MOSS). This requires additional...
read more
Data Archiving in Dynamics GP
At our February user events we looked at the value of archiving data in your Dynamics GP database. There are some built in tools that will enable you to remove data from the database, but to use them would be time consuming and could lead to some horribly unlinked data.
read more
Dynamics GP - Using Custom Reminders
System Manager, MS Dynamics GP
Dynamics GP comes with a range of preset alerts which are great for adding a reminder to your desktop. Using the Custom Reminders that link to SmartList favourites is a much better and very effective alternative.
read more
Dynamics GP - Change Global Defaults for SmartList
System Manager, MS Dynamics GP
As a default, all SmartLists have the default to return a maximum of 1,000 records. For some areas of the system (e.g. Customer and Supplier records) this may be adequate. As soon as you need to look at transactional information, you exceed 1,000 records very quickly.
read more