Skip to main content
Solved

Clear Create Purchase Orders


Forum|alt.badge.img

Is there a way to clear out Create Purchase Orders (PO505000) screen without creating a PO ? 

 

Best answer by Gabriel Michaud

Hi @yisroel39,

If Create Purchase Orders is showing Sales Order lines that are marked for PO, then you have to uncheck this from the Sales Order.

If the demand you see was generated from the Prepare Replenishment screen, then there is no way that I know of to clear this other than creating the purchase orders. If you have a very large number of POs pending you could also clear the relevant item plans from the database via SQL: 

DELETE INItemPlan WHERE PlanType='90'

You must run “Validate Inventory” (IN505000) after this query.

View original
Did this topic help you find an answer to your question?

8 replies

Gabriel Michaud
Captain II
Forum|alt.badge.img+10

Hi @yisroel39,

If Create Purchase Orders is showing Sales Order lines that are marked for PO, then you have to uncheck this from the Sales Order.

If the demand you see was generated from the Prepare Replenishment screen, then there is no way that I know of to clear this other than creating the purchase orders. If you have a very large number of POs pending you could also clear the relevant item plans from the database via SQL: 

DELETE INItemPlan WHERE PlanType='90'

You must run “Validate Inventory” (IN505000) after this query.


mvolshteyn
Acumatica Moderator
Forum|alt.badge.img+3
  • Technical Account Manager in the ISV Team
  • 109 replies
  • April 16, 2021
Gabriel Michaud wrote:

Hi @yisroel39,

If Create Purchase Orders is showing Sales Order lines that are marked for PO, then you have to uncheck this from the Sales Order.

If the demand you see was generated from the Prepare Replenishment screen, then there is no way that I know of to clear this other than creating the purchase orders. If you have a very large number of POs pending you could also clear the relevant item plans from the database via SQL: 

DELETE INItemPlan WHERE PlanType='90'

You must run “Validate Inventory” (IN505000) after this query.

In this case, you can select these items in the Prepare Replenishment screen with Qty to Process = 0


Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 40 replies
  • April 16, 2021

 

mvolshteyn wrote:

In this case, you can select these items in the Prepare Replenishment screen with Qty to Process = 0

 

Thank you! I used this method.


Forum|alt.badge.img+2
  • Semi-Pro I
  • 122 replies
  • April 16, 2021

I have had random items that show needing ordered but don’t. I cleared them by opening the Inventory Replenishment and remove filters to show all items. I then filter to the items that keep showing up on the Create PO Screen. Select the row, put 0 in the Qty to Process column and then click Process.


hayleehicks
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 108 replies
  • May 23, 2022

Does anyone know how to clear a line off the Create Purchase Orders screen when its an SO to Purchase Plan Type? It looks like the order has been deleted as it doesn’t reference an order the mark for PO box can be cleared from. I recalculated inventory from the period the requested on date falls in, and that didn’t clear it. Thanks!


Forum|alt.badge.img+2
  • Semi-Pro I
  • 122 replies
  • May 24, 2022
hayleehicks18 wrote:

Does anyone know how to clear a line off the Create Purchase Orders screen when its an SO to Purchase Plan Type? It looks like the order has been deleted as it doesn’t reference an order the mark for PO box can be cleared from. I recalculated inventory from the period the requested on date falls in, and that didn’t clear it. Thanks!

Update it to a PO and then delete the PO. 


hayleehicks
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 108 replies
  • May 24, 2022

Hi @amajors! The line on the Create PO screen has qty zero. It will not let me create a PO to then delete. Any other ideas?


Forum|alt.badge.img+2
  • Semi-Pro I
  • 122 replies
  • May 24, 2022
hayleehicks18 wrote:

Hi @amajors! The line on the Create PO screen has qty zero. It will not let me create a PO to then delete. Any other ideas?

I know I’ve had a similar experience before. I believe that I either reported it as an issue that was cleared up by Acumatica or I created a dummy order, created the PO, canceled the order and canceled the PO. Sorry I can’t recall exactly which way it was handled.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings