Because we control serial numbers for much of our products, I have one separate line for each purchased item. This means for the majority of items I can’t have qty>1. But I want to generate a Purchase Order pdf showing the sum of each product, to send to my provider. I can’t figure out how to show this sum for the items in a Purchase Order. Does anyone know how could I do it?
These are the basic connections I have between some of my tables.