Aaron R
02/14/2025, 11:44 PMCeligo AI
02/14/2025, 11:44 PMAI generated answer (using internal Slack threads):****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To pull line level detail on a transaction search to identify the account used on the line level on a vendor bill, you can use a Saved Search with the Main Line set to False. This will allow you to access line level information. However, if you're not getting any data, it might be due to the specific fields you're trying to access. If you're trying to exclude certain accounts from the search, you can use a Summary Criteria in your Saved Search. For example, you can use a formula like
CASE WHEN {account} != '67000 NY SalesUseTax' THEN {account} ELSE NULL END = 0
to exclude the 'sales tax' expense account.
If you're trying to extract custom field on vendor bill using bill payment search, you can try using the Applied To Transaction join or Paid Transaction join. These joins can help you access the vendor bill line information through the bill payment search.
Remember to adjust these methods according to your specific needs and the fields you're trying to access.Celigo AI
02/14/2025, 11:45 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.852510691
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833067775
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831502616
Celigo AI
02/14/2025, 11:45 PM