Skip to main content
Solved

Open Blanket PO Quantity on Inventory Summary

  • July 20, 2023
  • 6 replies
  • 268 views

Forum|alt.badge.img+1

When we figuring out stock depletion, we often run into trouble with quantities on open blanket purchase orders. For example, we will look at inventory summary and inventory allocation to see a list all current inventory on hand, supply and demand. However, there doesn’t seem to be any report tied to the inventory item that includes quantities open on a blanket PO. As a result, contracts reflected in blanket PO’s are overlooked when we’re planning the phase out of an item resulting in all sorts of issues like restocking fees, large scrap values or modifying deployment plans.

Is there any way to have visibility to open blanket PO quantities when looking at inventory summary or allocation? Is there any reason that these screens wouldn’t/shouldn’t include quantities on blanket PO?

Best answer by Anonymous

The only other option I’ve seen used is a standard PO with multiple lines, each with a different due date with the last line being the balance and an attribute created to use as a user defined field for the PO to identify the expiration date but it would be a manual process to manage.  

6 replies

  • August 15, 2023

I would recommend looking at the Blanket Purchase Order Details by Inventory Item.  This will show the blanket POs for every item, the open quantity and the remaining quantity.  It will also show the order date and the date the blanket PO is set to expire.  


Forum|alt.badge.img+1
  • Author
  • Jr Varsity II
  • August 15, 2023

Hi Eric -

 

Thanks for that. I’m aware of that screen however my main issue is that it’s an extra step which can be easily overlooked. It’s counter-intuitive that inventory summary shows all supply & demand, including PO’s, but specifically does not show supply from blanket POs.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 12, 2023

Hi @amit61 were you able to find a solution? Thank you!


Forum|alt.badge.img+1
  • Author
  • Jr Varsity II
  • September 15, 2023

Unfortunately, not yet


  • Answer
  • October 18, 2023

The only other option I’ve seen used is a standard PO with multiple lines, each with a different due date with the last line being the balance and an attribute created to use as a user defined field for the PO to identify the expiration date but it would be a manual process to manage.  


  • Freshman I
  • October 2, 2026

Has anything ever been improved with this?

How do people handle shipments with multiple PO’s, or partial PO shipments?

If we could make a blanket PO that would show up on inventory reports, and also count on supply (So that the auto replenishment recognizes it)    This would be so helpful. 

 

 As an example, say we have items A, B, and C. 

Our vendor is in Japan.

 

PO001 has items A and B on it.

PO002 has item C on it. 

 

Our vendor ships item A from PO001, and item C from PO002 in the same box, but item B is not ready yet. This is coming from Japan, 1 month shipment time.

 

PO001 and PO002 were blanket POs, we could receive them to a Shipment PO, enter shipment info, now people can see its coming. Then we would leave item B left on PO to ship later.

 

But blanket POs do not show up on any inventory reports I can find. They are also not counting on supply, so if we create a blanket PO for items, and we have auto replenishment set, this ignores anything on the blanket PO, which makes zero sense. 

 

Otherwise, how would you handle this scenario? We have tried it with receiving these items to a PR as they ship, but that also creates a set of problems.