Making Cross-Company Tables in AX Semi-Company Aware

By David Boll | October 25, 2015

When using AX, there are a lot of times where you want data to go across companies, but still need some records to be company specific. The easiest way to accomplish this is by creating a cross-company table in AX. You would do this by first setting the to-be, non-company specific with the below metadata (circled in red):

Cross Company Table

You would then add a field called “CompanyID” or something similar. I would highly recommend against using DataAreaID. Then on the table you would add a find method that would take the key fields. The find should look something like this:

public static <Table> find(Key1 _key1, Key2 _key2, etc., boolean _update = false)
{
	<Table> table;
	table.selectForUpdate(_update);
	select table
		where table.CompanyID == curext()
			&& table.Key1 == _key1
			… etc
	if (!table)
	{
		select table
		where table.Key1 == _key1
			… etc
}
return table;
}

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X