Forum Discussion
Tony2021
Oct 24, 2021Iron Contributor
Accounting Dilemma - Apply Amounts Received to Open Invoices
Hello, I have an issue with applying an amount received to a list of open invoices. Lets say I receive $1000 and there are 9 open invoices all with different amounts. I am looking for a simpl...
OliverScheurich
Oct 24, 2021Gold Contributor
This can be done with solver. The attached file shows the formulas i entered in the worksheet and the restrictions of the solver.