Page 1 of 1

Sorting Orders

Posted: Mon Jun 06, 2016 10:09 am
by Abell1775
Is there another way to sort our orders by state other than printing out an entire list from excel?

Thanks.

Re: Sorting Orders

Posted: Mon Jun 06, 2016 11:20 am
by Paige
At this time there is not a way to do this, however what a wonderful suggestion!

Can you explain further what you are trying to accomplish so we can meet your needs in the future?

Re: Sorting Orders

Posted: Mon Jun 06, 2016 12:17 pm
by Abell1775
We are trying to find all the orders and print the invoices that are from Idaho for tax reasons.

Could you please add Idaho sales tax (6%) to the system, as our customers have not been charged and need to be for tax purposes?

Thanks.

Re: Sorting Orders

Posted: Tue Jun 07, 2016 9:47 am
by Paige
Thank you for explaining your needs, we do in fact have a report like what you're looking for! It can be found under Reports > Accounting > Sales Tax Liability, this report shows all orders and thee state they are to be taxed to.

To setup a taxes for Idaho:
  1. go to Store > Tax Rates
  2. under "Select" choose "state"
  3. for "Tax Rate" type in .06
  4. under "State" choose "ID"
  5. click "Save"
  6. click "Offline" on the tax rate to turn on auto tax calculations

Re: Sorting Orders

Posted: Tue Jun 07, 2016 11:10 am
by Desiree1775
Thank you for the information.

Re: Sorting Orders

Posted: Tue Jun 07, 2016 11:12 am
by Desiree1775
Can we print the customer addresses for this year through excel and if so what is the procedure?

Re: Sorting Orders

Posted: Tue Jun 07, 2016 11:58 am
by Paige
At the top right of Reports > Accounting > Sales Tax Liability there is a download button, if you click this it will export the data into a csv you can open in Microsoft Excel.
Sales Tax Liability   Sarah s Flower Shop.png
Sales Tax Liability Sarah s Flower Shop.png (28.96 KiB) Viewed 10167 times
For the entire years worth of orders be sure to check the date range at the top of AllProWebTools, so that is set to the year you wish to report on.

Re: Sorting Orders

Posted: Tue Jun 14, 2016 1:36 pm
by Desiree1775
Thanks you for the information.

Customer Sales Address List

Posted: Thu Jun 16, 2016 11:24 am
by Desiree1775
I need to print all the sales of customers with their address from June 2015 till now. I am looking for Idaho sales, for tax purposes. I printed the sales tax liability info but it does not show all customers or Idaho.

Re: Sorting Orders

Posted: Thu Jun 16, 2016 12:41 pm
by JohnB
Perhaps if you go to Store->View Orders, there is a button titled Download Orders CSV. Make sure the date selector at the top right is set to the correct date range, and you can download a spreadsheet of all the orders in that date range.

If this is not what you need, could you give me some more details on exactly what information you need other than the address for each individual order?