Sage Intelligence - Adding a new field/table to the canned financial statement container

Question

I would like to add a new field from a new table to the canned financial container in Sage Intelligence, which is written as a lengthy SQL query. I have tried to use the following syntax: 
 S ELECT [GACCGRUPYM].[GRU_0] AS "GROUP" 
 FROM ([GACCGRUPYM] 
 LEFT JOIN [GACCGRUPYM] 
 ON [GACCOUNT].[ACC_0] = [GACCGRUPYM].[ACC_0]) 
 � 
 and no matter where I put it, either all together or broken up among the various SELECT and FROM statements in the SQL query, I cannot get it to work. Can anyone give me some help as to how to add this field to the container? 
 �

jnoll · Accepted Answer

I am not exactly sure what you are trying to accomplish but your ON will not work as you have not declared the left side of this UNION in your FROM statement. I think this might help you make it work. if you want the GRU_0 from the GACCOUNT table then you may want the Option #2 I provided below. 
 Option #1 
 SELECT [GACCGRUPYM].[GRU_0] AS "GROUP" 
 FROM ([GACCOUNT] 
 LEFT JOIN [GACCGRUPYM] 
 ON [GACCOUNT].[ACC_0] = [GACCGRUPYM].[ACC_0]) 
 Option #2 
 SELECT [GACCOUNT].[GRU_0] AS "GROUP" 
 FROM ([GACCOUNT] 
 LEFT JOIN [GACCGRUPYM] 
 ON [GACCOUNT].[ACC_0] = [GACCGRUPYM].[ACC_0])

Sage X3

Sage Intelligence - Adding a new field/table to the canned financial statement container

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING