AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Generic I...
Adding Drop Ship PO...
 
Notifications
Clear all

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

Questions Adding Drop Ship PO # to Sales Orders GI

Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 1 month ago
4 Posts
3 Users
0 Likes
325 Views
RSS
Michael Ho
Posts: 16
 Michael Ho
Topic starter
June 3, 2022 8:25 pm
(@mho)
Member
Joined: 9 months ago

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?

3 Replies
Royce Lithgo
Posts: 544
 Royce Lithgo
June 5, 2022 9:32 pm
(@roycelithgo)
Member
Joined: 3 years ago

What's the join criteria you used on the Relations tab?

Reply
Michael Ho
Posts: 16
 Michael Ho
Topic starter
June 6, 2022 12:55 pm
(@mho)
Member
Joined: 9 months ago

Here you go!

image
Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 7 years ago

Member
Posts: 2957
December 27, 2022 10:54 pm
Reply toMichael HoMichael Ho

@mho Make sure you are doing a Max aggregation on the Order Totals rather than a Sum aggregation.

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 7 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×