...
Steps to migrate addresses structure:
???? Make sure the companies import from your financial system to Workbench supports (has been updated) to import company addresses in the new format.
Financial Systems supported:
Xero API
MYOB AccountRight API
MYOB Advanced API
SAP B1 API
Business Central
Change control parameter 'BETA FEATURE - Structured Addresses' to Yes.
If possible, you want to have an idea of the before and after and how thenew address structure looks like, you can test one company: make a change and revert it on a the company address on your financial system and revert it; then import . This will give you an idea of the address before and afterinto Workbench.
???? All companies need to be bulk updated in the financial system so they come through to Workbench and update the new address fields.
On your financial integration screen in Workbench, back date the last updated date, save and import companies.
Below is an example of the Xero integration screen, and how only Companies are selected to be imported and Last Update was backdated to way back in the past to ensure all companies come accross.If possible verify some companies.
Use After switching to the new address structure:
the Jobs that have addreses from these companies will have the Job Site address fields empty.
Purchase Orders will still have the Delivery address name selected but the new fields will be empty.
!!!! Old POs will loose the delivery address data.
Service Logs will still have the Address name selected but the new address fields will be empty.
!!!!old Service logs will lose original site addresses.
There is a utility utility wbUtilityInitialiseStructuredJobAddresses to populate the new address fields on Job’s Site address on Jobs:
...
.
Re-initialise Addresses = Yes: If the structured fields are set already on a job then when set to yes this will overwrite them.
Re-initialise Addresses = No: If the structured fields are set already on a job then when set to no theese fields will not be overwritten with the data from the selected Address Name.