Skip to main content
Question

Update Purchase Order with Open Pre-Receipts to correct Availability

  • July 14, 2025
  • 2 replies
  • 60 views

plambert
Semi-Pro III
Forum|alt.badge.img+3

We have an overseas Vendor from whom we make large orders which frequently come in multiple shipments. When they send a shipment, we get an advance listing of the details of the partial shipments, like lot numbers, final quantities, or discounted items, which we use to get the purchase receipt set up in advance to make receiving go more smoothly. Additionally, since undershipping and overshipping are also common, we adjust the Purchase Order to reflect what the final quantities are so that our Availability figures are correct. Our issue is that when we have a first pre-receipt created, the purchase order cannot be edited until that first shipment is received and processed, so any items on subsequent shipments can’t have their availabilities updated or any other adjustments made which come with the vendor’s shipment confirmation. We can have open receipts like this for weeks to months.

 

Is there a way to only lock down individual lines of a PO which are on an open receipt instead of the entire order? Or, perhaps, enable a PO to be edited (put on hold) when there are open but on-hold receipts? We’re looking for a solution that doesn’t involve deleting and recreating pre-receipts whenever we get a new confirmation and have to change the order or waiting until the very last day before a shipment arrives to build the pre-receipt.

We have looked into Blanket POs, but those both don’t impact availability and introduce additional PO numbers, which may cause confusion, since the vendor ships against the blanket PO but the receipt is tied to the child PO number. It would take some very hands-on maintenance to make Blanket POs work, so we’d prefer to avoid going that route.

 

Thank you for any suggestions or insights you have!

2 replies

MelissaLutrick26
Freshman I

Have you tried creating an adjustment PO when you receive the Pre receipt? You enter a negative amount for the lines that were undershipped and positive for the overshipped. When both POs are processed you should come out with your actual. 


plambert
Semi-Pro III
Forum|alt.badge.img+3
  • Author
  • Semi-Pro III
  • May 13, 2026

Hmm, that’s an interesting idea. At the end of all of the receiving the PO comes out to be the right amount so we don’t need to process an offset-POs. But… it would be a tool to temporarily adjust our availability numbers to have an offset PO that we can change in the period between receipts. This availability gaps can cause issues with the number of sales orders we think we can handle and impacts the re-purchase decision making.

Perhaps a timeline of processing will better highlight the issue we’re having. For simplicity’s sake, say we’ve ordered 100 qty of two items at the start of April. We get notice after a week that 90 Item1 are shipping and it’ll take a month to get here. Then, after another week, we get notice that only 75 Item2 are shipping.

4/1 PO - 100 Item1, 100 Item2

4/7 PO - 90 Item1, 100 Item2; PR1 - 90 Item1

4/14 PO - 90 Item1, 100 Item2; PR1 - 90 Item1; PR2 75 Item2

Our issue is that we can’t update the PO to reflect the eventual undershipment and even creating the second PR does not change total availability, because technically there’s still the remaining 25 on the PO. However, to your idea, if we temporarily create a second PO with a -25 qty then it would fix our apparent availability. Then when we receive the first PR we could update the real PO’s quantity and delete the offset PO line as we make the second prereceipt.

Thank you for the idea! I’ll work with our purchasing manager to see if this works for them.
Small edit: A hitch in the plan. Negative PO lines do not reduce availability. Darn!