Hello,
I am trying to create a report to return SO lines related to production orders. The AM Tran table contains a custom field which flags each item that needs to be printed on the report so I need that table in the report. That table is causing duplications based on production transactions related to the items. I was able to get rid of duplicates by adding a condition to join on lot/serials and a grouping on AM Batch number, but our client wants the grouping on SOLine.InventoryID, Alt ID, and a custom field on the SO Line. When I changed the groupings it began duplicating the lines when the Lot/Serial was the same but the items appear on different labor tickets.
Does anyone have any suggestions on what I can add to the join or grouping to get rid of duplicates? I am unable to share the XML due to sensitive data.
