— The Forums are now read-only —

— All new activity now takes place here: —

Notifications

Clear all

Questions Joining Together Sales Order Header fields and Sales Order Line fields in Acumatica

Acumatica Generic Inquiries & Pivot Tables

Last Post by gonzo 9 years ago

3 Posts

2 Users

1 Reactions

3,538 Views

RSS

Posts: 18

gonzo

Topic starter

June 17, 2017 12:50 am

(@gonzo)

Eminent Member

Joined: 9 years ago

Hi Everyone,

I used the Inspect Element trick to find the fields that I want on the Sales Orders screen.

This works great, but the fields come from two different tables: SOOrder and SOLine.

How do I join these tables together?

2 Replies

Posts: 3204

Tim Rodman

Admin

June 17, 2017 12:53 am

(@timrodman)

Famed Member

Joined: 11 years ago

Hi Gonzo,

The Sales Order Header data access class is PX.Objects.SO.SOOrder.

The Sales Order Lines data access class is PX.Objects.SO.SOLine.

You'll need to join them together on the following fields:

SOLine.OrderType -> SOOrder.OrderType
SOLine.OrderNbr -> SOOrder.OrderNbr

Together, OrderType and OrderNbr form a unique key on the SOOrder table.

Acumatica Version 6.10.0472 used when composing this response

Posts: 18

gonzo

Topic starter

June 17, 2017 12:53 am

(@gonzo)

Eminent Member

Joined: 9 years ago

Perfect, thanks Tim

Forum Jump:

Previous Topic

Next Topic

Currently viewing this topic 1 guest.

12 Forums
2,533 Topics
11 K Posts
117 Online
2,439 Members

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

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

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