Create Report on ERPNext Cloud

First, let me start by saying I’m on ERPNext cloud and I know reports are limited to report builder reports. So… I’m looking to create a report that can show me what purchase invoices/orders are yet to be submitted/processed.

We do not invoice our customer until ALL supplier invoices have been received and entered. As such, I’ve created a report on purchase invoice that can show me what’s still in draft mode. The issue is really around purchase orders and determining what does not have a purchase invoice. Any ideas? It seems I cannot add a column that displays if there’s a purchase invoice linked to the purchase order?

thanks for any insights!

1 Like

Do you have a Purchase Register report in Purchase Invoice ?

1 Like

I do! But, not sure how it helps? I need it to go the other way - show me the PO’s that don’t have a PI linked…