I am running a sales vs Inventory report and I am having a small problem. The report is set up to look at the lot sold and the receipt and storage date on the inventory side. I am using 3 tables. the report works but it the sale has more than one lot and it dosent pick up any of the lot information. I have attached a copy of what the report looks like when I run it. Thanks for your help!
Sale with multible lots missing Info