Re: Local Currency Support

[michael.franchino@xxxxxxxxxx]

All points understood and already handled/being handled.. 

The date format was a royal pain.. MAPICS should fix this.

I am in the process of creating all the external documents to support 
multiple languages, currency, amount formats, plus all of the European 
requirements for documents.



Michael Franchino
Custom Systems Corporation
http://www.cussys.com
(973) 726-0202 X214 (Phone) 
(973) 726-4552 (Fax)




"Bob  Tenney" <bobtenney@xxxxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/03/2003 07:52 AM
Please respond to MAPICS ERP System Discussion

 
        To:     "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Local Currency Support


Michael, Regarding your points:

(1) MAPICS handles foreign language item descriptions and foreign currency
pricing. Costing is a can of worms. EPDM is able to maintain separate 
costs
by Site. You would have to do something to have EPDM send the right costs 
to
the AS/400 based on warehouse.

(2) Date formatting is controlled by common routines throughout MAPICS. I
don't know if this is MAPICS or AS/400 function. In any case, once you 
find
the routine, modifying it would not be that difficult.

(3) All forms in COM, IFM, and PUR have exits that let you modify them as
needed.

I searched for camelon + software + mapics in Yahoo and got 21 hits. It
might be worth checking out.

One more point. The IFM currency conversion routine assumes one base
currency per environment. You need to change this routine so it gets the
base currency from the warehouse, site, etc.

Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Presence - Crystal Reports
828-526-8976

Visit www.tenneypubs.com for books about
IFM, COM, G/L Interfaces
Info WorkPlace, Cost Accounting,
FRx, and PRESENCE
----- Original Message -----
From: <michael.franchino@xxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Sent: Monday, June 02, 2003 8:20 PM
Subject: Re: Local Currency Support


> Separate environments are unfortunately not available for us to do..
> Integration for the Cameleon application is the basis for the decision 
for
> a single environment.
>
> Other issues that we have had to concur also include date format, forms
> (need to print in the language of the customer or warehouse),
>
> We are handling everything with, triggers.
>
> Bigger issues - Same item, but different (cost, price, descriptions, 
etc.)
>  We have had to EPDMize PM, COM, etc. to support items at the site 
level.
>
> If anyone has any additional words of wisdom like Bob's, that would be
> greatly appreciated since this needs to happen by the end of June for 2
> months of testing.
>
> Michael Franchino
> Custom Systems Corporation
> http://www.cussys.com
> (973) 726-0202 X214 (Phone)
> (973) 726-4552 (Fax)
>
>
>
>
> "Bob  Tenney" <bobtenney@xxxxxxxxxxxxx>
> Sent by: mapics-l-bounces@xxxxxxxxxxxx
> 06/02/2003 06:13 PM
> Please respond to MAPICS ERP System Discussion
>
>
>         To:     "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
>         cc:
>         Subject:        Re: Local Currency Support
>
>
> Jack, MAPICS lets you do business in multiple currencies in the same
> environment. It does not let you have more than one BASE currency in the
> same environment. For example, in one environment you can sell to
> customers
> and buy from vendors in any number of currencies. You cannot have one
> company use US Dollars and another company use Mexican Pesos in the same
> environment.
>
> The reason for this restriction is the manufacturing applications--not 
the
> financial applications. These applications do not support separate
> companies
> or separate currencies. This means that you cannot have costs that are
> denominated in multiple currencies without running the risk of adding 
100
> USD + 100 Pesos and getting 200 ??? as the result. If this happened, to 
a
> component item the 200 ??? amount could ripple through many of your 
costs.
>
> So, what can you do about this problem?
>
> (1) The safest thing to do is to have separate environments for each 
base
> currency. At the end of the month you can transfer the general ledger
> balances to the environment that you use for consolidation. This works
> because IFM is designed to have multiple base currencies.
>
> (2) You can add safeguards to prevent currency mixing. You have to 
define
> a
> base currency for your standard costs and a base currency  for each of
> your
> warehouses. When IM transactions and backflushed labor and overhead
> involve
> warehouses that do not use the standard cost base currency, then you 
have
> to
> convert amounts from the standard cost currency to the warehouse's
> currency.
> This is not as difficult as it sounds. I am aware of only two places 
where
> you would need to do this conversion: (a) Inventory transaction
> processing;
> and (b) The routines that handle labor and overhead calculations. (There
> may
> be others).
>
>
> Bob Tenney
> Bob Tenney Solutions, LLC
> MAPICS - FRx - Presence - Crystal Reports
> 828-526-8976
>
> Visit www.tenneypubs.com for books about
> IFM, COM, G/L Interfaces
> Info WorkPlace, Cost Accounting,
> FRx, and PRESENCE
> ----- Original Message -----
> From: <jack.roughgarden@xxxxxxxxxx>
> To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
> Sent: Monday, June 02, 2003 5:01 PM
> Subject: Local Currency Support
>
>
> >
> > We need to support multiple local currencies within the same
> environment.
> > The currencies need to be at the warehouse level. Applications 
installed
> > are
> > COM, CSM, PUR, IFM and Procurement Management.
> >
> >  We have a few ideas but are interested in others out there.
> >
> > Thanks in advance.
> >
> >
> >
> >
> >
> >
> >
> > _______________________________________________
> > 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.