Skip to main content

Posts

Showing posts with the label reindex

Get total number of records for all table and synchronization tips in Ax 2012

To Get total number of records from all table and Export data  into excel in Axapta 2012 you can apply below tips. Go to AOT(CTR+D)->Tool->Number of Records to bring in excel select all  records then press Control +T key You can get exact steps from below video clips. To Reindex and synchronize table from Microsoft Dynamics Axapta You can apply below tips System administration -Periodic-Database -SQL Administration To get exact step see below clips. You can subscribe to get more updates.

SQL Error can not select record from table abc in MSD axapta

Some times we face this error which is SQL Error " can not select record from table abc " in axapta application. This error comes due to some index problem or record duplication in table to resolve this problem we can do following. 1. Find index which creating problem you can re index that index. 2. Restore table using right click on table restore option. 3. Synchronize table if problem still not resolved. 4. If problem still not resolved then try to synchronize whole data dictionary in AOT. 5. If you are facing problem due to duplication of records then try to delete duplicate records. By using above steps I hope your problem will resolve.