I am trying to add detail retainage by invoice to an AR inquiry.  The inquiry is based on the AR - Status table.  I selected this table because it allowed me to see the AR information by customer by invoice and includes cash receipts that were posted to a customer, but not against an invoice (as in a pre payment situation).  I can't get the Retainage totals to balance to the GL totals.  Has anyone created an inquiry like this before that balances to the GL?