Purchase order help

SUGGESTED

Hi

I'm looking for an add on that will help me find what sales order a purchase order that has just had stock allocated is linked to. 

Ideally I would allocate a purchase order for say 1 banana, 1 apple, and 1 orange and the add on would tell me that the banana is for order 123, the apple is for order 124 and the orange is for stock. 

At the moment I am running a shortfall report every morning to Excel, printing the purchase orders and checking each individual item against the excel spreadsheet. I'm sure there's an easier way to do it and it would save so much time if it was possible. 

Thanks for any help