[zjohnson@splunk.com]

Currently I am trying to modify the A/R Payment History by Invoice report. Below is what I’m trying to accomplish:

Customer—Inv #—Invoice Date—Payment Date—Invoice Amt—Payment Amt

AT&T——- 11———- 5/1/11———- 6/1/11——– $1,000——– $1,000

I’m trying to figure out how long it takes to pay essentially. Please assist me with this.
This is a cached copy. Click here to see the original post.

[javier]

RE: Creating a report that shows dates for payment and invoice side by side

Don’t think this is possible from the A/R Payment History by Invoice report. I would create a saved search to show this information.

[zjohnson@splunk.com]

Okay I don’t mind doing a search, how do i go about doing this?

[javier]

Run a transaction saved search; filter for type = invoice, mainline = true; add results for name, number, date, applying transaction fields: date, amount. Now the last field, payment amount, I assume you are trying to get the amount applied to the invoice, not the actual amount of the payment. If you want to get the amount applied to the invoice use the applying link amount. If you instead want the amount of the payment go to applying transaction fields: amount. This should get you what you’re looking for. You will probably also want to add an available filter for date so you can change your date range at the bottom of the saved search on the fly.

[Author]

Posts