AnsweredAssumed Answered

inventory balance by lot # and then location

Question asked by eabhishek on Jun 3, 2017
Latest reply on Jun 4, 2017 by eabhishek

I have created a database with tables and relationship to link an item with various lot # and location as attached. I want to show running balance for each location for a lot # of an item. Attached is a List View sorted by Item_ID, Lot_ID, and then Location_ID but the balance field doesn't restart summary for each sort group when sorted by Lot_ID or Location_ID. So what is wrong in my setup?

Outcomes