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?
Laura A. Ubelhor
Consultech Services, Inc.
Phone 248-628-6800
Email ubelhor@xxxxxxxxxxxxx
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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at

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 On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.