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

181deepak

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.

Marijn

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

Apperently, something or someone changed '.' into '_' to be safe, not knowing that an underscore is not allowed.