Re: Fw: IFM Financial Division Currency(2)

[Selvaraj Pillai <selvaraj.pillai@xxxxxxxxxxx>]

Kris,

Thanks for your advise. We are just in the evaluation stage, but to my 
opinion ECCA can tremendously reduce our work load on local currency 
conversion. I have run the tool few times and the high level testing of 
before and after conversion data looks to be good. If we use the tool, we 
will use as it is the way it is working and then work out the impacts due 
to fixed exchange rate. Thanks

Selva
 




<Kris.devlieger@xxxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
04/26/2004 01:06 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
<MAPICS-L@xxxxxxxxxxxx>
cc

Subject
Fw: IFM Financial Division Currency(2)






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

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