I am creating an invoicing table that has Item, Lot and QtyOrdered. Is it possible to see per lot allocation by sales order number? I know you are able to see the qty on hand/lot. For example, if I have an item that exists in multiple lots, I only want the per lot allocation qty to show along side each lot instead of the total qty along side each lot. 

 I want to see something like this opposed to the following: 

Thanks for looking, any help is greatly appreciated!