Sage 50 Accounts

Trying to add the component location on the sales order with bom details, but it shows the location of the last item in the bom for every component in the bom. Has anyone else come across this or what I have done wrong?

So this question is based on a report I've been working on for while and just can't crack. I'm trying to create a report which is effectively a total requirement list for a Sales Order. It needs to list the sales line items together at the top (effectively…