最近我公司的AX2009服务器上的应用程序日志中老是会报下面的错误，不知是什么原因


Object Server 01: The database reported (session 22 (andy)): [Microsoft][SQL Native Client][SQL Server]列名 'W9' 无效。. The SQL statement was: "SELECT TOP 1 A.ACCOUNTNUM,A.NAME,A.ADDRESS,A.PHONE,A.TELEFAX,A.INVOICEACCOUNT,A.VENDGROUP,A.PAYMTERMID,A.CASHDISC,A.CURRENCY,A.LINEDISC,A.BLOCKED,A.ONETIMEVENDOR,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.TELEX,A.PRICEGROUP,A.MULTILINEDISC,A.ENDDISC,A.PAYMID,A.CUSTACCOUNT,A.VATNUM,A.COUNTRYREGIONID,A.INVENTLOCATION,A.YOURACCOUNTNUM,A.DLVTERM,A.DLVMODE,A.BANKACCOUNT,A.PAYMMODE,A.PAYMSPEC,A.MARKUPGROUP,A.CLEARINGPERIOD,A.ZIPCODE,A.STATE,A.COUNTY,A.URL,A.EMAIL,A.CELLULARPHONE,A.PHONELOCAL,A.TAXGROUP,A.FREIGHTZONE,A.CREDITRATING,A.CREDITMAX,A.PAYMSCHED,A.NAMEALIAS,A.ITEMBUYERGROUPID,A.CONTACTPERSONID,A.PURCHPOOLID,A.PURCHAMOUNTPURCHASEORDER,A.INCLTAX,A.VENDITEMGROUPID,A.DEL_RESIDENCEFOREIGNCOUNTRY,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.PAYMDAYID,A.DESTINATIONCODEID,A.LINEOFBUSINESSID,A.SUPPITEMGROUPID,A.BANKCENTRALBANKPURPOSETEXT,A.BANKCENTRALBANKPURPOSECODE,A.DEL_PRINTMODULETYPE,A.CITY,A.STREET,A.OFFSETACCOUNT,A.OFFSETACCOUNTTYPE,A.PURCHCALENDARID,A.PAGER,A.SMS,A.DEL_REFZIPCODE,A.PARTYID,A.TAXWITHHOLDCALCULATE,A.TAXWITHHOLDGROUP,A.NAMECONTROL,A.INVENTSITEID,A.SEGMENTID,A.SUBSEGMENTID,A.COMPANYCHAINID,A.MAINCONTACTID,A.VENDPRICETOLERANCEGROUPID,A.SMALLBUSINESS,A.PARTYTYPE,A.LOCALLYOWNED,A.BIDONLY,A.W9,A.DEL_NPIBANKINGFACTORINGACCOUNT,A.SERVICETYPE_SA,A.FILENUM_SA,A.SUBCONTRACTOR_SA,A.ORGANIZATIONNUM_SA,A.ICMSCONTRIBUTOR,A.DEL_VATNUM_TH,A.MODIFIEDDATETIME,A.DEL_MODIFIEDTIME,A.MODIFIEDBY,A.CREATEDDATETIME,A.DEL_CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID,A.MEMO FROM VENDTABLE A WHERE ((DATAAREAID=?) AND (ACCOUNTNUM=?))"

 

将VendTable表同步下试试。