Hi Afin, You can go to" SQLDICTIONARY " table and try to delete the fields which are not required with respect to the tables, Once you are done with this synchronize the table again and I believe you will get desired results Even if the issue persists send me the evenlog wil check and let you know
Regards Abhishek Mehta, ________________________________ From: thomas 'znal' ramdhan <thomasramd...@gmail.com> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wed, June 9, 2010 9:30:34 AM Subject: [Axapta-Knowledge-Village] Synchronize issue Dear all, I have an issue in synchronizing PurchReqLine table. Actually this table has already customized, and the issue came because we restore the database from the live database to test database (the problem faced in test database). I have deleted all customizations in PurchReqLine table, and tried to synchronize again. The result was still failed. I saw in event viewer and they told that some field could not delete due to no valid field in SQL. Then I deleted all customized field in SQL manually, and then re-synchronize again, the result was still failed. The AX still try to delete the SQL server fields since no valid fields again in SQL Server. The condition right now is back to standard again, and I expect there's no problem again with synchronizing. What should I do to make the synchronization success ? Thanks and Regards, -Afin-