SmartView

Updating

If you have a previous release of SmartView External installed, there are additional steps that need to be completed to update the SmartView SQL objects.  If you have already completed these steps with the SmartView Internal install for Microsoft Dynamics GP, you do not need to complete them again.

 

light45

If SmartView External release 2.0.44 or prior is being updated  to SmartView External release 2.0.51 or newer, please take note of any Favorites that are being used in SmartView External with the Grouping Feature.  Any favorites that have the grouping feature included in them, may have to be altered.  A fix has been released to match up the grouping fields between Internal and External, but this may cause the favorites in External to group on incorrect fields.

 

To update the SQL Objects:

1.In Microsoft Dynamics GP, go to Microsoft Dynamics GP – Tools – SmartView – Create Views.

clip0008

 

2.Mark all the companies listed if they aren’t already marked.
3.Click Create.

 

light45

By running the Create Views process, it will drop and recreate all of the SmartView SQL Views in each company database.  If you have modified any of those views, those modifications will be lost.

 

 

To update field cache:

1.Run the Refresh Field Cache process by navigating to Microsoft Dynamics GP – Tools – Field Maintenance in Microsoft Dynamics GP.
2.Once in the Field Maintenance window, go to Maintenance – Refresh Field Cache.

clip0009

 

3.There isn’t a window that open for this, but you will see that it processes for a minute or two, and once it is done, you can navigate around the Field Maintenance window again.
4.Click OK on the Field Maintenance window.