I am creating a GL account tree of sorts by using default dimensions in NAV 2016. My dimension codes are Rollup category 1, 2, etc. assigned to all GL codes. I am attempting to run a filter from the defualt dimension table based on the dimension value code to pull a string of GL numbers. No matter how I try it, I get back either value errors or blanks all the way down. Is it because the account has multiple dimensions associated with it?? Once I include the dimension value code into the mix, I can no longer retrieve data.
Link Dimension value table to G/L Entry table