Posts

Showing posts from June, 2014

Field 'VATNum' in table 'CompanyInfo' has not been explicitly selected.

Field 'VATNum' in table 'CompanyInfo' has not been explicitly selected. This is caused because of Field 'VatNum' in CompanyInfo Tables showing "Unretrieved values". You can do like this to solve the issue:  Update CompanyInfo directly in the table inside AOT                                         - or - Open SQL Server and use a script to update the DirPartyTable Table. CompanyInfo table is on SQL level stored in the DirPartyTable table. SQL Script: UPDATE DIRPARTYTABLE  SET VATNUM = '' WHERE VATNUM IS NULL  AND INSTANCERELATIONTYPE = 41 -- 41 is CompanyInfo TableID