By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
June 16, 2017 11:50 pm
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
June 16, 2017 11:53 pm
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
June 16, 2017 11:53 pm
Perfect, thanks Tim
Online Members