If you have new companies / entities available from your source DB, but they do not show up in your modeler. 

Here is the steps how to add new them from SQL:


A. pcFinancials/EFP r1.4 to activate new companies

1.  You do not need to do anything from Modeler. 

2.  Go to the ETL database from SQL server -> Tables -> dbo.Entity, right click on it -> Edit Top 200 rows.

3.  Find the newly added company/entity, edit the SelectY/N column to be True.

4.  Please run the night job: SQL Server Agent -> Jobs -> right click on pcDATA_E9_Load -> Start Job at Step. This will take some time.


B. pcFinancials/EFP r1.3 to add new companies

1. You do not need to do anything from Modeler. 

2. Go to the ETL database from SQL server -> Tables -> dbo.Entity, right click on it -> you need to manually add those new entities(companies) here.

3. Please run the night job: SQL Server Agent -> Jobs -> right click on pcDATA_E9_Load -> Start Job at Step. This will take some time.