Joining APOBL/APIBH to something that shows me the Invoice OEINVH, Order OEORDH or even the customer details

SOLVED

Hi

I've got a simple SQL query the shows details of invoice payments from APOBL but I'm struggling to join details of the customer or the actual order/invoice they have paid up.

Is anyone able to help me please?

Cheers

Andy

Parents Reply Children
No Data