I have an issue. I have 2 entries in my warehouse summary (summarized by lot number) that have the identical information except number of UNITS.
WH ID Loc. Lot No. HYBRID UNITS NET SHIPPED LEFT TO SHIP
511 15541 4T985 450 500 -50
511 15541 4T985 250 500 -250
My issue is, when I enter 500 NET SHIPPED it automatically takes 500 units from both rows. Is there a way to distinguish between the two?