One of our clients has a strange request but I still have to answer.
The purpose of the exercise is:
-I must calculate the balance of the bills by month of billing. 70% of payments received are related to invoices through a structured communication. But 30% of the payments are not related to any invoice. So I must try to assign payments to the oldest bills and identify the remaining balance.
Should I answer by No it's not possible or can someone see a solution ?