Hi Barb,

I do not believe a GridView composite table exists that connects all of the IC Item Master, IC Quantity by Location and a sales transaction file that keeps the location/branch code (either IC Transaction History or OE History details or Sales Analysis Transactions). The Quantity by Location file is required to report on that value, and the sales by location values must come from a transaction file, as the IC Item Sales History amounts are statistics from all branches.

Wth current tables, you can get either the quantity on hand or the sales by branch, but not both.