Query Tool to export data from different tables in excel format

SUGGESTED

Hi,

I am using query tool to look at the data in ITMMASTER, ITMSALES,ITMBPS and ITMBPC tables using EXCEL sheet. Below is the screen shot of the fields that I want to use to get the data.

But I keep receiving this error when I try to validate.

Could someone help me understand the Query tool and How to make it work please.

Thank you!

Parents
  • It seems like the issue could be related to how the tables are linked or indexed. If the tables (ITMMASTER, ITMSALES, ITMBPS, ITMBPC) aren’t automatically linked, you might encounter validation errors. Double-check your linking settings in the Advanced tab and consider adding indexes to the tables to improve compatibility. Using Crystal Reports or a similar tool could also provide more robust linking options. For users managing data related to TraceShipments, ensuring these tables are properly linked is crucial for accurate shipment tracking and reporting. Sage University offers excellent training resources that might help resolve these issues.

Reply
  • It seems like the issue could be related to how the tables are linked or indexed. If the tables (ITMMASTER, ITMSALES, ITMBPS, ITMBPC) aren’t automatically linked, you might encounter validation errors. Double-check your linking settings in the Advanced tab and consider adding indexes to the tables to improve compatibility. Using Crystal Reports or a similar tool could also provide more robust linking options. For users managing data related to TraceShipments, ensuring these tables are properly linked is crucial for accurate shipment tracking and reporting. Sage University offers excellent training resources that might help resolve these issues.

Children
No Data