RE: Saved search for journal entries that contain specific account. Result will show all line items

Is there a way to pull all line items in a saved search for a journal line that contains account x? I.E. currently searching for a journal that has a line item with accounts receivable but I’m only getting that single line item while I’m trying to get all the debits and credits. I’ve been playing around with mainline and line sequence but having trouble making the correct saved search

jglovsky Rookie Asked on September 12, 2019 in Accounting.

Did you ever find a way to accomplish this? I have the same issue. The responses below do not solve it, it just does exactly what you described above where it will return that one account alone, which is what you are trying to avoid.

on May 23, 2020.
Add Comment
3 Answers

Interesting, I have had the opposite problem. I’ve tried to return just the JE header only by using Mainline = True and get all the debits/credits anyway. Even without any other line-specific fields. Never could figure out why.

Rookie Answered on September 12, 2019.

Can you screenshot search and result?

on September 12, 2019.

To get the debit and credit lines you have go to line level, mainline = true would not work. try the following results column using same criteria above (minus the accounts types)

RE: Saved search for journal entries that contain specific account. Result will show all line items

on September 12, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.