In Sage X3, we may come across a situation where we need to create  query tool by adding fields  from the table also while adding field we may get the below error as shown in fig 3. Step1 :- To create query tool Go To -> Set up -> Usage -> Reports -> Query tools. … Continue reading How to create query tool to get desired output in Sage X3 V12