Sage 100

**What files does a Sage 100 report use?** Can anyone point me to the file layouts info that shows what Sage 100 files are used by a Sage 100 report, e.g., the I/M Valuation Report? I could probably figure out at least some of the files, but in the past this 'Cross Reference by Program' info was simply available in File Layouts inside Sage 100. But currently it still only shows for Legacy (see attached). Thanks.

Is this what you're looking for? http://help-sage100.na.sage.com/2018/FLOR/index.htm#Business_Object_Cross_Ref_by_Table/TOXrefs.htm%3FTocPath%3DCross%2520Reference%2520Information%7CBusiness%2520Object%2520Cross%2520Reference%2520by%2520Table%7C_____1

Nice @SteveIwanowski but that still doesn't show which tables the valuation report is actually using to create the wrk file.

Not exactly, @SteveIwanowski; I had seen that, but thanks (so +1 @ThereseLogeais). In this case, that only says the Valuation Report uses the Valuation Report wrk file.

And how is that not helpful @BrettZimmerman ??? :wink:

I just got wind of a neat trick from a Consultant on our Sage 100 Team. If you pretend to create a UDF for the applicable work file, the Data Source drop-down appears to show the related files, in this case:

• AP_Vendor
• CI_Item
• IM_ItemCost
• IM_ItemWarehouse
• IM_ProductLine
• IM_Warehouse

This is a little similar to wanting to find out what files a particular Sage 100 function touches/updates. For example, if I needed to know what files get updated from A/P Invoice Entry, I would perform that function/Update and then look (via Windows Explorer) to see what files got updated (i.e., Modified Date) - although the 'Business Object Cross Reference By Table' that @SteveIwanowski referred to, appears to shows this info as well.

If there is a good cross reference like the legacy cross reference I havn't found it either, so I took a look at the code for IM_ValuationReport_rpt and it opens the following tables. CI_Item AP_Vendor IM_ItemCost IM_ItemWarehouse IM_ProductLine IM_Warehouse for whatever it is worth, I recently looked at the Inventory Valuation By Period report it uses the same tables but also includes the IM_PeriodPostingHistory table that table seems to be the base table for calculating the on hand quantity by looking at the beginning balance for the first period of the year and then adding/subtracting the activity for the following periods to come up with an ending balance for the period. I mention this because I've recently had 2 clients where the ""history"" tab in item inquiry was totally whacked out and the valuation by period report was also a mess. using the recalculate item history utility made the valuation by period correct.

I just saw Brett's posting - Genius!!!

Thanks for the confirmation, @DavidOverholt!!