AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Report De...
Link the SOOrder ta...
 
Notifications
Clear all

Questions Link the SOOrder table with DiscountDetail table

 
Acumatica Report Designer
Last Post by daniel 6 years ago
3 Posts
2 Users
1 Reactions
1,069 Views
RSS
daniel
Posts: 92
 daniel
Topic starter
April 21, 2020 5:32 pm
(@daniel)
Estimable Member
Joined: 6 years ago

In the schema builder on the report Designer,  how could we link the SOOrder table with the DiscountDetail table?

 

This for the Sales Order report, and I'm trying to display some of the Discount Details fields on the report.

 

I just cant figure out how to build a relationship between the two tables. 


2 Replies
ncantral
Posts: 24
 ncantral
April 22, 2020 5:11 pm
(@ncantral)
Eminent Member
Joined: 6 years ago

Try joining SOOrder to the SOOrderDiscountDetail on OrderType and OrderNbr.

 

Here is an example from a subreport that we use to display the discounts in a report footer. 

image

Reply
daniel
 daniel
(@daniel)
Joined: 6 years ago

Estimable Member
Posts: 92
April 28, 2020 1:25 am
Reply toncantralncantral

Thanks heaps for this @ncantral this works great!


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 24 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
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

  • amassey
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×