Getting You are not authorized to access table when opening a view

If you are getting this error message "You are not authorized to access table ‘ATable’ (ATable). Contact yur system administrator." when trying to open a View, one possible reason for it can be fixed very fast.

Getting Update operations are not allowed across companies message

I got this error recently: "Cannot edit a record in CBTestTable (CBTestTable). Update operations are not allowed across companies. Please use the changecompany keyword to change the current company before updating the record.". Of course, we all know what it means and how to fix it.

Understanding the length of Names EDTs

I stumbled some weeks ago over what you could call a normal issue, and although it looks like one should be aware of this, sometimes it fails to be obvious. I was getting a "Data would be truncated" message on committing a record in a standard flow (working with the workers, or something in that area).

Getting RecordSet based operations working with ValidTimeState

Reviewing some code I've come across I noticed a strange behavior: working with the same table, in two different modes yielded two different results. The task requested was to translate a while select statement into an insert_recordset operation.

Understanding the Data Dictionary Synchronize (II): SQLDictionary

Continuing the topic of how the DD Sync process works, today we are talking about the objects' IDs and SQLDictionary table from SQL Server. Each object in AX (mainly classes,  tables and the columns, with the emphasis placed on tables and columns right now, since that is what gets committed in SQL Server) gets an ID in order to identify them. In AX 2012 the ID is allocated at the moment of the object's creation in the ax system (either through a xpo import, new object in AOT, or model import).

Understanding the Data Dictionary Synchronize

A very important aspect of the every day life in AX is the Data Dictionary Synchronize process. If you do not fully understand it, sometime you can find yourself in a situation where you don't know how to recover from the errors it raises.

Understand date format required in a sql statement (II)

Browsing through the Global class, I just recalled the conversion function that can be used to insert data values in the SQL statements.

Understand date format required in a sql statement

I always forget this, and stumble across from time to time: the format of a date value that I want to include directly in a x++ sql statement where clause.

Create an Identity column in AX

It so happens that from time to time you get the request in AX to create a column that will increment it's value by one with each record you create (basically the Identity column property in SQL).