Closing po without commiting stock

You could do it by a SQL Statement but I am not sure why you would want to mark a PO Closed that is Open (effectively a PO that has not had any items received on it). Why not just Delete the PO? (You should never delete a PO that has items that were received on it.)

Unless this is a Partial PO and you want it Closed. If it is you can open the PO for Receiving and with out changing any of the Qty Received field press the Comit button you will be asked if you want Close the PO which will mark the Qty Ordered equal to the Qty Received to Date.

Robert Armstrong RMS Systems Inc.

you could use a sql command to manually set the po's as received:

update e set quantityreceivedtodate=quantityordered from purchaseorderentry e join purchaseorder p on e.storeid=p.storeid and e.purchaseorderid=p.id where status=0 and potype=1

update purchaseorder set status=2 where status=0 and potype=1

"new user" wrote:

The only problem I can see with doing this is those new POs will not be associated to the items with respect to Item Movement. The Item Movement History will still have orphaned records because they will be linked to the PurchaseOrder.ID which were deleted. Otherwise Matt's suggestion will work for what you need.

Robert Armstrong RMS Systems Inc.