Invalid column name 'Document No_'. after upgrade to 2013r2

181deepak
181deepak Member Posts: 95
edited 2015-02-16 in NAV Three Tier
Hi experts,

I am getting below error for sales line table,

Microsoft Dynamics NAV

Invalid column name 'Document No_'.
Statement(s) could not be prepared.

Page Edit - Sales Line must close.
OK


please give solution, tried every thing that is available on internet.

Comments

  • Marijn
    Marijn Member Posts: 69
    Well, underscores are prohibited in field names. Check how NAV names it's own fields when exposing through webservices to check it out. How did you end up with this name? Where did it come from?
  • Marijn
    Marijn Member Posts: 69
    Apperently, something or someone changed '.' into '_' to be safe, not knowing that an underscore is not allowed.

Categories