iDempiere and multi-currency

383 views
Skip to first unread message

Cameron Beattie

unread,
Feb 24, 2015, 10:51:05 AM2/24/15
to idem...@googlegroups.com
We currently use Adempiere and are in the process of migrating to iDempiere. I am trying to understand whether the multi-currency capability has changed.

My understanding is that in Adempiere a currency is set against an Accounting Schema which is chosen at Client level. We want to be able to set a currency at the Organisation level so we can set up an organisation in each country and have that report in the home currency. Is there a way to achieve that in iDempiere?

Carlos Antonio Ruiz Gomez

unread,
Feb 24, 2015, 2:51:10 PM2/24/15
to idem...@googlegroups.com
Hi Cameron,

> We currently use Adempiere and are in the process of migrating to
iDempiere.

Welcome to iDempiere.

> I am trying to understand whether the multi-currency capability has
changed.

It hasn't changed.

> My understanding is that in Adempiere a currency is set against an
Accounting Schema which is chosen at Client level.
> We want to be able to set a currency at the Organisation level so we
can set up an organisation in each country and
> have that report in the home currency. Is there a way to achieve that
in iDempiere?

You can define multiple accounting schemas, and each schema can manage a
different currency.

Regards,

Carlos Ruiz

Cameron Beattie

unread,
Feb 24, 2015, 4:55:15 PM2/24/15
to idem...@googlegroups.com
Thanks for the prompt reply.

From what I understand, once another Accounting Schema is created that would need to be assigned to a new Client which is another universe from Adempiere/iDempiere's perspective. I would prefer to operate within the existing Client (universe) and have the ability to choose which accounting schema to use. Is there a way to use another Accounting Schema other than at the Client level?

Carlos Antonio Ruiz Gomez

unread,
Feb 24, 2015, 5:26:48 PM2/24/15
to idem...@googlegroups.com
You can define multiple accounting schemas *within the same client*, and each schema can manage a different currency.



On 24/02/15 a las 16:55, Cameron Beattie wrote:

Cameron Beattie

unread,
Feb 24, 2015, 8:31:17 PM2/24/15
to idem...@googlegroups.com
Thanks but how does that get used?

For example how do I enter an AP or AR invoice so that it uses that currency and Accounting Schema?

redhuan d. oon

unread,
Feb 25, 2015, 1:34:34 AM2/25/15
to idem...@googlegroups.com
I am not sure if those are defined under the respective Default Accounts tab.

Michal Zilincar

unread,
Feb 25, 2015, 8:28:55 AM2/25/15
to idem...@googlegroups.com
Hi Cameron,

see Only Organization setting on accounting schema .

here you define link between org and schema.


Dňa streda, 25. februára 2015 2:31:17 UTC+1 Cameron Beattie napísal(-a):

Ouma Ronald

unread,
Sep 19, 2019, 9:37:48 AM9/19/19
to iDempiere
Hello Cameron,

Did you ever get this to work i followed everthing in this thread but its still using Clients base currency. I woul love to know how you where able to achieve this. AM using iDempiere 5.1
Thanks guys

Luis Amesty

unread,
Sep 23, 2019, 8:36:58 AM9/23/19
to iDempiere
Hi Cameron.
I have used dual Accounting Schema, using same Accounting Elements and Two currencies.
One Accounting Schema has Country Currency as Example (Euro €)
The other Accounting Schema has Foreign Currency as Example (US$ )
You have to deal with Conversion Rates on Currency Window definitions.
When you enter AR or AP invoices they are entered in the currency they were made ( Some on € others in US$)
Idempiere takes care of doing Accounting Facts on Both currencies depending on Conversion Rates Rules.
It is importan also to check that Accounting TABS on BPartners, Products, Warehoses, BP Group, etc. 
They Must have two registers, one for each Accounting Schema.
I hope this help to you
Regards
Luis Amesty
Reply all
Reply to author
Forward
0 new messages