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...
Linking Po to multi...
 
Notifications
Clear all

Questions Linking Po to multiple Sales orders

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 8 years ago
3 Posts
2 Users
0 Reactions
5,386 Views
RSS
Posts: 6
 Sam Ellis
Topic starter
February 23, 2018 2:40 pm
(@sam-ellis)
Member
Joined: 8 years ago

Hi Tim,

If a Po is created and multiple sales orders are created after the PO is there anyway to still link the new SO's to the purchase order?

 

Thanks,

Sam

 


2 Replies
Tim Rodman
Posts: 3196
 Tim Rodman
Admin
February 23, 2018 10:53 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Yes, but it's clunky.

First, it's good to be aware that the Purchase Order Line link is actually stored on the Sales Order Line. Specifically, it's stored in the SOLineSplit table. So, technically, you can link one Sales Order Line to multiple Purchase Order Lines or one Purchase Order Line to multiple Sales Order Lines.

To your question though. Let's say you have a Purchase Order that needs a quantity of 2.

 

Then later two Sales Orders some allow each demanding 1.

Make sure the Inventory ID and Warehouse match on the lines. Then check the Mark for PO box on the Sales Orders (SO301000) screen and click the PO LINK button.

 

I think it puts in the default Vendor for the Item so clear that out to ensure that you see all Purchase Order Lines. Then select the line and click the SAVE button to form the link.


Reply
Tim Rodman
Posts: 3196
 Tim Rodman
Admin
February 23, 2018 10:54 pm
(@timrodman)
Famed Member
Joined: 10 years ago

One thing to be aware of. It's been a while since I tested this. But I think that once the Purchase Order is received, the Inventory ID will get hard allocated to the Sales Order line which may or may not be what you want.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 36 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Invoice subreport for line-level tax breakdown not tieing to taxes subtotal
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

 No online members at the moment

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.

‹›×

    ‹›×