Given that the Invoice Date, Invoice Amount and Cash Payment are in the O/E Order Header as well as Salesperson (could be used for the Clerk) I would think GridView might get you close to what you want for balancing cash.

I will be in Barbados (Holetown) starting September 26th, perhaps we should get together to discuss.