I'm not sure you'll be able to get to that via a r...
# suiteanalytics
r
I'm not sure you'll be able to get to that via a report. On a Saved Search, you can get to how much has been billed (not paid), by selecting PO as your type and choosing Applying Transaction.Doc ID and Applying Transaction.Amount. You may have to do some grouping if you have multiple bills per PO. Once you have that, you'd probably need another saved search with type of Bill and then include Paying Transaction.Doc ID and Paying Transaction.Amount. Then download each to Excel and vlookup them together. Not very efficient, but it should work once you get the groupings right. I'm not aware of a way to go 2 "levels" of a transaction, if we're calling PO>Bill one "level" and PO>Bill>Check two levels. You'd need basically Applying Transaction.Paying Transaction.Doc ID. I don't think that's possible.