Open POs for a part

Hi ​@ronhu, You can use the ‘Purchase Order Lines’ window for this. Query to your desired part + status as ‘released and confirmed’ (or excluding closed/ cancelled). Then you can see all your open PO lines for this particular part. You can take a excel export of this as well as a workaround.

Hope this helps.

If this resolves your question, please mark it as the best answer. So that it will be helpful for other peers.

Kind regards,

Sayuri.

​@Sayuri Perera Thank you for your reply.

We are thinking of this way, but it will have multiple duplicate records for the same PO number, i.e. one PO owns the same part multiple times.

I think we might do sum() group by PO no, part no