3. A MAS report is considered "canned" if it is on the Reports menu. If it is listed on the Custom Reports menu then it is created from scratch by someone else. 

Can you please explain why #1 and #2 is important to you.

BigLouie - thanks!  

A Crystal Reports user here created a sales by salesperson report that uses AR_Customer, AR_InvoiceDetail and AR_InvoiceHistoryHeader tables only.  She is comparing it to an Inventory Sales History report in MAS that has a report setting of 'salesperson summary' and also shows sales by salesperson  (I do not know if the report setting was a custom feature our previous provider added because I was not here then.)

Taking one salesperson as an example, for one sales period March, the numbers are not matching up between the two reports. Inventory Sales History report is about $5K more than the Crystal Report.

Looking to understand links and fields being used in Inventory Sales History to see if we are even comparing apples to apples.  Thanks again!

Note that the created report probably uses non-inventory items such as special items and misc charges while the Inventory report does not.

Thanks again and that will have to be looked at.  But, regardless, is there a way to do the following:

1) how do i know how the tables are linked (joined on what field(s)?) to produce the work table? where can I see this?

2) how do I know what  specific fields are being used from each table to produce the report?

Thanks again. Really appreciate your input.

A good way to guess what tables are used is to go to custom office user-defined field maintenance, create a UDF in the wrk table and see what tables show up in the Data Source drop box.

As for how the tables are linked or what fields are used, they are in the code that populates the wrk table and you can't see that.

Hello,

I'm new to SAGE. So would it be possible for you to guide me as " how to view contents of a work (wrk) file and  how to view what tables are used to make a work file, " That you have mentioned in your post as you know how to look at the work table.

Any help would be appreciated.

Thank you.

I am so glad I found you response.  I am always trying to figure out what data files are used in work files.  Thank you very much!