Re: IFM
"McCracken, Rich" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <85AE6D39676F6C4B8CA4F27B7447878E46169113@CA1043APP.JGI.joyglobalinc.com> |
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-Zwy7GipZuJhWk0Htik3J/[email protected]] 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 [email protected] www.consultechservicesinc.com -- This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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 -- This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.