Questions Link the SOOrder table with DiscountDetail table

Acumatica Report Designer

3 Posts

2 Users

1 Reactions

1,103 Views

RSS

Posts: 92

daniel

Topic starter

April 21, 2020 6: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

Posts: 24

ncantral

April 22, 2020 6: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.

daniel

(@daniel)

Joined: 6 years ago

Estimable Member

Posts: 92

April 28, 2020 2:25 am

Thanks heaps for this @ncantral this works great!

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed