AGR has the capacity to import data from multiple companies within the same ERP in a standard way.
Data import process
Import all transactions for all Companies.
Import all tables for all Companies (Items, Locations, Vendors, etc.).
Primary key conflict
The main challenge of integrating multi companies into AGR is that there may be a conflict of records that exist with the same identifier in different companies, to fix this AGR uses a prioritization system that prioritizes records.
Priorities
Let’s use as an example a system that is importing data from 2 companies, ICL(BC Iceland), PRT(BC Portugal).
The priorities for the Location entity could be configured as follows:
Entity | Company | Priority |
Location | ICL | 1 |
Location | PRT | 2 |
In this setup the details for locations from ICL would be imported, but from PRT only the Locations with an identifier that is not a duplicate with ICL will have it’s details imported, for Locations in both companies the ICL details will prevail.
For example in the image below we have 3 Locations in PRT but the name that is mapped into AGR is only for “Store 5” because the other two Locations Name is prioritized to be imported from Iceland.
Each table can be defined with different priorities, e.g. for Locations you can import the details from ICL but for Products\Items PRT can be the priority. Note that this rules only apply when there is a primary key conflict, for exclusive records no rule is needed.
Transactions and Stock
For transactions and stock levels there is no priority rule needed because the quantities are aggregated. The stock levels in AGR will be an aggregation of all stock in each of the companies for that Item\Location, same logic applies to Sales and other transactions.