Replicating shared currency

Depending on how your system handles currencies between sites, the Shared Currency replication category can be used to permit sites and entities to share currency definitions and exchange rates; otherwise, each site maintains its own currency codes and rates.

The domestic currency must be the same at all sites reporting to an entity. However, you may set up the sites so they can maintain their own currency exchange rates - or you may want to maintain the exchange rates only at the entity:

  • If currency and rate maintenance is performed only at the entity, you should replicate the Shared Currency from the entity down to the reporting sites. You do not need to replicate the Shared Currency category up from the sites to the entity. You must then disable the ability to change Currency Rates at the sites, in order to maintain control over the data. This flow chart shows an example of this option:

  • If currency and rate maintenance is performed at sites, then you should replicate the Shared Currency category from the sites up to the entity to which the sites report (and not back down to the sites from the entity). When using this setup, sites within the same reporting structure should also replicate currency and rate information between the sites. This flow chart shows an example of this option:

    Although this category replicates base tables, updates to the tables at one site/entity are only replicated to other sites/entities if there is a replication rule between them. (Replication is point-to-point.)

    You could also set up your system to have only one site maintaining the currency codes, in which case you would have one-way replication rules from that site to all other sites and entities.