Is it possible to show the contra account (“split”...
# general
l
Is it possible to show the contra account (“split” account) of each bank account transactions in a transaction saved search? For example, in one row, there is a transaction showing the GL account debited and GL account credited in separate columns.
m
If you only have one bank account in your transaction, you can customize it. With a custom field (bank account) and WF/Script that will fill your field with the bank account used in the transaction. This way, if you use the following logic: custom field is not empty and account type is not bank, you'll see all counterparty accounts for this bank account.
l
Thank you. Sometimes there are more than 1 bank account but most of the time it's just a bank account. So the solution you said might work. I also realized that there is a main account option in the saved search which is the header GL account. So it will work for most of the bank transactions because the bank account is in the header. Our only problem then are journals and bank transfers.
m
I Never used a bank transfer I create two journal entry for bank transfer 1 bank account to clearing account And another JE in another sense
For the JE you can use a client script to block the user who want to used more than 1 bank account
l
Thanks!