It’s really hard for me to imagine how the payment model is running in your sheet, @mmgalliv, without seeing the inputs. Can you share a screenshot of your sheet? Feel free to simplify the example (with fewer accounts that still result in the failed behavior) or to redact account descriptions like @branadonshutter.
Also, I don’t know what you mean by “now the other account cannot be found”. The accounts in the dropdowns in column A
populate from your Balance History sheet where the Class
is marked as Liability
— this requirement is documented here. (You can override the Class using the Accounts
sheet.) If you aren’t seeing an account in the dropdown then:
- It doesn’t exist in Balance History.
- It is not properly setup with an
Account Id
in Balance History. - It is not marked as a Liability in Balance History.
Thanks,
Randy