Would I be correct in thinking that these are reconciliation groups?

If you have 3 receipts and 10 invoices with cross associations in the reconciliation they all need to be in the same reconciliation group....

not sure exactly how to solve the problem yet, but cursors is NOT a nice solution.

Which version on MSSQL are you on.