• Registered: 02/25/2010
  • Posts: 12

Topic: Oustanding Purchase Orders

I have some purchase orders in the Outstanding Purchase Orders which have already been received and posted to stock. The grn_items table shows the items are received and inventory shows that everything is in stock. Item movements even shows the transaction but they do not show to be received in Purchase Orders.  When checking the item status, it shows the correct quantity on hand but also shows the received amount as still on order.

When viewing the Purchase Order Inquiries, click on # it shows the Deliveries and Invoices but all items show a quantity received of 0 and overdue.

Is there something I am overlooking or that I have done wrong? Will deleting the Received orders from the Purchase orders affect the inventory?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Oustanding Purchase Orders

I can not reproduce your session. I have tried forth and back and everything seems to work ok.
Hve there been some other operations that might have got it out of order?

/Joe

  • Registered: 02/25/2010
  • Posts: 12

Re: Oustanding Purchase Orders

Joe, it is very likely that I may have done something out of order. I am new to accounting software and still learning the flow and functions of everything.

As stated above, the items show on hand and still on order. Is there something I can change directly in the database to set everything as received? The other option is to cancel the orders but would it affect the inventory and stock moves?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Oustanding Purchase Orders

If you haven't entered the invoices yet, you can go into Supplier Invoice (not direct invoice) and select the supplier. Here you will see the Received items. Here you can remove the lines (you must be logged in as admin to do this operation).

Then you can enter the receivals again from outstanding PO. I hope this will work.

/Joe

  • Registered: 02/25/2010
  • Posts: 12

Re: Oustanding Purchase Orders

Joe, this has taken a while to figure out.

Your solution works if a product has been receipted to inventory - it can them be removed from the supplier invoice screen and it reverses out the receipted quantites.

What happened here was that a purchase order was partially receipted. Since I do not back order, there were items remaining that were preventing the POs from closing. I entered the edit screen to edit the PO and remove the items that were not receipted. Apparently when entering the PO edit screen on a receipted PO, it re-sets the qty receipted back to 0. This does not affect the inventory but now the PO shows that nothing has been receipted.

If this happens to anyone else, this can be resolved by receipting everything again then removing the duplicated items from in the supplier invoice screen as Joe has stated above. This removes the duplicated items from inventory and closes the PO. Is this the proper method of handling the cancelled items of partially receipted orders? Is the qty received re-set to zero in the PO edit screen by design or is this a bug?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Oustanding Purchase Orders

When removing GRNs from the Supplier Invoice, everything is taking care of.

/Joe