Solved

Open Blanket PO Quantity on Inventory Summary

  • 21 July 2023
  • 5 replies
  • 82 views

Userlevel 2
Badge +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?

icon

Best answer by ericwolfe74 18 October 2023, 03:48

View original

5 replies

Userlevel 5
Badge +1

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.  

Userlevel 2
Badge +1

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.

Userlevel 7
Badge

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

Userlevel 2
Badge +1

Unfortunately, not yet

Userlevel 5
Badge +1

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.  

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved