Material used for 1 Customer

Our sister company requested a report detailing how much of a certain part
they used this year. I thought this would be easy but I'm having trouble
finding the right link between the part transaction table and the customer
number field. Anyone have a report that would do this? We are on 5.0