By using this website, you agree to our Terms of Use (click here)
Hi all. I'm attempting to add the Drop Ship PO # to the stock Sales Orders GI by connecting the SOOrders table with the DropShipPOLine table in the GI. Ideally the results would display a single line per Sales Order # with the MAX (most recent) Drop Ship PO # showing (or NULL if no SO line items are set to Drop Ship). Currently my results are showing duplicate lines, and if I try to Group by Sales Order # then some of the additional financial data gets thrown out of whack (like the Order Total, Unpaid Balance, etc.)
Any thoughts on how I might go about weeding out the duplicate results?
What's the join criteria you used on the Relations tab?
Here you go!
@mho Make sure you are doing a Max aggregation on the Order Totals rather than a Sum aggregation.
Online Members
