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.