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

Acumatica Generic Inquiries & Pivot Tables

Last Post by gonzo 9 years ago

3 Posts

2 Users

1 Reactions

2,486 Views

RSS

Posts: 18

gonzo

Topic starter

June 17, 2017 12:55 am

(@gonzo)

Eminent Member

Joined: 9 years ago

Hi Everyone,

Any tips on joining together Purchase Order header fields and Purchase Order Line fields.

2 Replies

Posts: 3204

Tim Rodman

Admin

June 17, 2017 12:57 am

(@timrodman)

Famed Member

Joined: 10 years ago

Hi Gonzo,

Purchase Order header fields are stored in the PX.Objects.PO.POOrder data access class and Purchase Order line fields are stored in the PX.Objects.PO.POLine data access class.

You can join them together on these two fields:

POLine.OrderType -> POOrder.OrderType
POLine.OrderNbr -> POOrder..OrderNbr

Acumatica Version 6.10.0472 used when composing this response

Posts: 18

gonzo

Topic starter

June 17, 2017 12:58 am

(@gonzo)

Eminent Member

Joined: 9 years ago

That seems simple enough. Thanks Tim.

12 Forums
2,530 Topics
11 K Posts
9 Online
2,418 Members

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

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

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

Online Members