Restore File Associations

USE AT YOUR OWN RISK.

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.

 

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.

 

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.

Source: msdn.microsoft.com

 

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.

   Tip
   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

Source: msdn.microsoft.com 

 

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

 

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 https://chrome.google.com/webstore/category/apps 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.

WhatsChrome

 

Chrome All in One Desktop

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
• ADVANCED TECH-STYLING OF DESIGN AWARD WINNER
• POWERED BY CHROME OS (100 GB of Google Drive space for 2 Years)
• BOOTS IN SECONDS
• THOUSANDS OF APPS
• AUTOMATICALLY UPDATES ITSELF
• VIRUS PROTECTION BUILT-IN
• FLICKER SAFE
• 16 GB SSD STORAGE
• BUILT-IN MIC, SPEAKERS AND CAMERA
• CONNECTIVITY FOR USB, HDMI, RJ45, HEADPHONES AND MIC
• WEIGHS ONLY 3.5 KGS

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.