Hi everyone! question please? I am creating a save...
# general
m
Hi everyone! question please? I am creating a saved search for journals containing specific account. When I try defining the account in criteria it only shows the line for the specified account but not all accounts that is included in the journal. I tried doing it via formula but it didn't provide any results Here's the formula text I used: CASE WHEN {account} LIKE '692002%' THEN {account} ELSE NULL END. My goal is to have all journals containing this account together with the other accounts included in the journal to show in the report. Thank you
g
Can you give more context, please? What is the purpose of that report?
m
Hi Gustavo, appreciate the reply. Basically the user wants a saved search to extract all journals with account: 692002 including both credit and debit side. Example: Journal0001 contains 692002(debit) and 692003(credit) Results should be: Transaction Number Account Amount (Debit) Amount (Credit) Journal0001 692002 10000 Journal0001 692003 10000 --currently, when defined via criteria: Account: 692002 it only shows account 692002 whether debit/credit without the other balancing account