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…

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 …

Check out this thread to get multiple row info into one row. [image] BAQ: Calculated Field Concatenate Rows to single field Experts' Corner You can use one of these methods to do it I’ve done it with the XML method in E10 …

PO Lines replicating in the BAQ

Epicor ERP 10

Banderson (Brandon Anderson) March 16, 2019, 12:29am 3

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

Topic		Replies	Views
Multiple lines in BAQ to consolidate into 1 line item Epicor ERP 10	1	3361	August 29, 2018
BAQ giving me Duplicate lines in data Epicor ERP 10 baq	4	723	October 1, 2024
BAQ Multiple Rows Epicor ERP 10 baq	29	6442	October 27, 2020
BAQ Results duplicating Epicor ERP 10 dmt , e10 , bpm , customization , baq , rest , ssrs , reports , e10-erp	1	498	June 3, 2021
BAQ - Multiple info in One field Epicor ERP 10 baq	15	5030	September 4, 2020

PO Lines replicating in the BAQ

Related topics