Is there a good way in BAQ to connect RMAHead to Shiphead without picking up extra lines?

Hello,

I am trying to bring in both Ship Date and Tracking number from ShipHead to a BAQ currently containing: OrderDtl, Customer, RMADtl, RMARcpt and RMAHead.

The point of the BAQ to is show RMA Line information.

I can’t find a way to connect them without getting extra lines.

I tried doing an inner subquery containing InvcDtl and ShipHead and marked all fields as ‘Group By’ but that didn’t seem to help.

I was trying to use InvcDtl for the RMANum to connect to RMAHead in main query.

If there is a better way to connect ShipHead to the above tables then let me know please.

Any help is appreciated.

When building a BAQ go one table at a time ensuring you’re not getting duplicates. Then you’ll know which table is causing the duplicate. There is a protentional of multiple shipments to a OrderDtl so you could be seeing a situation with multiple lines because of multiple packs.

1 Like

I can link RMAHead, RMADtl and RMARcpt and get the expected number of records.

When I try to add OrderDtl to the mix, it is multiplying some records.

An example is a sales order with 2 lines:

  • Line 1 shows only 1 record
  • Line 2 should have 4 records (Because it has 4 RMA reciepts) but has 8 (4 sets of 2 duplicates).

For the life of me, I have no idea why that is happening.

Do you have any ideas?

RMADtl has OrderNum, OrderLine, and OrderRelNum fields. So at a guess the order line has two releases. I’d link RMADtl to OrderRel.