Track total pending quantities from Supplier

There are purchase receipts when the receipts with less than ordered happened but the POs are closed. the User wants to track the total pending quantities from the supplier.

Solution:

Generate Purchase orders summary report,

Export to Excel

Consolidate the due quantities.

This is the best solution with out cost. Beyond this, it needs customization.