I am using the reference field to identify a particular group of transactions and create a custom report. However, I cannot find a reference field to tell the query to find these transactions under Custom Reports. I have included a screen shot of both the transaction detail and the custom report. Thank you in advance for any guidance you may provide me.
Custom Report works like SQL query:
- SELECT chooses the data you want to query
- WHERE specifies the condition you want to match
Your WHERE conditions are blank, they should look like this
Your current settings just tells Manager to return all data from the accounts under SELECT
1 Like
Thank you! It worked great!