Forum Discussion
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...
That is a prevalent problem with VBA solutions because most people who work in accounting do not have coding skills for VBA. Let statement provides for 128 variables but does not have recursion so the user is left with VBA user defined function.... Lambda has not been rolled out yet so Lambda would be viable after the rollout... meanwhile you would do something like:
you would stop applying when the unappliled reaches "0" (zero), then do a power query and add a column using table.selectrows against the worksheet where unapplied not < 0 and >0
cheers