Creating Customers in Multiple Companies

chiptesandeep

If we create a customer in one Company, Need to create same Customer in all Companies with defined no. series.
Ex: Database having companies A , B , C .

IF we create a customer in Company A with No. CA-0001 ,
then automatically in B & C companies customer master should insert with CB-0001 & CC-0001.

David_Singleton

Is there a question?

chiptesandeep

is there any possibility to create same customer in Multiple companies with defined no. series as per company .. ?

Sayan81

There is a virtual table 2000000006 company , use this table to go to each company and then use changecompany function to change company. For example,

IF company.findset then
repeat
customer.changecompany(company.name);
until company.next = 0;

But remember this changes company only for customer table , not for other tables. So if onvalidate trigger in customet table fields calls other tables , those tables will refer to data in original company. So better to use web service to sync data between companies. Or simply , use dataport to export data from one company and import to other.

search1110

Create MASTER company as another layer of security. This company use for some roles with the permissions MODIFY,INSERT,DELETE. You still can access this data from other companies but in READ only.
[Inappropriate language removed by Administrator]