NAV Integration

I have inserted data directly from a SQL DB to NAV. The data got inserted successfully but when i try to read the same in the table the following error occurs. "THE TABLE CONTAINS A VALUE IN THE CODE FIELD THAT CANNOT BE USED WITH MYCROSOFT DYNAMICS NAV CLASSIC. FIELD: LEAVE CODE VALUE: CL-OFF. Is it due to hyphenated values? Any suggestions…?

Welcome to DUG…

Make sure that you have inserted all capital characters in code type field from SQL

Thanq… It worked…