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.




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.