Friday, 16 December 2016

Cannot alter 'PURCHLINEVIEW_IN' because it is not a table

We hit this issue in DEV environment, not sure how it happenned in the first place, but this table "PurchLineView_IN" has been created as a View in SQL.

Due to it shouldn't appear as View in the first place, so I deleted it straight away from SQL, then rerun the sync from AX. It then created the "PurchLineView_IN" as table in SQL instead of as a View. The sync issue is resolved.