Discussions
Multi-Book Accounting Transaction Search > Contra Accounts for Transactions
Hello Team,
I would like to ask you for any suggestions regarding following issue.
We would like to have a Multi-Book Saved Search for particular account which would show us in results both debit account and credit account used within transactions.
E.g. We would like to have a saved search with all transactions (both books) for account 459100 Provisions - guarantee and in the Results of the Search we would like to see all Accounts used in the transaction (e.g. 563xxx/459xxx). Pretty much same as the G/L Impact.
I've used CASE WHEN NS_CONCAT({account}) LIKE '%459100%'...... in Criteria's of the Saved Search, but we are looking for something more straight-forward and quicker.