Options

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

181deepak181deepak 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

  • Options
    MarijnMarijn 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?
  • Options
    MarijnMarijn Member Posts: 69
    Apperently, something or someone changed '.' into '_' to be safe, not knowing that an underscore is not allowed.
Sign In or Register to comment.