When running the cash flow exposure report, the system is considering purchase order lines invoice payments in the future as intended. The issue I am having is that the report is considering the total value of the PO line and not subtracting any advance payments that have been made to the supplier.
If the over all invoices is for $1,000,000 but we have made $500,000 in advance payments, then the future cash flow should show -$500,000. It is currently showing the entire $1,000,000.
The advance payments are showing as separate lines under the incoming balance section with the cash flow type = Supplier on Acc. Payments
Does anyone know how to solve this issue?