Using a Sage CRM system integrated with Sage 200, perform a data upload for the company entity.

Go into the database and search for a company that was uploaded.
Using the company ID, check that an account record was created.

Now check the address_link table. You will see that two links have been created but  the adli_accountid field is not populated.
This means that when the address is flagged as billing, no Billing type link is created for the account and this will cause an issue with Sage 200.



This issue was with the data mappings.
If they are set it up as highlighted below, the links are created correctly:


Address must belong to the company for it to be created for the account. It also needs an address type defined for all fields. What was happening here was an address was added to the person without setting an address type.