for example:

I would like 1 current price per item per customer:

These would be all the items a particular customer has bought in the past, with the current price of that item should he buy again in the future:

CUSTCODE: ITEMNUMBER: PRICLIST: DESC: BASEPRICE BASEUNIT
R02415 BE01060 C CLAMATO JUICE 8X1.98L 30.99 CASE
R02415 BE01434 C WATER PERRIER 24X330ML 16.99 CASE
R02415 BE05401 C APPLE JUICE 15.90 CASE

However, I am getting multiple pricinf for the same item and customer:

CUSTCODE: ITEMNUMBER: PRICLIST: DESC: BASEPRICE BASEUNIT
R02415 BE01060 C CLAMATO JUICE 8X1.98L 28.75 CASE
R02415 BE01060 C CLAMATO JUICE 8X1.98L 29.99 CASE
R02415 BE01060 C CLAMATO JUICE 8X1.98L 30.99 CASE
R02415 BE01434 C WATER PERRIER 24X330ML 16.59 CASE
R02415 BE01434 C WATER PERRIER 24X330ML 16.95 CASE
R02415 BE01434 C WATER PERRIER 24X330ML 16.99 CASE
R02415 BE05401 C APPLE JUICE 13.29 CASE
R02415 BE05401 C APPLE JUICE 15.90 CASE