AR Report or AR Query Similar to an Audit Trail?

Accounts Payable

Hi, my coworker in Accounts Receivable is looking for a report or query that functions similarly to an audit trail where they can see how everything is related to each other in terms of invoices, line items, and payments. Does such a report or query exist or is it possible to make one? I went the query route at first and found most of what I needed but always seemed to come up a couple of fields short regardless of which item I started with.

Ideally, we'd like to be able to see the invoice, the line item, the CR Account Number from the line item, and the Payments. Basically, they want to be able to see where everything went all at once if possible.

Thanks in advance for any help you can provide,

Stephen Dignam

JoAnne Thielen

@Accounts Payable Did you find a report? I am looking for the same information

Stephen Dignam

@JoAnne Thielen, no, I did not. I believe my coworker is using the query I built that gives a decent amount of the information. Sorry for the late reply. ⌚