Sales Order Report - Invoice Register- Not populating state abbreviation

Good evening, @aamaxleather. 

I appreciate you coming here to the Community with your question about reports within your QuickBooks Desktop account. 

There's two options that you can choose from to try to get the results you'd like. I recommend the following: 

Sales by state: 

1. Go to the Reports menu.
2. Select Sales and then Sales by Customer Detail.
3. Tap Customize Report.
4. On the Display tab, from the Columns list, choose Name State/Province.
5. Hit the Total by dropdown and then press Total Only.
6. Click the Sort by dropdown and then Name State/Province.
7. Press OK.

The second option would be to use a custom field to add the states and try adding to a report. Here's a guide that has more details: Create and use custom fields in QuickBooks Desktop. 

Keep me updated on how these instructions go. I'm only a comment away if you need me again. Have a splendid day! 

Hello-- Thank you for the reply. These solutions wouldn't work as we need the ship to state. We have a customer setup as billing and the state is included, however we need the shipping state data which varies per order. When I drill into the order, the ship to state is listed, but doesn't appear in the report. See attached. 

Thanks for your prompt response and for providing us with an additional screenshot, @aamaxleather. Allow me to assist you further and share additional information.

I've replicated your scenario here on my end and I was able to pull up the Sales by Customer Detail report with the Ship To address showing, including the Ship To State.  

Please see the attached screenshot:

I've opened one of the shown transactions and was able to verify that the Ship To address field has been filled up correctly including the State.

Since the Ship To State is empty on your reports even after making sure that the transactions and customer profiles have it, let's utilize the Verify and Rebuild tool as there might be an issue with your company file. 

Beforehand, make sure your QuickBooks Desktop is up-to-date. This way, you always have its latest features and fixes. Follow the steps below on how to verify data:
 

1. On the top menu, click File.
2. Choose Utilities.
3. Select Verify Data.
4. Click OK when QuickBooks doesn't detect any problem with your data.
5. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
6. Click Close or View Errors and take note of the specific error message.

Next, here's how to rebuild data:
 

1. On the top menu, click File.
2. Choose Utilities.
3. Select Rebuild Data.
4. Click OK if you receive a prompt to back up your company file.
5. Click OK when the rebuild has been completed.
6. Run Rebuild Data again to make sure there's no error.

Furthermore, please know that you can memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use: Create, access, and modify memorized reports in QuickBooks Desktop.

Please don't hesitate to ask any questions along the way. I'm committed to making sure you feel confident and empowered in managing your sales reports in QuickBooks Desktop. Have a good one.