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 Generic I...
Joining Together Pu...
 
Notifications
Clear all

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

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by gonzo 8 years ago
3 Posts
2 Users
1 Reactions
2,315 Views
RSS
gonzo
Posts: 18
 gonzo
Topic starter
June 16, 2017 11:55 pm
(@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
John Doe Updated
Posts: 3193
 John Doe Updated
Admin
June 16, 2017 11:57 pm
(@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

Reply
gonzo
Posts: 18
 gonzo
Topic starter
June 16, 2017 11:58 pm
(@gonzo)
Eminent Member
Joined: 9 years ago

That seems simple enough. Thanks Tim.


Reply
John Doe Updated reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 33 Online
  • 2,412 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
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

  • John Doe Updated
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×