V14.5 Customer address changes

Hi Chris,

I am not aware of a way to trigger that the change all records be implemented via API.  Plus this actually means only updating the records which share the same address_id.  So, for example, if you change the address on an item, that item gets a new address_id which is not the same as the site address_id itself.  In this scenario, change all records would not be effective.

• Site address_id is 123  (making up numbers as I go along for examples)
• Create an item on the site - it now has address_id = 123 (change all records would work)
• Change the address on the item in the installed item module - now has address_id 432 (change all records would not work).

Same thing applies to records such as service orders where you might change the ship_to_address_id on the order_line or change the address on the labor demand.  If Change all addresses is not enabled, any change will create a new address_id.

Perhaps someone else has an idea short of running SQL scripts but I can’t see an API doing this task.

Hi Phil,

Thank you.  Yes, I was aware that the address ID would change if someone manually changed the address on an order or item etc. but in that case I would assume that it needs to be different so I would not want to change it (I am foolishly believing that the users are following the rules).

So I would only want the main Customer address and anything else that uses the same address ID to be updated.

Hi Chris,

I understand.  In your scenario, you want to update the customer address without changing the address_id that is linked to the customer.  Which the UI only does if you have the option to change all records enabled somehow.  Maybe this element?

What the possible values are, I don’t know as I normally am not developing API’s but probably Y for global, N for local change.  Perhaps someone who is more familiar with developing API’s can answer if this is possible.

Thanks Phil,

I’ll ask around and see if anyone here is familiar, otherwise might need to open a support request.

Thanks and Best Regards

Chris

Hi Chris,

Continuing Phil answer, below is the API sample.

Please make sure you know the address_id and address type you are going to change, because sometime a customer has multiple addresses with the same address type.

<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
  <session email="" alias="">
    <state bc_name="customer_request">
      <action name="data">
        <main>
          <row number="1">
            <company_id dtype="string">ABC</company_id>
          </row>
        </main>
        <address_xref>
          <row number="1" search_key="address_id;1111">
            <gl_level_change dtype="string">Y</gl_level_change>
            <address_1 dtype="string">PO Box 1111</address_1>
            <city dtype="string">City</city>
            <zip dtype="string">1111</zip>
            <state_prov_id dtype="string">ABC</state_prov_id>
            <country_id dtype="string">US</country_id>
            <address_type_id dtype="string">BWork</address_type_id>
            <phone_id dtype="string">111 111 111</phone_id>
            <fax_phone_id dtype="string">222 222 222</fax_phone_id>
          </row>
        </address_xref>
      </action>
    </state>
  </session>
</root>

Regards,

Joshua