Multicurrency with Multiple Entities in Single Sage 300 Database

SOLVED

A company wishes to setup Sage 300 for their operations in 4 different countries, 4 different currencies all reporting back to a single currency.    There are two options

Option 1:  4 different Sage 300 Databases

Option 2:  1 Sage 300 database with a entity segment.  This is the desired option for many obvious reasons.

Example

Functional Currency of  USD 

-100 source currency of CAN 

-200 source currency of USD

-300 source currency of GBP (does have some transactions with a source of USD or CAN )

I am being told that with a single Sage 300 DB's if I wish to record my USD or CAN source transactions to my -300 GBP entity it will be necessary to convert that to GBP first.  

It is being implied that if I  setup each of my entities as a separate Sage 300 database this would not be a limitation.   Can anyone confirm that this is true.

Parents
  • verified answer

    Based on my understanding of your requirements, this limitation is true.  The system can easily manage multiple SOURCE transactions and report, convert, revalue to a SINGLE functional currency for the entire database.  As such, you cannot record SOURCE transaction in CAD for your 300(GBP) segment and have the system manage the CAD -> GBP -> USD.
    If this is a requirement, separate databased by functional currency would be required.  These can then be rolled into a consolidated USD database for reporting using the Consolidation module.

Reply
  • verified answer

    Based on my understanding of your requirements, this limitation is true.  The system can easily manage multiple SOURCE transactions and report, convert, revalue to a SINGLE functional currency for the entire database.  As such, you cannot record SOURCE transaction in CAD for your 300(GBP) segment and have the system manage the CAD -> GBP -> USD.
    If this is a requirement, separate databased by functional currency would be required.  These can then be rolled into a consolidated USD database for reporting using the Consolidation module.

Children