G
Guest
I am looking to use Access to automate my accounts receibable cash
application, and provide reports of remaing open transaction, Unapplied
payments, and Payments that do not match the transaction amount. I have
multible charges and payments for a given transaction reference. I have the
Transaction and Payments in two simple excel spreadsheets. It is eash to add
monthly data to the Invoice and Payment tables. I need help with the querrys
to make this work.
application, and provide reports of remaing open transaction, Unapplied
payments, and Payments that do not match the transaction amount. I have
multible charges and payments for a given transaction reference. I have the
Transaction and Payments in two simple excel spreadsheets. It is eash to add
monthly data to the Invoice and Payment tables. I need help with the querrys
to make this work.