Mahmoud gives us SQL for a Purchase Order Processing – Prepayment Report
Dynamics GP Essentials: Purchase Order Processing – Prepayment Report
Sales, Purchasing & InventoryReporting & BI
Archived post from 2016. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.