It's apparently the week for unusual AX problems. I have custom, company-independent tables in AX that on first view always shows one particular record. This occurs if you access them from a form, view the tables directly, etc.
Open a form using one of the malfunctioning tables as a datasource and you only see one record.
Open a table directly (CTRL-O), and you only see that one record. However, if you hit the green arrow to re-execute the SQL query, the rest of the records appear.
I've tried dropping and reimporting the tables, adjusting the indices, deleting a variety of record combinations, but nothing has any effect. If I delete the one row that appears, another one replaces it as the one appearing record. Add that row back in (new RecId, same data) and that row resumes its original position.
I exported these tables from another system where they were working perfectly. I also imported the exact same structure to another instance on the same Dynamics server, and everything works perfectly.
Any suggestions?
Are you absolutely sure you're running the client on the same version as your application? Check to see if your Kernel version matches the Application.