Restore File Associations


This solution will modify your windows registry.  Please make a backup of registry before proceeding further.

Download the below file, unzip it and run with administrative privileges:

Download Restore Association Registry file

This file restore all the incorrect associations of .LNK files.


Tags: , , , ,

Using Filters in Navision

Here is the breakdown of filters available.  When you enter criteria, you can use all the numbers and letters that you can normally use in the field. In addition, you can use some special symbols or mathematical expressions. Here are the available formats:

Symbol Meaning Sample Expression Records Displayed
= Equal to 377 Number 377
    BLUE Those with the BLUE code, for example, the BLUE warehouse code
    22 A datetime: from 22-current month-current year 0:00:00 to 22-current month-current year 22:59:59
    22 10 An exact datetime: 22-01-01 10:00:00
.. Interval 1100..2100 Numbers 1100 through 2100
    ..2500 Up to and including 2500
    ..12 31 00 Dates up to and including 12 31 00
    P8.. Information for accounting period 8 and thereafter
    ..23 From the beginning of time until 23-current month-current year 23:59:59
    23.. From 23-current month-current year 0:00:00 until the end of time
    22..23 From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59
| Either/or 1200|1300 Those with number 1200 or 1300
& And <2000&>1000 Numbers that are less than 2000 and greater than 1000.

The & sign cannot be used by itself with numbers because no record can have two numbers.

<> Not equal to <>0 All numbers except 0

The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <>A* meaning not equal to any text that start with A.

> Greater than >1200 Numbers greater than 1200
>= Greater than or equal to >=1200 Numbers greater than or equal to 1200
< Less than <1200 Numbers less than 1200
<= Less than or equal to <=1200 Numbers less than or equal to 1200
* An indefinite number of unknown characters *Co* Text that contain “Co”
    *Co Text that end with “Co”
    Co* Text that begin with “Co”
? One unknown character Hans?n Text such as Hansen or Hanson
  Calculate before rest 30|(>=10&<=20) Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses)
@ Ignore case (either uppercase or lowercase allowed) @location Text such as LOCATION, location or Location

You can also combine the various format expressions:

5999|8100..8490 Include any records with the number 5999 or a number from the interval 8100 through 8490.
..1299|1400.. Include records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).
>50&<100 Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).
*A*&*B* Text containing both A and B.
@*No?* Text containing no, NO, No, nO, such as cot, cope and incorporated.

NO, nO, No or no must be present, followed by at least one character, but there can be an indefinite number of characters before and after these, and case is unimportant.


How to Set Up and Use Google Cloud Print

Chromebooks do not support printing from local printers via USB port or network printers on other network. To print from your Chromebooks, you need to connect to the Google Cloud Print service and share a printer:

  • Download and install Google Chrome to the computer where the printer is connected.
  • Open the Google Chrome browser and sign in using the Google account information used to sign in to the Chromebook.
  • Click the menu button on the browser toolbar in the upper right corner of the browser window.
  • Click Settings.
  • Scroll down and click Show advanced settings.
  • Scroll down and, under Google Cloud Print, click Manage.
  • Click Add printers to search for and find accessible printers over the network.
  • Select the printer(s) that need to be added, then click Add printer(s).
  • A confirmation screen will load showing the printer is ready to go.
  • To see a list of printers that have been added click on Manage your printers.
  • Click print on the Chromebook, then click on the Change button next to where it says destination to select your printer.
  • Under Google Cloud Print click on the printer to print to.

Tags: ,

Create a Record from a Configuration Template

Applies To: Microsoft Dynamics NAV 2013

You can use the structure of data that is contained in the data templates to convert your information into records in the database, one-by-one. To do so, you use the Create Instance function. This is a miniature version of the data migration process and can be useful for prototyping or treating smaller data creation tasks.

The following steps illustrate how to create an item card from an item data template. You can create a record from any data template using the same procedure.

To create a record from a configuration template

  1. In the Search box, enter Configuration Templates, and then choose the related link.
  2. In the Config. Template List window, select the item template that you have created and choose Edit. For more information on how to create a template, see How to: Create a Configuration Template.
  3. On the Actions tab, choose Create Instance. An item card is created.
  4. Choose the OK button.
  5. To review the new item card, in the Search box, enter Items, and then choose the related link.
  6. Open the new item card.
  7. Expand various FastTabs, and verify that the information was created correctly on them.




Create a Configuration Template

You can create a new data template if the default templates do not the needs of your new company. If you are creating more than one, you may find it useful to adopt a naming convention for the Code field.

Create a data template

Each template consists of a header and lines. When you create a template, you can specify which fields to always apply to data of a certain type. For example, you can create different customer templates to apply to different customer types. When you create the customer using a template, you can use template data to prepopulate certain fields.

To create a data template header

  1. Open the Config. Template List window.
  2. On the Home tab, in the New group, choose New.
  3. In the Code field, enter a unique ID for the template.
  4. In the Description field, enter a description of the template.
  5. In the Table ID field, enter the table to which this template applies. The Table Name field is automatically filled in when the Table ID field is set.

To create a data template line

  1. In the Lines FastTab, on the first line, select the Field Name field. The Field List window displays the list of fields in the table.
  2. Select a field and then choose the OK button. The Field Caption field is filled in with the field name.
  3. In the Default Value field, enter an appropriate value. In some cases, you may want to use a value that is not a value that is available in the database. In that case, you can select the Skip Relation Check check box, to make it possible to apply data without error.
    Since the Default Value field does not have a look up to the corresponding Microsoft Dynamics NAV field options, you copy and paste the value that you want from the related page into the template.
  4. Select the Mandatory check box. The check box is informational only. It tells you that information must be entered in the field by the user, but no business logic is enforced. For example, you cannot invoice and post an order if posting groups have not been set up. Since posting groups are required, you can select theMandatory check box for those fields.
  5. In the Reference field, enter information about the field as needed.
  6. Choose the OK button




Opening the RoleTailored Client in Configuration Mode

To configure a profile, you must open the RoleTailored client in configuration mode.

To open the RoleTailored client in configuration mode

  1. At the command prompt, navigate to the root folder of the RoleTailored client. For example:
    cd C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client
  2. Type the following command:
    Microsoft.Dynamics.Nav.Client.exe -configure -profile:profileid
  3. Replace profileid with the name of the profile that you want to configure.For example, to configure the Accounting Manager profile, use this command to open the RoleTailored client in configuration mode:
    Microsoft.Dynamics.Nav.Client.exe -configure -profile:"Accounting Manager"


Navision 2013 – Keyboard Shortcuts

Microsoft Dynamics NAV Windows Client Development Environment Action
Right Arrow Right Arrow Move to the next field or character
Left Arrow Left Arrow Move to the previous field or character
Up Arrow Up Arrow Move to the field above in the same column
Down Arrow Down Arrow Move to the field below in the same column
Delete Delete Clear selected text
Esc Esc Close the window or undo the data entry
End End Move to the last field on a line
Home Home Move to the first field on a line
Tab Arrow, Tab, Enter Move to the next field on non-line FastTabs
Enter Move to the next editable field
F1 F1 Open Help
F2 Edit
F3 Select Type to filter (field filter)
F4 F6 Drop-down or look up to select
F5 Refresh the active window
F6 Go to the next frame
F7 Display statistics
F8 Copy the field above
F9 Post
F10, Alt F10, Alt Select the menu bar and display access keys
F12 Select the navigation pane
Shift+F1 View error message
Shift+F3 Select Show Results(FlowFilter)
Shift+F4 F6 Open a lookup window (from an ellipsis button)
Shift+F6 Go to the previous frame
Shift+F7 Open the related card
Shift+F8 F6 Drop-down or look up to view
Shift+F9 Post and print
Shift+F10 Display a shortcut menu
Shift+F11 Apply entries, get source documents, or get warehouse documents
Shift+F12 Open the Role Center from the navigation pane
Shift+Tab Arrow, Shift+Tab Move to the previous field
Ctrl+F1 Collapse or expand the ribbon
Ctrl+F2 Create a new document
Ctrl+F3 Select Search pages
Ctrl+F4 Look up to the related list
Ctrl+F7 View entries
Ctrl+F9 Release document
Ctrl+F10 Select the ribbon and display key tips
Ctrl+F11 Reconcile or split lines
Ctrl+F12 Select the address bar
Ctrl+C Ctrl+C Copy
Ctrl+G Go to
Ctrl+E Export to Microsoft Office Excel
Ctrl+L Show links
Ctrl+N Create a new record
Ctrl+O Ctrl+O or F12 Open the company
Ctrl+P Print
Ctrl+T Select sorting
Ctrl+V Ctrl+V Paste
Ctrl+W Export to Microsoft Office Word
Ctrl+X Ctrl+X Cut
Ctrl+Z Ctrl+Z Undo
Ctrl+Page Down Display next document or card in a list
Ctrl+Page Up Display previous document or card in a list
Ctrl+Up Arrow Move up while the selected line stays selected
Ctrl+Down Arrow Move down while the selected line stays selected
Ctrl+Left Arrow Move to the first field on a line
Ctrl+Right Arrow Move to the last field on a line
Ctrl+Alt+F1 Open the About this Page/Report window (Zoom)
Ctrl+Delete Delete the selected line
Ctrl+Home Ctrl+Home Move to the first line in a list
Ctrl+End Ctrl+End Move to the last line in a list
Ctrl+Enter Esc Save and close window (equivalent to choosing the OK button)
Ctrl+Insert F3 Insert new line
Ctrl+Shift+F3 Select Limit totals to (table filter)
Ctrl+Shift+A Clear all filters
Ctrl+Shift+C Copy Rows
Ctrl+Shift+D Show dimensions
Ctrl+Shift+E Edit list
Ctrl+Shift+R View list
Ctrl+Shift+Q Collapse/expand a line in a hierarchy
Ctrl+Shift+V Paste rows
Ctrl+Shift+W Open a list place in a separate window
Ctrl+Shift+Enter Save and close the window and open a new window
Alt Display access keys in the ribbon
Alt+F2 Toggle to display/hide FactBoxes
Alt+F3 Filter to the value in the field
Alt+F4 Alt+F4 Close window or close program
Alt+F6 Collapse or expand the active frame
Alt+F12 Optimize space for the current page
Alt+Left Arrow Go to the previous window in the navigation history
Alt+Right Arrow Go to the next window in the navigation history
Alt+Enter Move to the field below without opening the drop-down menu
Alt+Tab Toggle between open windows

Tags: , ,

Using WhatsApp on your Computer

For me, scrolling too much and typing long text on mobiles is very irritating but I love using WhatsApp for chatting and sharing whatever junk I have to share.

I was searching for ways as to how I can use WhatsApp on my computer.  I found a Chrome application ‘WhatsChrome’ that replicates my WhatsApp ID to my computer.

To install it on your computer just open and type  ‘WhatsChrome’ or ‘WhatsApp‘ in search box and hit Enter.

It will display some related apps.  I have tested ‘WhatsChrome’ and ‘WhatsApp Web Wrapper’.  Both are almost same apps developed by different developers.

To use them, you just need to click on ‘+ Add to Chrome’ button and rest everything will be done automatically.  On every run after installation, it asks to scan the barcode displayed on your computer screen.  For scanning this bardcode, open WhatsApp on your phone.  Go to Menu -> WhatsApp Web option.  It will open phone’s camera.  Place the phone in front of the screen to capture the barcode.

Scanning is quick.  Once scanned, it will open WhatsApp on your computer screen.  You may use this app to send and read the messages.

It will keep your phone in sync and for that, phone must be connected to internet.  If you are not connected to internet, you may not use WhatsApp on your computer.




Tags: ,

Chrome All in One Desktop

LG Chromebase 22CV241 - B All-in-One (4th Gen CDC / 2GB/ Google Chrome)

LG Chromebase 22CV241 – B All-in-One (4th Gen CDC / 2GB/ Google Chrome)

Recently I bought LG Chromebase 22CV241 for testing whether it may be useful for a normal user who usually works on browser, does a little word processing and uses spreadsheet a little.

It has been tested by several users and the feedback is very good.  Performance is excellent, big 21.5 inch Full HD display, built-in camera and mic etc attracts every user.  I personally feel that it can replace Windows PCs easily.  Some of the features are:

  • BRILLIANT 21.5(54.61 CMS) 1920X1080 FULL HD IPS DISPLAY
  • POWERED BY CHROME OS (100 GB of Google Drive space for 2 Years)

In my opinion it the best All In One Desktop for home users.


Excel Cell Displays the Function Instead of its Calculated Value

Problem:  I inserted a column and entered some formula into it.  But after pressing enter, it was displaying the formula itself instead of its calculated values. Solution:

  • Highlight the column (in my case), row or cells; wherever the problem is.
  • Right click on selection.
  • Select ‘Format Cells…‘ option.
  • Click on ‘Number‘ tab, if not already on it.
  • Click on ‘General‘ option under ‘Category‘.
  • Click OK to close the dialog box.
  • Recalculate the sheet/cells.

Tags: , ,