What is propagation and what is it used for?
Propagation was introduced into Sage300 in version 5.5. When system and company databases are created, the system database tables are now copied to the company database. The purpose of this is to make certain functions (such as printing reports) run faster. It also allows users, security groups and currency rates to be copied from one system database to other company databases (which uses the same system files), instead of defining or re-entering all these in each database. The system database always remains as a master copy.
Propagation of data can be done from Database Setup. Go to Start / Programs / Sage / Sage 300 ERP 2014 / Database Setup. The ADMIN password is required. Highlight the company database that you want the system files copied into and click 'edit'. Then click Propagate. The master data for users, security groups, and currency rates will be copied from the System database (identified in the top right) into the company database.
The user authorizations are company specific and will need to be assigned in the company database through Administrative Services / User Authorizations.
It is also possible to propagate the currency rates only from within Sage. In Common Services / Currency / Currency Rates, there is a Propagate button, as well as an option to 'Defer Propagation of Data to Companies'. The defer option lets the user propagate rate changes for a specified range of dates only by selecting the Propagate button (illuminated when the defer option is selected) and identifying the dates required. Running a full propagation from the Database Setup utility will override this setting and copy the data from the system to the company database.