BMI Microsoft Dynamics NAV Blog

Navision / Dynamics NAV - Cannot View Data In Balance by Dimension

Posted by Amy Valenzano on Mar 19, 2014 12:00:00 PM

I've had a few support calls from clients where their Navision executables have just been upgraded and now the Balance by Dimension form does not show any data.  The entire form is uneditable. 

This is a fairly common issue when the Navision executables are upgraded to NAV 2009 or higher. 

The code in form 408-G/L Balance by Dimension needs to be modified to the following (bold is the fix)

DimCodeToOption(DimCode :
Code[20]) : Integer

CASE DimCode OF

  '' :

    EXIT(-1);

  UPPERCASE(GLAcc.TABLECAPTION) :

    EXIT(0);

  UPPERCASE(Text001) :

    EXIT(1);

  UPPERCASE(BusUnit.TABLECAPTION) :

    EXIT(2);

  UPPERCASE(GLSetup."Global Dimension 1 Code") :

    EXIT(3);

  UPPERCASE(GLSetup."Global Dimension 2 Code") :

    EXIT(4);

  ELSE

    EXIT(-1);

END;

Topics: Navision, Dynamics NAV, Microsoft, MS Dynamics, Dynamics NAV 2013, Microsoft Dynamics NAV