Home > Blog > Making Cross-Company Tables in AX Semi-Company Aware

亿博电竞下载

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):

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
																																																														
																																																															find(Key1 _key1, Key2 _key2, etc., boolean _update = false) {
																																																															
																																																																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; }
																																																															

																																																																 
																																																															

																																																																 
																																																															

																																																																

																																																																	Related Posts
																																																																
																																																																

																																																																	

																																																																		

																																																																			
																																																																				Setting up a New Company in Microsoft 亿博电竞 AX 2012
																																																																			
																																																																		
																																																																	
																																																																	

																																																																		

																																																																			
																																																																				Using TempDB Tables in AX 2012 Forms
																																																																			
																																																																		
																																																																	
																																																																	

																																																																		

																																																																			
																																																																				亿博电竞 AX Build Numbers
																																																																			
																																																																		
																																																																	
																																																																	

																																																																		

																																																																			
																																																																				亿博电竞 AX Add-Ons
																																																																			
																																																																		
																																																																	
																																																																	

																																																																		

																																																																			
																																																																				AX 2012 Keyboard Shortcuts
																																																																			
																																																																		
																																																																	
																																																																
																																																															

																																																													

																																																														

																																																															

																																																																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!
																																																																
																																																																

																																																																	亿博电竞 respects your privacy. We will never share your information with others.
																																																																
																																																															
																																																														
																																																														
																																																													
																																																												

																																																													

																																																														

																																																															

																																																																

																																																																	
																																																																		X
																																																																	
																																																																	

																																																																
																																																															
																																																														
																																																													
																																																												

																																																																

																																																																	
																																																																		We use cookies to ensure that we give you the best experience on our website. By continuing to use this site, you understand that cookies may be used.
																																																																	
																																																																	
																																																																		
																																																																			OK
																																																																		
																																																																		
																																																																			View Privacy Policy
																																																																		
																																																																	
																																																																	
																																																																
																																																															
																																																																				亿博电竞
																																																																				

																																																																					
																																																																						csgo完美世界
																																																																					
																																																																					
																																																																						加拿大28pc预测神测网
																																																																					
																																																																					
																																																																						飞鱼电竞下注积分
																																																																					
																																																																					
																																																																						加拿大28冷号APP计划
																																																																					
																																																																					
																																																																						lol联赛
																																																																					
																																																																					
																																																																						大圣电竞开盘