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?