I appreciate you for following the instructions, Penstruck.
 

I understand you're looking for a report to populate the fields you need. Let me provide additional clarity and alternative solutions.
 

I suggest using the Average Days to Pay Report. It includes the invoice date, paid date, and invoice number. You can then customize it further to show the columns you'd like to include. Here's how:
 

1. Navigate to the Reports menu.
2. Select Customer & Receivables.
3. Choose Average Days to Pay and click Customize Report, then Filter tab to include the fields you need.



While the Sales Tax Amount field isn’t available in any reports, the closest option to view transactions involving sales tax is the Sales Tax Liability Report. This report provides details such as total taxable amounts, non-taxable amounts, and sales tax owed. You can click on these totals to view individual transactions and cross-reference them with the Average Days to Pay report.

Here's how to run this report:
 

1. Go to the Reports menu.
2. Click Vendors & Payables and select Sales Tax Liability.
3. Filter the report for the date range and customize columns if needed.


 

Alternatively, export the Average Days to Pay report to Excel and add a column for Sales Tax Amount. Manually enter the values by cross-referencing them with the Sales Tax Liability report or from each invoice.

Please leave us a response if you have other questions or concerns.