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