PS: It is normal standard ECCA works with a fixed rate.  This is how the
EURO conversion is done (by law, not by programmers)
I mentioned ECCA as a starting point for your problem, don't expect it to be
the whole solution.

----- Original Message ----- 
From: <Kris.devlieger@xxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Sent: Saturday, April 24, 2004 1:39 PM
Subject: Re: IFM Financial Division Currency


> I cannot help you much on this one I am afraid, I never needed to dive
into
> ECCA sources.
> Normally MAPICS always uses the same function (something like AXZX40) to
> retrieve exchange rates at a given date (= one of the parameters).  Maybe
> ECCA has "overridden your override " by calling it after your program?
> I am not much into IFM but I can imagine if you are abso sure you only
have
> problem with 1 file and only during the conversion: post process this one
> file.  Some support input on "how dangerous is this?" you would have to
get
> from somebody else I am afraid. You should take care not to create a
corrupt
> or erroneous database if you modify anything.
>
> Kind regards,
>
>
> Kris
>
>
>
> ----- Original Message ----- 
> From: "Selvaraj Pillai" <selvaraj.pillai@xxxxxxxxxxx>
> To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
> Sent: Friday, April 23, 2004 10:40 AM
> Subject: Re: IFM Financial Division Currency
>
>
> > Kris, Please ignore my below mail as I have managed to run the ECCA tool
> > for complete MAPICS i.e. IFM and all other MAPICS modules. The looping
was
> > due the base price file. I could trace out the cause of looping after I
> > downloaded and the went through the source of EUROB14R.
> >
> > However, I have once issue to ask you. In our IFM we have override
> > exchange rate in all transactions except General Ledger Journal (GLJ),
> > which is actually in SGD entry so there is no exchange rate (ARFZNB) and
> > it is 1. When ECCA converts, it uses the override exchange rate to
> > calculate euro amount, if there is no exchange rate override in the
> > transaction, then it takes the current exchange rate. So for all GLJ
> > transaction it uses the current exchange rate which, result in some
> > difference. Our Finance wanted to use the historical exchange rate for
GLJ
> > transactions too. So, I wrote an RPG program to read the historical
> > exchange rate from a user defined file and update override exchange rate
> > (ARFZNB) and the flag to '1' (ARACWC)  in YAARREP and run the ECCA, but
> > the result was the same. Could you please give some advise on this?
> >
> > Regards, Selva
> >
> >
> >
> >
> >
> > Selvaraj Pillai/SNG/AP/PEMSTAR Inc
> > 04/23/2004 10:07 AM
> >
> > To
> > MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> > cc
> >
> > Subject
> > Re: IFM Financial Division Currency
> >
> >
> >
> >
> >
> > Kirs, This is Selva again,
> >
> > I managed to install and run the ECCA tool on our test environment. It
was
> > successful when I selected IFM only conversion, but when I run for all
> > MAPICS modules, it went into a loop at the procedure called EUROB14R.
When
> > I checked the job log the error message '(E) Foreign Price already
> > Exists'. We have COM installed and running. Please let me know if you
have
> > any idea of this error.
> >
> > Regards,
> >
> > S.P. Selvaraj
> > Senior I.T. Specialist, Asia Pacific
> > Pemstar Singapore Pte Ltd
> > Tel.  Dir (65) 6586 8009, Cell (65) 9653 4048, IP Phone 4368
> >
> >
> >
> >
> >
> > <Kris.devlieger@xxxxxxxxxx>
> > Sent by: mapics-l-bounces@xxxxxxxxxxxx
> > 04/16/2004 06:57 PM
> > Please respond to
> > MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> >
> >
> > To
> > "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
> > cc
> >
> > Subject
> > Re: IFM Financial Division Currency
> >
> >
> >
> >
> >
> >
> > You might want to take a look at the ECCA tool and/or its sources.  It
was
> > developed to do the local currency to EURO conversion in the European
> > communtiy.  Essentially it does exactly what you want to do: change the
> > local currency amounts everywhere to something else (all the EUROFLAG
> > juggling which it also does should not bother you too much).
> > Consulting in a Euro participating country i've used ECCA about on 10
> > sites
> > and had good expierences with it.
> >
> > I think it will cut down the task tremendously.  ECCA is free, but I
> > believe
> > sources needed to be purchased
> >
> > Kris De Vlieger
> >
> > ----- Original Message ----- 
> > From: "Selvaraj Pillai" <selvaraj.pillai@xxxxxxxxxxx>
> > To: <mapics-l@xxxxxxxxxxxx>
> > Sent: Friday, April 16, 2004 8:44 AM
> > Subject: IFM Financial Division Currency
> >
> >
> > > Hello,
> > >
> > > We are in the thinking of changing our functional currency from
> > Singapore
> > > $ to US $. I knew that it is going to be huge amount of work involved
in
> > > each of the MAPICS modules where we have kept the amount in local
> > > currency. Financial division reporting currency also need to be
changed
> > to
> > > US$. Is there anyone from the MAPICS user group has performed such a
> > > project?. If so, please share your experience.
> > >
> > > Regards,
> > >
> > > S.P. Selvaraj
> > > Senior I.T. Specialist, Asia Pacific
> > > Pemstar Singapore Pte Ltd
> > > Tel.  Dir (65) 6586 8009, Cell (65) 9653 4048, IP Phone 4368
> > >
> > > _______________________________________________
> > > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > > To post a message email: MAPICS-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > > or email: MAPICS-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/mapics-l.
> > >
> > >
> >
> > _______________________________________________
> > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > To post a message email: MAPICS-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > or email: MAPICS-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mapics-l.
> >
> >
> >
> > _______________________________________________
> > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > To post a message email: MAPICS-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > or email: MAPICS-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mapics-l.
> >
> >
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.