Wednesday, December 13, 2017

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.

Tuesday, December 12, 2017

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

Saturday, December 2, 2017

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

Friday, December 1, 2017

Dynamics GP - SSRS - Migrate SSRS Objects to new Server




Saturday, November 25, 2017

Dynamics NAV - LS Retail - POS Transactions - IsReturnSale, Voided, Training


  • "Transaction Header"."Sale Is Return Sale" - True Is return
  • "Transaction Header"."Entry Status" - Option set  ,Voided,Posted,Training

Dynamics NAV - LS Retail - Item Import


  • Create a Retail Vendor
  • From the Vendor Card, go to Vendor Setup to define the file import format (You can copy this from any existing vendor

  • Place the file to be imported in the location defined in the vendor setup

  • Click Import File
  • This will create a file in NAV in  SUPERPHARMTT/Franchise/Item Import Files
  • Select your file, click “Set Status as OK”
  • Go to SUPERPHARMTT/Departments/LS Retail/Replenishment/Item Import/Item Import Journal
  • Click Navigate>Get Import Lines
  • Select your item import file>Click OK
  • Click Create/Process
  • If there are any errors, you deal with the errors accordingly