Duplicate rows for job number

Kinetic ERP
1

Writing a baq/ dashboard that tracks in-process WIP by job number. Looking to add customer ID to the BAQ but keep getting duplicate rows caused by multiple sales order lines or quote line How do I remove the duplicate line but still get the customer ID- ( Using quoteDtl to get to customer as a sub query ) then to jobhead

any suggestions
thanks

2

trim down your fields on quotedtl to just the needed ones and set it to distinct if needed.

1 Like