Bulk Export Dynamics GP Document Attachments using .NET

Precipio ServicesSteve Endow of Precipio Services, the man behind the GP Transaction Search, has created another tool for Microsoft Dynamics GP; this one allows a bulk download of Document Attachments.

The tool allows the user to select a Database, Record Type, and indicate whether Deleted attachments should be exported. The attachments can then be previewed before being exported:

Export Document Attachments window

Full details of this tool is available on Steve’s blog and can be downloaded here.

As well as the Free Tools, Precipio Services also have a range of products available; they also provide a a full array of Dynamics GP integration and customization services.

Enhanced Notes Setup Window Missing

GP Elementz Enhanced NotesA while ago I did a series on Implementing Enhanced Notes from ISC Software Solutions. I more recently installed the add-on again on a different machine and, after doing some initial configuration, wanted to change the settings, couldn’t find the Enhanced Notes Setup window (Administration » Setup» Company » Enhanced Notes » Setup Enhanced Notes):

Administration area page showing menu option missing

Continue reading “Enhanced Notes Setup Window Missing”

Implementing SmartList Builder: What is SmartList Builder?

eOne SolutionsThis post is part of the series on Implementing SmartList Builder from eOne Solutions.

Before launching into the installation of SmartList Builder, I thought it might be worthwhile to do a post on what it is. All users of Microsoft Dynamics GP will be familiar with SmartList; this is the flexible reporting tool which allows you to generate a report showing a list of master records or transactions. Each series has a set of SmartLists available by default, with predefined favourites where search criteria or columns are supplied already configured.

SmartList favourites can be customised and new ones created quite easily, but new SmartLists themselves cannot be created. To create a new SmareList, you need a tool such as SmartList Builder or, in more recent years, SmartList Designer. In this series, I am focussing on SmartList Builder as this is an additional product available from an ISV for Microsoft Dynamics GP.

Back in 2003 when I started working with Microsoft Dynamics GP, SmartList Builder was available direct from Microsoft. SmartList Builder was originally developed by eOne Solutions and then licensed by Microsoft; in the run up to the release of Microsoft Dynamics GP 2013 SP2, the licensing deal for SmartList Builder was ended and maintenance of the product reverted back to eOne Solutions.

SmartList Builder the product, includes four utilities:

  1. SmartList Builder – SmartList Builder allows you to create both brand new SmartLists or modify existing SmartList. You can link up to 32 tables together. Tables can be standard GP tables, any of the Third Party (ISV) tables, any SQL table, SQL views or SQL Scripts, other SmartLists or Extender resources.
  2. Excel Report Builder – Excel Report Builder generates an Excel Spreadsheet with a live connection back to GP or any other data you include. This means you have live refreshable reports, anytime you need them. You can give all your data from GP to anyone in the organization via Excel – without buying new, full-user licenses of Dynamics GP.
  3. Drill Down Builder – Drill Down Builder completes the functionality of Excel Report Builder by letting you drill from your spreadsheet back into that same record within Dynamics GP. Where Microsoft hard codes a drill down – eOne makes it completely configurable to allow you to drill down to any screen or SmartList in Dynamics GP. This is an essential part of bringing the most common business tools together. Working in GP and Excel all day – it only makes sense to auto-switch between one and the other.
  4. Navigation List Builder – Navigation List Builder allows you to publish your SmartList into the Navigation List user interface.

The standard installation of the SmartList Builder product, gets you all four of the above utilities.

Implementing SmartList Builder: Series Index

eOne SolutionsI’ve posted series on a few different ISV addons for Microsoft Dynamics GP over the last few years, but, somewhat ironically I guess, have not posted all that much about the addin I’ve used the most over the years.

That addin is SmartList Builder from eOne Solutions.

SmartList Builder allows you to create both brand new SmartLists or modify existing SmartList. You can link up to 32 tables together. Tables can be standard GP tables, any of the Third Party (ISV) tables, any SQL table, SQL views or SQL Scripts, other SmartLists or Extender resources.

This series is going to cover the implementation of SmartList Builder; I’ll take a look at report builder in a future series.

Implementing SmartList Builder
What is SmartList Builder?
SmartList Builder vs. SmartList Designer
Register
Security
Review

Implementing SalesHQ Portal: Conclusion

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

I realise working for the company who created and sells the Sales HQ portal prevents me from being a neutral reviewer, so I won’t try to offer a conclusion as I have been doing on recent series. Instead I’ll leave you with a quick recap of some salient points:

  • Responsive design which works on desktop, notebook/laptop, tablet and mobile/cell.
  • Portal is hosted on Azure; but no inbound ports need to be opened on your firewall.
  • Salespeople can be assigned multiple customers to look after; customers can be assigned to more than one salesperson.
  • Access for customers to view their account.
  • Salespeople can create prospects or raise quotes/orders/invoices.
  • Free trial connected to your system available so you can try SalesHQ risk free.

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Implementing SalesHQ Portal: Using SalesHQ Portal

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

Over the course of this series, I’ve taken a look at how SalesHQ is implemented. I thought it would be useful to do a post on actually using SalesHQ, but first a reminder that earlier in the series I did a post on What SalesHQ is and what functionality it contains.

I am going to look at Sales HQ from the perspective of a salesperson who has access to a US territory.

When you visit the SalesHQ portal, you will be presented with the login window; this uses the crdentials entered when the salesperson was created:

SalesHQ Login

Continue reading “Implementing SalesHQ Portal: Using SalesHQ Portal”

Implementing SalesHQ Portal: Test SalesHQ Portal

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

Once I have SalesHQ deployed and salespeople and/or customers with access, I run a quick test to make sure I can log into the portal.

Navigate to the web address you supplied during the implementation (I didn’t use a custom address so have a default one). When the login page loads, enter the email address and password of one of the salesperson accounts you created:

Sales HQ web portal logon screen

Continue reading “Implementing SalesHQ Portal: Test SalesHQ Portal”

Implementing SalesHQ Portal: Customer Setup

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

With SalesHQ fully deployed, the final step of configuration is to grant customers access sot they can see their account information online. This is done via a window accessible from Customer Maintenance (Sales » Cards » Customer).

To add access for a customer open the Customer Maintenance window, open a customer record and click the Additional button on the action pane and select Manage Customer Accounts:

Customer Maintenance

Continue reading “Implementing SalesHQ Portal: Customer Setup”

Implementing SalesHQ Portal: Salesperson Setup

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

With SalesHQ configured, it is now available to use. However, the first thing we need t do is grant access to salespeople so that they are able to log in.

From experience, very few clients actually use salespeople in Microsoft Dynamics GP the way it was intended. So rather than enforcing the use of them, the SalesHQ functionality has been hooked onto the Salesperson Maintenance window ()Sales » Cards » Salesperson) without requiring the salesperson to be assigned to customers.

There are two pieces of setup required against the Salesperson record:

  1. Assign the login details for the salespeople who can log in against this Salesperson record; multiple logins against a single salesperson is supported.
  2. Assign customers to a Salesperson record.

To add the users who can login, open the Salesperson Maintenance window and open a salesperson record. Click the AdditionalManage Salesperson Accounts:

Salesperson Maintenance showing the Additional button

Continue reading “Implementing SalesHQ Portal: Salesperson Setup”

Implementing SalesHQ Portal: Configure SalesHQ

SalesHQ PortalThis post is part of a series on Implementing SalesHQ Portal, which is one of the GP Elementz Portals from my new employer, ISC Software Solutions.

After a company has been registered with SalesHQ and you logout and back in, the menu will update with the menu items for the SalesHQ configuration windows:

Administration menu showing CustomerHQ

Continue reading “Implementing SalesHQ Portal: Configure SalesHQ”