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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.