Trying to create a query which looks at the following tables:
Deposit - ODPS
Deposit lines - OCHH
Payment means - RCT1
This query is aimed at providing a list of cheque details per deposit slip number, which includes specific UDF's which are sitting in the payment means/ cheque screen.
I would like the following information:
ODPS - Deposit
Where payment type = 'K' = cheque
Where payment number = [0%]
OCHH - deposit lines
When I bring the tables together, the lines duplicate.
I would greatly appreciate some assistance please.