You can import billing and shipping addresses into QuickBooks in a number of ways using Zed Axis but there are some guidelines when setting up mappings to be aware of to make sure that the address is displayed in the correct format in QuickBooks
Option One: Use the names default address details already in QuickBooks
If the customer, vendor, other or employee name already has address details completed in QuickBooks then you do not need to import address details as the address data will automatically be added to the transaction based on the referenced name.
Option Two: Use a formatted address block
You can import Addr1
along with the other fields of City
. But you are limited to 5 lines as that is the maximum that you can fit into an QuickBooks address block, if you import more than five lines you will encounter an error.
Option Three: Using a open address block
You can import Addr1, Addr2, Addr3, Addr4,
to fully specify the address, but you are not able to use any other fields such as City, State or Postalcode. In this way each of the lines is printed on a separate line on the transaction address block.
||The first line of an address block (typically the company or individual name)
||The second line of an address block
||The third line of an address block
||The fourth line of an address block
||The fifth line of an address block
||The City line of an address
||The State line of an address
||The zip/post code of an address
||The country of an address
||A note that may appear at the bottom of an address block
Modifying a transaction leads to duplication of lines in the address block. If you are modifying a transaction already in QuickBooks and importing data into the address block you may see some of the address lines duplicated, this is due to the auto formatting that QuickBooks does to address blocks, it recognises City, States, and Postalcodes and reassigns data into the respective fields if a transaction is then modified the address details may be duplicated. Suggested workaround is to not map address fields when modifying transactions