Thank you very much.
We were headed this direction but also received a response from Leslie at Infor
By default, IFM maintains the value of each GL account in the financial division currency.    You can use the "Translate ledger balances" feature to calculate the value of each GL account in another currency too.  This feature is available in green-screen in menu AM5M49 option 7.    It is also available in IDF level 1 in Finance >  General Ledger > Other GL Tasks > General Ledgers > Translate GL Account Balances (FAS52).  After running the translation process you can see the account balances in both the financial division currency and the translation currency in Power-Link,  Finance > General Ledger > General Ledger Inquiry.  In the General Ledger Inquiry object you will have to create a custom view that includes a column for the "Translated value (translated currency)" attribute.  You can create ad-hoc analysis reports in Power-Link using that  data.  You can also create a more formal trial balance report based on the translated values using the IFM Extract and Analysis feature (menu AM5M50).

The above describes what's available in IFM standalone.  Other options for calculation, display and reporting are available when IFM is integrated with Enterprise GL application and/or the Infor reporting/BI applications.


We will give this a try also.
It is appreciated that you responded.  We're going to look at and consider both options.
Regards,Laura 
Laura A. Ubelhor
Consultech Services, Inc.
Phone 248-628-6800
Email ubelhor@xxxxxxxxxxxxx
www.consultechservicesinc.com

From: "McCracken, Rich" <rich.mccracken@xxxxxxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Sent: Tuesday, February 23, 2016 10:48 AM
Subject: Re: [MAPICS-L] IFM

To get a trial balance of all the account balances (unit/nature combinations in IFM), I suggest using either of 2 files for the values.  If you are using the IFM programs to translate the balances to a reporting currency, the Translated Value and the Financial Division Value are both in the general ledger summary file YABPREP.  These values could be used to create a trial balance in the financial division currency (period balances summarized by using the YTD periods on a Period Structure for the year).  That would be the simpler method.
We use a second method and create a trial balance using the general ledger lines file YAA7REP, because we want the ability to drill down to the detail transactions for analysis purposes.  The G/L lines file also has Transaction Value and transaction currency ID in case some of your AR or AP transactions were created in a difference currency and the original amount needs to be viewed.  Using this file will require the ability to bring in the value for the Cumulative Translation Adjustment from the G/L summary file YABPREP for the default unit/nature combination, because this value will not be on any transaction lines.  The default CTA unit/nature combination can be found in file YAC3REP, the financial division file.
Please let me know if you want more details for a solution.

Rich McCracken



Rich McCracken
Financial Systems Specialist
2400 MacArthur

Longview, TX 75603
United States

+1 903 237 7219 Phone
17219 Alternate

-----Original Message-----
From: MAPICS-L [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Laura Ubelhor
Sent: Monday, February 22, 2016 9:11 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] IFM

We would like to  generate the trial balance in another currency.
XA Powerlink is used within the  environment. Most of the accounting  transactions  are in either USD and CAD, we revalue between each by the exchange rate entered into IFM.
Does any one have a solution they use or suggestions on how to  accomplish  creating a trial balance  in both currencies?
Regards,Laura
Laura A. Ubelhor
Consultech Services, Inc.
Phone 248-628-6800
Email ubelhor@xxxxxxxxxxxxx
www.consultechservicesinc.com
--
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 electronic mail transmission contains information from Joy Global Inc. which is confidential, and is intended only for the use of the proper Addressee. If you are not the intended recipient, please notify us immediately at the return address on this transmission, and delete this message and any attachments from your system. Unauthorized use, copying, disclosing, distributing, or taking any action in reliance on the contents of this transmission is strictly prohibited and may be unlawful. Privacy-JGI



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.