Dynamics NAV - Item Attributes vs LS Retail Attributes

• LS Retail has an Attributes list that can be used to add multiple attributes to an Item, Customer, Vendor
• These can also be displayed on the POS
• Can be selected as a Hard Attribute on the Retail Item Card
• Will be passed on to LS OMNI, and will be visible when requesting items
• NAV also has an Item Attributes
• These can be assigned directly to items, or to item categories
• The values will be displayed in the Item Attribute factbox in the item list
• 
  

Dynamics NAV - Configuration Templates

These can be used to set default values for Items, Customers, Vendors, Etc.

Item Category now has an Item Template Code field

Item Categories can also have their own attributes using the Item Categories page from Financials

• Create Config Template that matches your item categories
• Set all default values that should be populated on the Config Template
• Assign Config Template to Item Category
• When Item Category is used, all default values will be applied
• Item Categories can have parent categories
• Parent categories are existing categories in the item category table
• Child categories inherit all attributes from parent categories
• This allows for a complex hierarchy structure to be setup for Parent categories and regular categories

Dynamics NAV - Image previews do not display after importing image link records

This is because a Media Set ID is calculated in the Tenant Media Set table for each database as whenever a picture file is physically imported.

You must re-import all pictures, or write a codeunit to insert the new media set index values into the Tenant Media Set table of the new db.

SQL - Count All Rows in All Tables

SELECT T.name AS [TABLE NAME],
       I.rows AS [ROWCOUNT]
FROM   sys.tables AS T
       INNER JOIN sys.sysindexes AS I
               ON T.object_id = I.id
                  AND I.indid < 2
--WHERE T.name like 'Cronus%'
ORDER  BY I.rows DESC

Dynamics GP is Slow - Use SQL to review Query Performance

https://www.codeproject.com/Articles/579593/How-to-find-the-top-most-expensive-cached-queries

Management Reporter - Crashes when trying to import Building Blocks

The screen itself is bugged, do not mouseover anything on the screen
Use the keyboard to tab and arrow to navigate, and crtl+a to select everything, then tab down to import and hit enter

Dynamics GP - SSRS - Migrate SSRS Objects to new Server

https://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/

• Use The RSScripter tool
• Download from 
• http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter
• Look in the archive download link
• Use it to copy all SSRS objects from one location to another
• Run the tool on the current ssrs server to capture all objects
• It will generate a cmd file
• Edit the cmd file
• Change the server name to the new server
• Remove the rs.exe path
• Run the file to push all objects to the new site