Hello everyone,
I am trying to create an invoice report using BAQ. Among the data I needed, there was data in OrderRel, so I joined OrderRel as shown below. When I did that, the same invoice line was displayed as multiple lines, as you can see below. I tried changing the join type, but it didn’t work.
How can I set this up to solve this issue?
Please help me. Thank you in advance.
You need to change your tables/joins:
InvcDtl links to OrderRel on Company, OrderNum, OrderLine and OrderRelNum. This needs to be a Join Type of “Matching rows from InvcDtl” so that you include invoices that are not linked to Sales Orders
OrderRel links to OrderDtl on Company, OrderNum, OrderLine with the standard join type
OrderDtl links to OrderHed on Company, OrderNum
thank you so much. I handled this issue perfectly with your advice.
