With the advent of the Dimension Set feature in Microsoft Dynamics NAV (Navision), it can be tricky to figure out how to change the Dimension Set ID assigned to a record in code or how to assign new dimensions to code. If you don’t know what you’re doing, you’ll spend a few hours writing stuff to go through all the possible dimension sets until you find just the right one, or your code determines that there isn’t a valid dimension set at all and you have to create one
Tag Archives: Set
Dynamics NAV 2013 – Dimensions Sets
Let’s take a look with an example from the Cronus Data. This is Sales Order 101005 from Cronus Canada Inc. Here we see the dimensions for the Line, the header has the same dimensions set.
Dimension Set Entries Overview
This topic describes how dimension set entries are stored and posted in Microsoft Dynamics NAV.
The Query returned no rows for the data set
If you are using RTC and previewing certain reports you probably will run into this error. “An error occurred during local report processing.” The Hidden expression for the textbox ‘……’ contains an error: The query returned no rows for the data set. The expression therefore evaluates to null.