Problem with address fields in the Shipping Address section

dianitag39 · ‎September 20, 2021

It is happening to me that I put the ship-to address using the corresponding fields as it is shown below:

But as soon as I tap OK and try to Edit the address again all fields get copied to the "Address" section, except for the "Note" which goes to the city field, see the image below:

Any thought? This is causing me a problem in the integration with a third-party application.

Thanks a lot in advance.

BigRedConsulting · ‎September 21, 2021

@dianitag39

This is actually pretty normal behavior, especially using the values in your example, which are non-standard. Particularly "zip" for the zip code instead of five numbers.

The crux of the issue is that QuickBooks doesn't really store the data in the individual address fields, but instead stores addresses as five lines of text. Then, when opening the Edit Address window, it attempts to parse the address using USPS address formatting rules (mostly) as QB understands them.

This is true except for Employee addresses, which are entered in individual fields and are double-stored, both as individual fields (the primary fields) and as derived text to be used on transactions like checks. But that doesn't really impact your case...

If you're importing international addresses, you'll find that QuickBooks is particularly bad at parsing them. I don't think it was ever intended to work for anything other than US & Canadian addresses. Possibly Mexico as well.

Imported addresses should be treated exactly like addresses entered in the address block within QuickBooks, which is just plain text either way.

Note it's perfectly OK to not use the Edit address window at all, and just enter or edit the addresses in the 5-line address block.

What is the problem this causes for you?

View solution in original post

katherinejoyceO · ‎September 20, 2021

Thanks for your posting your first concern here in the Community, @dianitag39.

There may be a problem with your data when the information from the Notes section appears in the City field after editing the shipping address.

We can run the Verify/Rebuild Utility to fix corruption issues within the company file. Here's your quick guide:

To run the rebuild utility:

From the File menu, click on Utilities.
Select Rebuild Data.

To run the verify utility:

From the File menu, click on Utilities.
Select Verify Data.

For future reference, read through this article to learn more about creating custom fields to personalize QuickBooks Desktop.

Let me on how it goes for you, @dianitag39. I'll be here to help you more if you have additional cocnerns.

BigRedConsulting · ‎September 21, 2021

@dianitag39

This is actually pretty normal behavior, especially using the values in your example, which are non-standard. Particularly "zip" for the zip code instead of five numbers.

The crux of the issue is that QuickBooks doesn't really store the data in the individual address fields, but instead stores addresses as five lines of text. Then, when opening the Edit Address window, it attempts to parse the address using USPS address formatting rules (mostly) as QB understands them.

This is true except for Employee addresses, which are entered in individual fields and are double-stored, both as individual fields (the primary fields) and as derived text to be used on transactions like checks. But that doesn't really impact your case...

If you're importing international addresses, you'll find that QuickBooks is particularly bad at parsing them. I don't think it was ever intended to work for anything other than US & Canadian addresses. Possibly Mexico as well.

Imported addresses should be treated exactly like addresses entered in the address block within QuickBooks, which is just plain text either way.

Note it's perfectly OK to not use the Edit address window at all, and just enter or edit the addresses in the 5-line address block.

What is the problem this causes for you?

dianitag39 · ‎September 22, 2021

Thanks for your response!!!!

This was happening to two of my company files. I tried in one of my company files and this helped me, but in the other one it didn't got fixed...

Is there anything else I could try?

dianitag39 · ‎September 22, 2021

Thanks you for your response!

I understand what you mean, but I gave you an example info in those pics, but my company files has the info in the expected format and it is happening too...

JessT · ‎September 22, 2021

Hi dianitag39,

I appreciate that you checked your other company file to compare the results. Let me help you check this further.

What you can do is copy the billing address to the shipping address field by clicking the Copy>> button. Then, edit the copied address and enter the correct one, and then click OK. After that, open the customer profile and edit to see if the shipping address details are in the right fields.

If the same thing happens, you'll want to update QuickBooks or repair it when the update won't resolve the issue. Please consider backing up all your company files before repairing QuickBooks.

I'm just a comment away should you need more help. You can reply at any time. The Community is always available for you. Take care!

dianitag39 · ‎September 23, 2021

I deeply revised and found that it was a format problem as you said. Thanks a lot!!

Topics

Training

Community

Resources

Problem with address fields in the Shipping Address section