Hello -  I need to make saved search or report tha...
# suiteanalytics
l
Hello -  I need to make saved search or report that gives me payments made for the month for any bills that have CAPEX items or CAPEX expenses (this would be certain non-inventory items or on the expense side certain GL codes).  I need to include the customer project number if available.  Since it is main line (item, GL codes and customer project) and header line information (payment), I am not having any luck. I would appreciate any advice on how to make this work. Thank you
a
Probably a transaction search Type= Vendor Bill Main Line = F Applying Transaction Type = Bill Payment Account = (your CAPEX accounts or Item = (your non inventory items) Results Applying transaction date Applying transaction document number Document number Item Memo Item Rate Amount Amount Paid Applying transaction amount Name or Customer/Project.companyname
l
Thank you AI1 - I do not get any results when I run the search. If I take out applying transaction type = Bill payment, I do get credit memos applied but it will not give me checks or EFTs.