Query for Purchase Orders and A/P Down Payments

[former_member823938]

Hi,

I was requested to build a report containing the following and would like know the query for it:

For each Purchase Order:

1. Total amount

2. Total down payment

3. Total paid, whether for down payment or separately. If for down payment, is it paid in full or partially?

4. Remaining amount

Thanks.