Discussions

Expand all | Collapse all

Can i pull a report that shows the ship to state for an order

  • 1.  Can i pull a report that shows the ship to state for an order

    Posted 02-21-2017 21:12
    reporting


  • 2.  RE: Can i pull a report that shows the ship to state for an order

    Posted 02-21-2017 21:19
    If you have an "Orders" table that has a "ship To" address then you should be able to pull the ship to state to display it where you'd like in the columns, or even use it as a dynamic filter on the left, so you can easily pull all the orders to that particular state.


  • 3.  RE: Can i pull a report that shows the ship to state for an order

    Posted 05-22-2019 21:19
     Assuming you have an address field named [Ship To ]

    1.) I recommend you create another field Called Ship to State and make sure it is set to Formula - Text

    2.)  If you look on your address field options and scroll all the way down you will see Address Subfields. Use the field label [Ship To: State/Region] 

    3.) so just open up your newly created field Ship to State and simply enter
     [Ship To: State/Region]  and you're all set




    Now for a report you can simply use the address field subfields as the columns