I want to have a customer ageing report, where the customers should be grouped according to hierarchy, of departments , where department hierarchy is defined as Dimension. I am confused how to relate the hierarchy from the department to the customers.
Hi Ritesh, Simplest way if you haven’t changed your Global Dimension 1 which is Department Code in GL Setup is: To Add Global Dim. 1(Dept Code) as Key to Customer Table 18 and then used it in Sorting. In the report you are designing/modifying select Glob. Dim. 1 in ‘DataItemTableView’ report, it should do the job. But if you are changing Navision existing report, look at consequences and try in a copy. Regards