I have linked tables in the following order EKPO EKET, EKKO and EKBE.
I have got the report to show Purchase order, line item, stat date etc, but when I add EKBE, I only get shown purchase orders which have a transaction done on them already.
I want the query to show all purchase orders and lines whether it has had a movement on it or not.
Basically, I want this report to show whether a movement has been done or not on a purchase line item.
I have searched everywhere and cannot find an answer.