How to close lots of open Purchase Orders at once?

[Former Member]

I have a situation here, business creates Purchase Orders using a third party software and it creates open purchase orders in SAP B1, because the open purchase orders are a lot business import mass invoices using the DTW to prepare for payment. The open purchase orders and open purchase invoices do not have a link with each other, eventually the A/P Invoices are closed by a payment. The Open purchase orders remain open. What will be the best way to close the Open purchase order without using the manual procedure of closing one by one?

[KennedyT21 · Accepted solution]

Hi Samuel Mhlanga.....

Try This way which is simple way ..

Use the Open List item Under the purchasing Reports ...

Select The purchase order on the top legend and select the required po and right and select close

Hope helpful

Regards

Kennedy

[Former Member]

Hi Samuel,

You can try using DTW to close those PO

[pvsbprasad]

Hi,

Try this

Create a A UDF in header with values(Y,N)

Now we can close Using DI API.which are values Y

Regards,

Prasad

[Former Member]

Hi,

It is recommend to change the process in importing AP invoices so that they can link to PO and PO get closed automatically.

However, manual close is the only safe way for all exiting open PO.

Thanks,

Gordon