We are looking to move customers from our Sage 100 system to Sage CRM.  We have a 3rd-party application that generates customers and we feed them into Sage 100 using VI.  That part works fine.

However, it's not possible to trigger the creation of a Sage CRM Company from a Sage 100 Customer simply by importing.  There are two ways to create the Sage CRM record:

1) run the Relationship Management Wizard in Sage 100

2) go to the Customer Maintenance screen in Sage 100 and check the box to create the CRM company (there is no back-end field for this though; it's controlled on the front end only and triggers the CRM record creation).

Conceptually, if we could achieve one of the two below we could automate this process:

1) run the Relationship Management Wizard on a schedule, use all defaults, and have it create CRM records

2) get access to the Sage CRM sql statements that take the Sage 100 customers and insert the needed records into Sage CRM to create the relationship.

Does anybody have the code we could use to accomplish one of the above?  Or any pointers in different directions that would accomplish the same result, ie automated creation of companies in CRM when we import customers into Sage 100?