*** UPDATE *** Seems that Data Emphasis IS conditional. I updated the end of this article. Just scroll down… .
A big issue since the release of NAV 2009 is the 'lack' of colors. There was no possibility whatsoever regarding "coloring your fields on pages". Now, since NAV 2009 Service Pack 1, Microsoft introduces "Data Emphasis" as an enhancement. Let's try to find out what this is about and if it's really an enhancement (there is still no manual for this … so I'll have to do this on my own … (I'm just mentioning this to earn a little bit more credit … (… i'm going to shut up now … (…the word you're lookig for is … again … anywaaayyyy...)))).
I will take page 21 (Customer Card) and page 22 (Customer List) as pages to experiment with.
If we open the properties of the "No."-field of page 21, we notice these new properties :
The Style-property can have 5 values:
While the StyleExpr-property can contain either a variable (of the data type "boolean") or the strings "TRUE" or "FALSE".
Let's take it easy
Let's configure the "No."-field of Customer Card page like this:
If I run this page (remember that you can use the "run"-button in SP1), nothing really exciting is going on…
No colors, no emphasis whatsoever. Don't panic. Notice that you're in "view"-mode. Apparently, there is a difference for data emphasis in the different modes of a page. When you go in edit mode (you can do this by hitting CTRL+N (create new record) and scrolling down (by hitting CTRL+PgDn)) , you see that there IS a certain "emphasis", namely the value of the "No."-field is red:
That was simple, wasn't it?
Now, I tested with "Attention", but what with the other Option Values? Well, here's the list:
What about using these in a list?
When using these properties in a list, you'll notice there is no difference between view and edit mode. So, I just edited my list and changed the properties for the fields "No.", "Name", "Location Code", "Contact" with the result being a real "color-book":
Sorry dude, I only use conditional coloring. How do I do that?
Official statement of Microsoft: this is a no-go! (WHAT?? - Then there is no "bleeping" (remember the X-Files?) use for it, is there?). Now, hold your horses. I'm reading it as "this is not possible RIGHT NOW". Although .. What's that StyleExpr-property used for then?? Let me try to find out.
The property StyleExpr can hold a variable of the type "boolean". So let's just try to work with a variable and put it in the property. I created a variable blColorIt and set it TRUE when the "Location Code" of the customer was "YELLOW". Simple, isn't it. I put my code OnAfterGetRecord (seems most obvious for me)
blColorIt := ("Location Code" = 'YELLOW');
Unfortunately, it's indeed a no-go. All compiles well, but I get this error when running the page:
I've initialized my variable on every possible trigger I could find in my page, without succes. So, I'm guessing it's an internal issue … a feature that is not supported yet. If anyone succeeded in getting this to work … please don't hesitate to comment on this post … .
For me, coloring fields without conditions doesn't make much sense (may be for identifying mandatory fields … but that's it (imho)). But the fact that things are in place to make it conditional gives me hope that in the next release … it WILL be conditional after all.
Also keep in mind: I'm testing on a Technical Preview, not an official release … so the hope is still there that everything will be in place on the final release of NAV 2009 Service Pack 1 :-).
UPDATE!! (Thanks to wito)
No, it's not a no-go. You see, there is a new property on variable-level, namely "IncludeInDataset". If I set this to "yes" for the variable "blColorIt" and then test it again, you see this:
You clearly see that it works and is conditional. And you know now how to do it (as me … thanks, wito!).
I've put this into a new seperate blogpost so that the rss-subscribers got notified about the (rather quite important) turnaround of this post.
All of a sudden, the data emphasis on SP1 is very VERY useful for me. Coloring is possible, even conditional coloring. OK, only 4 types, but I can understand that Microsoft wants to "streamline" in some way. Let's use all the same emphasis for a corresponding status… .
Sure there is still a disadvantage. What if I want to color it Green OR red. Then, my friend, I think you do have a problem. Anyway ... let's embrace what we have now, and hope Microsoft keeps working on this.
The fact that I didn't know about this property makes me again very … let's say … MAD at Microsoft for still not having released NAV 2009 in Belgium. I'm sure that (and me being a little bit too lazy) is one of the reasons… .
Important: This article was updated in a new blogpost. I suggest you read the new version of it here.
Recently (read: today) I contacted Microsoft for a list of shortcuts in Sp1. Apparently it was already in the help-file of NAV 2009 SP1 CTP2, so you can imagine how embarrassed I was by asking this question. On the other hand … this is the easiest blog post ever for me. Enjoy the list:
Move to the next field or character
Move to the previous field or character
Move to the field above in the same column
Move to the field below in the same column
Clear selected text
Close the window or undo the data entry
Move to the last field on a line
Move to the first field on a line
ARROW, TAB, ENTER
Move to the next field on non-line FastTabs
Move to the next editable field
Select Type to filter (field filter)
Drop down or look up to select
Refresh the active window
Go to the next frame
Copy the field above
Select the menu bar and display access keys
Select the navigation pane
View error message
Select Show Results (FlowFilter)
Open a lookup window (from an ellipsis button)
Go to the previous frame
Open the related card
Drop down or look up to view
Post and Print
Display a shortcut menu
Apply Entries, Get Source Doc, or Get Whse. Doc
Open the Role Center from the navigation pane
Move to the previous field
Collapse or expand the Action Pane
Create a new document
Select Search pages
Look up to the related list
Select the Action Pane and display key tips
Reconcile or Split Line
Select the address bar
Export to Microsoft Office Excel
Create a new record
Open the company
Export to Microsoft Office Word
Display next document or card in a list
Display previous document or card in a list
Move up while the selected line stays selected
Move down while the selected line stays selected
Open the About this Page/Report window (Zoom)
Delete the selected line
Move to the first line in a list
Move to the last line in a list
Save and close window (equivalent to clicking OK).
Insert new line
Select Limit totals to (table filter)
Clear all filters
Open a new card
Collapse/expand a line in a hierarchy
Open a card or a document in View mode
Open a list place in a separate window
Save and close the window and open a new window
Filter to the value in the field
Close window or close program
Collapse or expand the active frame
Display the Actions menu of the active frame
Display the Actions menu
Display the Related Information menu
Display the Reports menu
Display the Microsoft Dynamics NAV menu
Go to the previous window in the navigation history
Go to the next window in the navigation history
Move to the field below without opening the drop-down menu
Switch among open windows
Finally, it's time for all you partners to stop reading the "bla bla" and start doing the "boom boom". The Download of SP1 Marketing Beta VPC is available on Partnersource and you can download it here.
I would like to encourage you to download this VPC to get familiar with the new features or NAV 2009 as such. It's great for "readiness" and "awareness" to your consultants.
Hereby a new update of the platform updates… . Nothing much exciting, just a few new updates for 5.0, 5.0 Sp1 and 4.0 Sp3. I also added the links to NAV 2009 SP1 CTP1 and CTP2, although these are only available for early adopters and MVP's.
Decimal seperator on the numerical keyboard does not work
In the RTC it is not possible to filter on the "Blank" option in a Option typed field
Error message when you active the option MaintainSQLIndex or MaintainSIFTIndex in Microsoft Dynamics NAV 2009: "Cannot drop the index 'CRONUS International Ltd_$Cust_ Ledger Entry.$6'"
NAV 2009 SP1
***Only available for TAP partners
Some interesting version-specific links:
C/Front hangs while generating a lot of temp files
Selecting printer tray doesn't work
Locking error when printing a report with code in a form
Local variable in debugger
NAV Shows unexpected results when filtering, and may crash
Certain jobs can run slower after upgrading the client
NAV can crash in certain situations: E.g. error 1247 in module 19. No official KB URL available yet. though.
Cumulative Platform Update Rollup
NAV crashes when you try to open some forms
Error sending a document from Commerce Gateway to a server with BizTalk
Restore backup: Company Name 'xx' does not exist
All SIFT views of a table are rebuilt when changing the table
Changes in Production Schedule are not saved - Native only
XMLPort.EXPORT cannot handle DBCS Characters.
Permissions too restrictive when calculating flowfields with security filters (recordlevel security)
RunModal error screen when deleting record links in certain
Save report to html can save the wrong space characters.
Lookup list in report request forms do not open.
XML Ports do not import data that comes after a white space
Client crashes when using a global FieldRef variable
Error message when you restore a customer database on Microsoft Dynamics NAV 4.0 Service Pack 3 (SP3) Native backup to the Native option for Microsoft Dynamics NAV 5.0 SP1 Client: "Internal Error 1355 in Module 19"
The XML port returns an additional error message when you execute an XMLPort import in Microsoft Dynamics NAV 5.0 Service Pack 1: "The XML Parser setup fails"
The xRec and Rec are the same and the change log does not detect any changes when a record is changed from a sub form in Microsoft Dynamics NAV 5.0
You require a new platform feature to provide the functionality to limit the general visibility for users in Microsoft Dynamics NAV 5.0 Sp1
The Microsoft Dynamics NAV client crashes when you lose the connection to Microsoft SQL Server in Microsoft Dynamics NAV 5.0 Service Pack 1
*** Still not available
Menu items or menu groups that are sent to shortcuts disappear from the original menu in Microsoft Dynamics NAV 2009 or Microsoft Dynamics NAV 5.0
The card form does not show the detailed information for the record in a list form in Microsoft Dynamics NAV 5.0
Slow performance when you apply a filter to a form that is based on a large table in Microsoft Dynamics NAV 4.0 Service Pack 3 and Microsoft Dynamics NAV 5.0 Service Pack 1
The Microsoft Dynamics NAV client crashes when you reopen a company that contains certain customizations in Microsoft Dynamic NAV 5.0 Service Pack 1
Error when opening 4.x db in 5.x: "You do not have permission to modify the [Tablename] Table"
All object info is unexpectedly updated after upgrade db to 5.0 (SQL Server)
Error when renaming record: "you cannot rename a record because the new value is ''"
C/FRONT API stops responding when creating connection
"Two fields below must be the same type " or "No. xxxx is not defined in the contact profile answer table"
Locks are not released as expected
Crash when processing messages from MSMQ
Slow performance when running reports after client upgrade 4 to 5
several issues when you set a filter in a list form
NAV displays an incorrect character when using a DBCS character in a field
The XML port adds unwanted characters when you export data in a double-byte character set (DBCS) environment in Microsoft Dynamics NAV 5.0
The characters that indicate an empty HTML cells are incorrect displayed as " " in Microsoft Dynamics NAV 5.0
You experience slow performance when you restore some companies into a Microsoft SQL Server database in Microsoft Dynamics NAV 5.0
Microsoft Dynamics NAV 5.0 becomes unresponsive when you perform a search process in a list-type form
Error message when you perform the Copylinks function by using a recordref-type variable in Microsoft Dynamics NAV 5.0: "Type conversion is not possible because one of the operators contains an invalid type. Record := Recordref"
included in 4.0SP3!*
Update 2 – NODBC
F4 Delete function behaves inconsistently when pressing CTRL+A to select all records
NAV crashes when saving an object with large amount of text constants
NAS stops responding to events when a lock timeout occurs
NAV ignores specified printer tray selection when printing a file from second page or later
Slow performance when browsing a list in a form
Dynamics NAV client stops respoding when NAV calcs a SIFT
Error message when you open a company in NAV 4.0: "Property exceeds the buffer size"
Several issues when filtering an list form
NAV crashes on citrix if captions contain an ampersand
Inconsistent behavior when you search for the "RecordRef" data type records in different Windows operating systems and Microsoft Dynamics NAV versions
Error when printing a report: 'FORM NAME' cannot close because the system is currently working
Error when lock time-out occurs: "Function sequence error"
The characters that indicates an empty HTML cells are incorrect displayed as " " in Microsoft Dynamics NAV 4.0 Service Pack 3 (SP3)
Error message when you open a table in the Design mode in Microsoft Dynamics NAV 4.0: "Error 2 in module 5"
The BLOB data type cannot be performed on the RecordRefs object in Microsoft Dynamics NAV 4.0
Update 4 – NODBC
Update 2 – NODBC
Other interesting links: