Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI need a sales report per country for our international activity.
Unfortunately the fiel "Country" do not exist in the filter list. We could find only ZIP, State...but not Country.
This information about Country is on the Bill to Address of the customer.
Any idea to pull out such report or customize report or ODBC?
Many thanks
Pat33YZ
We're unable to pull up a foreign sales report, Pat33YZ . Though, I have a workaround to this.
You have to filter either the Sales by Customer Summary or Sales by Customer Detail report customers of the same country manually. Here's how:
You can also pull up the Customer Contact List report to get each customer's address or country. Here's how:
If you want to pull up the same setting of report. you can memorize. Here's a guide on how to do so: Create, access and modify memorized reports.
If there's anything else that you need, we're just one post away. Take care!
Another option, having a BI app
Yes, QuickBooks won't create such a report.
However, we can build the report for you outside of QuickBooks with a custom reporting solution. If interested, send a support request: BRC Support Request
Thank you for you suggestion.
I have found a way.
Pull out bills report by adding town entered in the bill to address, export the report to Excel and then added country in bulk by sorting by town. Just need some geographical knowledge ;)
Many thanks to all.
Many thanks for your inputs
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.