PO Lines replicating in the BAQ

,

I’m creating a BAQ to show PO history and part of that is including details from the header and line. When I link these two tables together it’s causing the PO lines to replicate and show up multiple times throughout the report. Is there a way to pull in information from both tables and not have the PO lines replicate?

Are you seeing a line form one order showing up under another order? Like line from Order 101 showing up on a row for order 102.

If so, that means you are missing some relationship.

If you linked in the OrderRel table, then you are going to get a row fro each release too.

For example, Order 101 has 1 line with 2 release, and Order 102 has 3 lines with 3 releases each.

You should see

OrdNum   OrdLine  OrdRel
   101       1       1
   101       1       2
   102       1       1
   102       1       2
   102       1       3
   102       2       1
   102       2       2
   102       2       3
   102       3       1
   102       3       2
   102       3       3

Even though you only want 4 rows for the 4 lines of the two orders.

Check out this thread to get multiple row info into one row.

1 Like