Thursday, May 28, 2015

Do not apply Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2

Problem

Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 has a problematic change that will affect your implementation of the cumulative update.

The problem is in table 114, Sales Cr. Memo Header, where the number of field 1300, Canceled, is changed to 1301. A typical partner development license does not allow field changes, so you will run into the problem when you try to import CU 19.

Resolution

There is no good resolution at the moment (we are working on it), so here are two different ways to work around the problem.

Workaround 1: Rename the old field and merge the new field. Write code to copy values from the old field to the new field. See the following code snippet as an example.

SalesCrMemoHeader.SETRANGE("Canceled 2",TRUE);
SalesCrMemoHeader.MODIFYALL(Canceled,TRUE);
SalesCrMemoHeader.MODIFYALL("Canceled 2",FALSE);

Where “Canceled 2” is the renamed field.

Note:

You will not be able to remove the old field.

In table 112, Sales Invoice Header, field 1301, Canceled, is a FlowField that uses field 1301 in table 114 in its CalcFormula. Because table 112 is not part of CU 19, the CU will fail if you try to compile table 112 because it points to non-existing field 1300 in table 114.

Workaround 2: Import table 114 as a .fob file. (The partner development license does not allow deletion of an existing field if you import the table as a .txt file.)
1. Save the data in custom fields.
2. Import table 114 as a .fob file. (Note: This will remove the custom fields.)
3. Re-apply any customizations that you may have lost.
4. Move the data back.

Next Step

There will be a hotfix available to resolve this issue soon. We will link to the hotfix from the current KB articles and blog posts, and we will create a new announcement when it is ready.

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Sunday, May 24, 2015

Keyboard Shortcuts for Microsoft Dynamics NAV

Following table provides the shortcut key combinations in the Microsoft Dynamics NAV windows client and the Microsoft Dynamics NAV Development environment. 


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
Shift+left-click
On multiple column headers, the columns will all be sorted in the same ascending or descending direction.
Shift+double-click
If sorting on multiple column headers using Shift+left-click, use Shift+double-click on the first column that was clicked on and this will toggle ascending/descending direction of all the columns included in the sorting.
Left-click
Left-click on a column header to sort a column ascending, then left-click again to toggle between ascending and descending.
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

For original post click here

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara