Sale with multible lots missing Info

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!

1 comment

Please sign in to leave a comment.