By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
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
