Resolving Invalid Address sync errors.

If you're getting errors related to invalid addresses at the customer or invoice section of the sync, take these steps.

A customer or invoice synchronization error may be received if the Customer Address, invoice Bill To or Ship To Address is in an invalid format:

SubmitCustomerBatch: error while modifying customer Mike Smith {181A3EC7-C71C-4084-B42C-E5F9315A8A4F}: There was an error when composing an address in “”.  QuickBooks error message: There are not enough address lines to compose the address. Please rearrange the individual fields, so that they can fit in the 5-lines block.

QuickBooks addresses can contain up to 255 characters across 5 lines. The Address must be in a specific format, in order to be created in QuickBooks. If the format is invalid, you will receive an error like the one above. Each address field can not be more than 31 characters long as this is a QuickBooks limitation. 

Customer has an invalid address

Open the related Customer in Acctivate and verify the Address is correct.

To ensure you have the correct format on the address block you may use the Address editor window. 

1. Click the Edit button at the top of the Customer window.

2. Click the edit button next to the Address block,

3. Verify the address and make the necessary changes.

4. Click OK.

5. Save the changes on the Customer Window

You may also want to review the Ship To Address of the related Customer.

For this, you will go to the Ship To tab on the Customer window and repeat the above steps 1-5.

Invoice has an invalid address

In the case that you get this sync error on an invoice you may follow these steps.

1. Open the related invoice in Acctivate.

2. Void the invoice. This will reopen  the order related to the invoice and will allow you to make changes to the address.

3. On the Order window, click the edit button.

4. On top of the address block, click the little 'pencil' icon. This will open the address editor window.

5. Review the address and make the necessary changes.

6. Click OK.

Make sure you check both address blocks the Billing Address as well as the Shipping Address.

7. Save the changes on the Order window.

8. Recreate the invoice

 

Once the addresses have been reviewed, you may run a new sync.

Using the Address editor window may assist with properly parsing International Addresses in the event the Customer was imported into Acctivate.

If you continue to have problems with a Customer Address or invoice Bill To or Ship To Address, contact our support team and include the Address in question. In some instances International Addresses will be parsed to fill the proper Address fields.