This content has been marked as final. Show 6 replies
You can use Concurrent request : "Mass Close of Purchasing document" as another option in Purchasing side.. Please have a look..
It depends on the release you are: this mass close program is new functionality in R12.1.1
If you use encumbrance accounting there is also 1 dissadvantage of this new program: I cannot set the status to Finally Closed, only to Closed.
We are on 18.104.22.168 version on Ebiz suite. Please let me know the different options available to close the open purchase orders.
In R11i this can be done:
- manually via the PO Summary form.
- you could kind of automate it with dataload.
- if you really want to automate it you will have to create a concurrent program to call the po_actions.close_po api. See recent post about this: PO_ACTIONS.CLOSE_PO NOT WORKING
We load PO's from excel to OEBS with the freeware winparrot.
I guess you can with this tool quickly do a macro to close thousands of PO's.
I would use a Dataload program
If it's a one-off or there aren't too many to do (say less than 50), you can download Dataload Classic for free which replicates key strokes to undertake transactions in Oracle
If there are hundreds to do on a regular basis, it might be worth spending some money on a professional dataloader
I got Dataload Professional (c£350) 12 months ago and have never looked back. It is fast, pretty reliable and never skips lines. However, I'm sure there are others out there too. As ever, probably best to google and DYOR.