Hello Community!
I am looking for a solution to solve my payment fisaco!
Currently, I receive CSV files from my banks. I need to make a batch that can automatically apply payments to the appropriate accounts. Information that would have to be added is; Customer Number, Name, Date, Paid By (what bank), what method of payment, reference number, payment amount. The next due date also has to roll over to the next month, not 3 month if 3 invoices are paid. I also need a report that shows me all the next due dates to make sure that they are correct. Also, when applying payments and there is an overpayment and credit to apply these correctly. (We've had to create many historical invoices and this has been such a pain!!)
I want to receive reports on this daily along with my other cron jobs for the day.
Does anyone have any insight or suggestions on how to solve this problem?
Thank you!
Chelsea