Working on a saved search for bills, and want to s...
# accountingw
Will Coburn
06/10/2021, 1:21 PMWorking on a saved search for bills, and want to segregate out bills that hit a specific AP Account (we have four), but when I use the Account field, it is giving me the expense account that the line items are hitting (debit), and not the liability account (credit). Any suggestions?
r
Rebecca
06/10/2021, 1:30 PMAdd a criteria for Account Type = Accounts Payable.
w
Will Coburn
06/10/2021, 1:32 PMThanks. I've tried that, but it breaks the search and I get no results
Will Coburn
06/10/2021, 1:32 PMMy criteria are: Main Lineis false Typeis any of Bill, Bill Credit Dateis within 6/1/2020 and 12/31/2020 Accountis 2010 ACCOUNTS PAYABLE : AP - CURRENT PAYABLES
Will Coburn
06/10/2021, 1:33 PMAnd results are Date, Document Number, Amount, and Account
r
Rebecca
06/10/2021, 1:35 PMThe accounts payable account sits at the header so the MainLine is False criteria is causing you an issue.
w
Will Coburn
06/10/2021, 1:37 PMAH! that did it, forgot to change that back, thank you!
2 Views