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 ...

Replies:

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.