Skip to main content
June 13, 2024
Solved

Create Excel report for all invoices for customer with ship to address

  • June 13, 2024
  • 1 reply
  • 0 views

Hi,

I am trying to create a spreadsheet for a customer with all of their invoices with the invoice number, invoice date, ship date, ship to address, product description and amount.

 

I have tried to use the reports Sales by Customer Detail but I can't see the ship to address in the columns option.

 

Is there another report?

Thanks

Best answer by emmam6

Hello Rafiq, Thanks for reaching out regarding reports. You could run a transaction report, as those reports have a lot of scope for adding additional columns. You could run a transaction list by customer report> go to filter on the top right-hand side of the report and add transaction type as a filter and change that to invoices. Then go to columns on the top right-hand side of the report and then scroll down and add in shipping date and shipping address. Let us know if that works for your needs.

1 reply

emmam6Answer
June 13, 2024

Hello Rafiq, Thanks for reaching out regarding reports. You could run a transaction report, as those reports have a lot of scope for adding additional columns. You could run a transaction list by customer report> go to filter on the top right-hand side of the report and add transaction type as a filter and change that to invoices. Then go to columns on the top right-hand side of the report and then scroll down and add in shipping date and shipping address. Let us know if that works for your needs.

Rafiq11Author
June 13, 2024

Thanks, I was using another report and there was no ship to comumn.